Skip to Content
0

Restore of Redologs from backup volume using BRTools 7.40 patch 29

Jun 01, 2017 at 10:37 AM

139

avatar image

Hi All,

I am trying to restore some redologs from the backups to correct a gap on the standby database using BRTools. But no matter which option I choose it complains

BR0342I Database instance PRD is started and open 
BR0068E SAP system is running or SAP user is connected to database instance PRD
BR1025I Please shut down SAP system first or use the '-c force' option

Is this correct? Do I really need to use the -c option?

If I call brrestore directly such as :-

brrestore -a 7682-7698 -p initPRD_ArchDisk.sap

It doesn't complain.

Am I missing something here?

Thanks

Craig

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Zhang
Jun 02, 2017 at 07:00 AM
0

Hi Craig,

What is the status of the database? Because the online database cannot be recovered.

Best regards,
James

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

Hi James,

I'm not trying to recover the database I am simply trying to restore some redo logs that are missing from the standby.
There was a problem with the network and before we realised the redo logs were backed up and deleted from the primary, so were never shipped to the standby after the network glitch was corrected.

Thanks
Craig

0

Hi Craig,

Can you share the complete brrestore log?

Do not use -c option, I am afraid, -c will force a restore....

Best regards,
James

0
Reagan Benjamin
Jun 07, 2017 at 12:59 PM
0

Are you using the right .sap/.utl file for the restore of archive logs? Technically there is no need to shutdown the database to restore the archive logs. I have restore the archive logs and the command I used was

brrestore -u / -p /oracle/SID/112_64/dbs/initSID_redologs.sap -d util_file -a 198630-198640

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

Hi Reagan,

Yes I used brrestore in the end, but I wanted to know how we get to that from within BRTools. Every option I chose resulted in it asking me to use the -c option.

Thanks

Craig

0