Skip to Content
0

BRRestore:Failure of Set command and database not mounted

Sep 15, 2017 at 09:14 PM

93

avatar image
Former Member

Hi Team,

While trying to restore from tape to Dev environment i am getting below error:

Inline image 1

i have copied back<SID>.log and <backupfile>.ant and init<SID>.sap file from PRD to DEV .

Please help me with some inputs.

Regards

VR

10 |10000 characters needed characters left characters exceeded

There is no error in your initial post? Could you post the complete restore log?

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

James Zhang
Sep 18, 2017 at 12:41 AM
0

Hi,

Please share us with the error, also attach the complete trace.

Best regards,
James

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 19, 2017 at 04:41 PM
0

Hi James,

Please find below error log:

"RMAN> connect target * connected to target database: DEV (not mounted) using target database control file instead of recovery catalog RMAN> **end-of-file** RMAN> host command complete RMAN> 2> 3> 4> 5> allocated channel: sbt channel sbt: sid=82 devtype=SBT_TAPE channel sbt: MMS Version 7.0.24.4 executing command: SET NEWNAME released channel: sbt RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at 09/14/2017 18:59:02 ORA-01507: database not mounted RMAN> Recovery Manager complete. BR0278I Command output of 'BRSBTLIB': #LOCK /oracle/DEV/sapbackup/.lockb.brr #TAPE /dev/rmt1.1 BR0280I BRRESTORE time stamp: 2017-09-14 18.59.02 BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1 BR0536E RMAN call for database instance DEV failed BR0280I BRRESTORE time stamp: 2017-09-14 18.59.02 BR0553E Restore from normal database backup using RMAN failed BR0359E Restore of /oracle/PRD/sapdata1/sr3_1/sr3.data1 from /dev/rmt1.1 failed due to previous errors BR0406I End of file restore: rewshuar.rsb 2017-09-14 18.59.02 BR0280I BRRESTORE time stamp: 2017-09-14 18.59.02 BR0404I BRRESTORE terminated with errors".

Kindly let me know the inputs.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

would you please attach trace? The error format is bad...

Anyway what if you manually mount the database?

sqlplus > startup mount

0
avatar image
Former Member Sep 29, 2017 at 07:19 PM
0

#LOCK /oracle/DEV/sapbackup/.lockb.brr

Delete the lock and rerun the backup

Share
10 |10000 characters needed characters left characters exceeded