Brtools recovery - restart possible?

[Former Member]

Hello,

If you are using brtools for recovery, and while you are restoring datafiles from tape your unix session dies, is it possible to open a new unix session and proceed with brtools and the recovery/restore at the moment of the failure?

An example whould be a 2 Terabytes database recovery process, where the restore of the datafiles might take hours and you can only work remotely.

Thanks

[Former Member]

Hi Zigor,

Yes its posible, brtools can continue to the last backup/restore using option

<b>-f</b> (fullfill)

For example you last restore log file was <b>abcdefg.ssd</b>

than you just need to type

<b>brrestore -p init<SID>.sap -m full -f abcdefg.ssd</b>

Than brtools will contine the last action and will not do the restore from begining.

Hope this help.

Fendi Suyanto

[Former Member]

Hi

It sounds like you need "GNU screens". It's an ASCII terminal emulator which allows you to open multiple windows through the one telnet connection. The best thing is that if you lose your connection, you can RECONNECT to your previously running Screen (like terminal server sessions only ascii based).

Here is a link to a Screen Introduction Page :

http://www.kuro5hin.org/story/2004/3/9/16838/14935

Regards

Doug

[Former Member]

Zigor,

If you are restoring big databases, I would rather use the command line options of brtools and send it in to background (just in case you terminal session gets terminated or remote connection is lost).

Thanks.

regards,

BMG

[former_member204746]

you can use brrestore to restore individual files or individual tablespaces such as :

brrestore -u / -c -b bdvpmssy.aff -p initPRD_refresh.sap

-m H:\ORACLE\PRD\SAPDATA1\MSEGD_3\MSEGD.DATA3

brrestore -u / -c -b bdvpmssy.aff -p initPRD_refresh.sap

-m PSAPCLUD