Skip to Content
avatar image
Former Member

BRRestore:Failure of Set command and database not mounted

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 18, 2017 at 12:41 AM

    Hi,

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

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 19, 2017 at 04:41 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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

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

    Delete the lock and rerun the backup

    Add comment
    10|10000 characters needed characters exceeded