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
Hi Craig,
What is the status of the database? Because the online database cannot be recovered.
Best regards,
James
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
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
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
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