Skip to main content
Question

Oracle Log Backup Failure


Forum|alt.badge.img+9

Hi All,

The below error is logged in during the Archive Log backup.

Set pending cause [Subclient threshold condition is not met. The total available instance streams ([0]) for Backup is less than [log] threshold value ([1]).]

 

The below is logged in the log file ClOraAgent.log.

277451 43bcb 10/30 06:25:36 12141654 ClOraAgent::GetBackupUserRole() - Unable to connect as sysdba output = [

SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 30 06:25:35 2023

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

SQL> SQL> SQL> SQL> ERROR:

ORA-01031: insufficient privileges

SQL> SQL> SQL> SQL> SQL> USER is ""

SQL> ]

277451 43bcb 10/30 06:25:36 12141654 ClOraAgent::GetBackupUserRole() - alternating to sysbackup

277451 43bcb 10/30 06:25:36 12141654 ::GetNlsLang() - fetching registry key NLS_LANG

277451 43bcb 10/30 06:25:36 12141654 ::GetNlsLang() - registry key NLS_LANG not set therefore setting NLS_LANG to American_America.US7ASCII

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::SetPostForkParam() - Parent path = /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/sqlplus

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::SetPostForkParam() - Parent oraUser = oracle

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::InitializeUnix() - Parent: child process pid= 277553

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::Wait() - Child OK

277451 43bcb 10/30 06:25:36 12141654 OraChildProcess::Wait() - Child OK

277451 43bcb 10/30 06:25:36 12141654 ClOraAgent::GetBackupUserRole() - Successfully Connecting to Oracle as sysbackup

277451 43bcb 10/30 06:25:36 12141654 OraAgentBase20::BrowseInit(5752) - Initialize0(oraUser[oracle] oraHome=[/u01/app/oracle/product/12.2.0.1/dbhome_1] oraSID=[cloprd011])

 

 

 

277451 43bcb 10/30 06:25:49 12141654 RacBrowser::RecvBrowseResponse() - browse response...

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - errMsg=[Error from Browse:p    U.]

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - IsSetJPR = [FALSE]

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - IsAlreadySent = [FALSE]

277451 43bcb 10/30 06:25:54 12141654 RecvBrowseResponse() - Error with Stack[0xECCC065B:{RacBrowser::RecvBrowseResponse(945)/ErrNo.1627.(Unknown error 1627)-Error from Browse:p    U.}]

277451 43bcb 10/30 06:25:54 12141654 RacBrowser::BrowseInstances() - error getting RAC instance status:0xECCC065B:{RacBrowser::RecvBrowseResponse(945)/ErrNo.1627.(Unknown error 1627)-Error from Browse:p    U.}

277451 43bcb 10/30 06:25:54 12141654 RacBrowser::BrowseInstances() - this RAC instance is not reachable at this time

 

 

The user configured in the connection string is attached to the “SYSBACKUP” role.

Why would an attempt be made to use SYSDBA if the user does not have that permission?

Why would the instance be unreachable if it was able to connect with the user and SYSBACKUP role?

 

After investigation, it turns out that the Commvault user is locked on the instance/db. As soon as the user is unlocked then the backup completes successfully. Why would this user be getting locked? What causes failed logins? Could it be because it attempts to use SYSDBA role first?

Cheers.

Ignes

 

 

8 replies

Forum|alt.badge.img+3

Hi Ignes,

can you share the output of the below query from DB,

 

select * from v$pwfile_users;

 

Regards,

Karthikeyan K


Forum|alt.badge.img+9
  • Author
  • Byte
  • 51 replies
  • October 31, 2023

Hi Karthikeyan,

See output below of commands.

 

The above is the same for all nodes configured in the instance.

Should the “as sysbackup” section be added in the configuration below?

 

Regards,

Ignes

 


Forum|alt.badge.img+3

Hello Ignes,

This has to be analyzed with completed set of logs.

It’s better if you can come up with a case.

Regards,

Karthikeyan K


Forum|alt.badge.img+9
  • Author
  • Byte
  • 51 replies
  • November 1, 2023

Hi Karthikeyan,

I will open a case for this then.

Thank you.

Ignes

 


Forum|alt.badge.img+6
  • Byte
  • 16 replies
  • September 17, 2024

Hi @Iggy ,

Did you get any resolution for this issue?

If yes, could you please share it here


Forum|alt.badge.img+9
  • Author
  • Byte
  • 51 replies
  • September 17, 2024

Hi @backup ,

A CMR was logged for this and the fix should be included in SP36 (2024E) according to the feedback received. The LTS date for this version is 15 Nov 2024.

 

Cheers.

Ignes

 


Forum|alt.badge.img+6
  • Byte
  • 16 replies
  • September 17, 2024

Thanks for the update @Iggy 

Any hotfix in SP32 for this issue? Any idea?


Forum|alt.badge.img+9
  • Author
  • Byte
  • 51 replies
  • September 17, 2024

@backup ,

I requested for it to be included in SP32 but it was not.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings