BR0301W SQL error -1012 at location db_file_switch-15, SQL statement:

[Former Member]

Dear all ,

offline Backup finished with error .

kindly find the below logs

#BEGIN /oracle/IRP/sapdata3/undo_1/undo.data1

BR0280I BRCONNECT time stamp: 2010-02-07 03.00.28

BR0307I Shutting down database instance IRP ...

BR0280I BRCONNECT time stamp: 2010-02-07 03.02.39

BR0308I Shutdown of database instance IRP successful

BR0280I BRCONNECT time stamp: 2010-02-07 03.02.39

BR0301W SQL error -1012 at location db_file_switch-15, SQL statement:

'SELECT NVL(BYTES, 0) FROM DBA_DATA_FILES WHERE FILE_ID = 2'

ORA-01012: not logged on

BR0280I BRCONNECT time stamp: 2010-02-07 03.02.39

BKI0023I: Time: 02/07/10 03:04:09 Done: 9.766 GB (6.8 %) of 142.774 GB. Estimated end time: 02/07/10 03:58:24.

BKI0053I: Time: 02/07/10 03:04:09 Object: 1 of 46 done: /oracle/IRP/sapdata3/undo_1/undo.data1 with: 9.766 GB saved with description IRP___A0G5CX5F1D.

BR0280I BRCONNECT time stamp: 2010-02-07 03.04.11

#END /oracle/IRP/sapdata3/undo_1/undo.data1

BR0280I BRCONNECT time stamp: 2010-02-07 03.04.11

BR0280I BRBACKUP time stamp: 2010-02-07 03.04.11

#FILE..... /oracle/IRP/sapdata3/undo_1/undo.data1

#SAVED.... IRP___A0G5CX5F1D

BKI0027I: Time: 02/07/10 03:04:11 Object: 2 of 46 in process: /oracle/IRP/sapdata2/sr3700_5/sr3700.data5 Size: 4.336 GB, MGMNT-CLASS: WEEKLYMGMTCLASS, TSM-Server: PRODORADB_TDP@10

BR0280I BRCONNECT time stamp: 2010-02-07 03.04.13

#BEGIN /oracle/IRP/sapdata2/sr3700_5/sr3700.data5

BR0280I BRCONNECT time stamp: 2010-02-07 03.04.13

BR0301W SQL error -1012 at location db_file_switch-15, SQL statement:

'SELECT NVL(BYTES, 0) FROM DBA_DATA_FILES WHERE FILE_ID = 28'

ORA-01012: not logged on

regards

[Former Member · Accepted solution]

Hi

Have a look at note : 1235951

what version of the Brtools are you running ?

Mark

[Former Member · Accepted solution]

Hi

we are using BRTOOLS version is 7.00 (34)

kindly suggest

[former_member204746]

This looks like a bug. brbackup shuts down the DB... and then it interrogates it? looks weird!

go get a newer version and try again.