BAckup problem

[Former Member]

hi All,

I am getting following arroe when go for while online backup :

BR0051I BRBACKUP 7.00 (33)

BR0055I Start of database backup: bdzthpcv.anf 2009-01-22 09.41.57

BR0484I BRBACKUP log file: /oracle/REP/sapbackup/bdzthpcv.anf

BR0477I Oracle pfile /oracle/REP/1022_64/dbs/initREP1.ora created from spfile /oracle/REP/1022_64/dbs/spfileREP1.ora

BR0280I BRBACKUP time stamp: 2009-01-22 09.41.58

BR1351I Configuration of database services:

BR0280I BRBACKUP time stamp: 2009-01-22 09.41.58

BR1352I Status of database services:

BR0280I BRBACKUP time stamp: 2009-01-22 09.41.59

BR0301E SQL error 1403 at location BrDbaCmdRun-11, SQL statement:

'SELECT NVL(FIRST_CHANGE#, 0) FROM V$LOG WHERE THREAD# = 2 AND SEQUENCE# = 7612'

ORA-01403: no data found

BR0056I End of database backup: bdzthpcv.anf 2009-01-22 09.41.59

BR0280I BRBACKUP time stamp: 2009-01-22 09.42.00

BR0054I BRBACKUP terminated with errors

Kindly suggest us for the same problem.

Regards,

Amit

[Former Member]

Hello,

I have the same problem.

The backup fails with the same errors on the second node of my RAC installation.

If I perform the backup on the first node, everything is ok.

Regards

[Former Member]

Hi,

If you are using 3rd party tool, can you please check the configuration parameter in initSID.utl file.

Regards,

Sachin Rane.

[Former Member]

Hi Amit,

Check the profile use for backup. Make sure you first initialize the tape before you start your backup.

Hope this help.

Regards,

Pranay

[Former Member]

hi,

we are using tape library .so already initailized by 3rd party tool.My backup profiles are same .

thanx,

Amit

[Former Member]

Hi Amit,

Please refer note 905359 and check you have proper configuration in initSID.sap file.

Regards,

Atil

[Former Member]

HiAtil,

That's O.k We already see all the parameters, env variables mentioned in that note.But not undeastand why we are getting this ;

'SELECT NVL(FIRST_CHANGE#, 0) FROM V$LOG WHERE THREAD# = 2 AND SEQUENCE# = 7612'

ORA-01403: no data found

Regards,

Amit

[Former Member]

Is this Oracle RAC ?

[Former Member]

Yes Joe,

we are using Oracle RAC.

-Amit

[Former Member]

How many instances are up and running?

Not sure about it, but from the error message, it seems that instance# 2 is only partly configured.

hope this helps

[Former Member]

Hi

Check out SAP note no. 849483, try updating Brtools with the lates version.

Regards

Rahul

[Former Member]

Hi All,

This is the error message :

'SELECT NVL(FIRST_CHANGE#, 0) FROM V$LOG WHERE THREAD# = 2 AND SEQUENCE# = 7612'

ORA-01403: no data found

Actually SEQUENCE# = 7612' is in THREAD = 1 but this is searchedTHREAD# = 2 by the process.

If this serach this sequence in THREAD=1 then my problem may be solved.But how ??

Regards,

Amit