Restore of Redologs from backup volume using BRTools 7.40 patch 29

[former_member204618]

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

[Reagan]

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

[former_member204618]

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

[JamesZ]

Hi Craig,

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

Best regards,
James

[former_member204618]

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

[JamesZ]

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