Wednesday, 7 November 2012

Brrestore from point of termination

Hello,

Welcome back, here is the below with a very important knowledge sharing

some times for huge databases, we face problems with tape or disk and if it get fails at 90 or 95%, then we will have to restore the entire database again. 
This is no more needed, there is an option to restore from the point of termination in brtools. Use below command to do this; 

brrestore -b <backuplogfile> -d <utl/disk/tape> -c force -r <utl file path> -m full -l E -f <restoration log file>

Example of this is --> 

brrestore -b bejczqjj.anf -d util_file -c force -r /oracle/TST/112_64/dbs/initTST.utl -m full -l E -f rejedtge.rsb

This will check for all files restored correctly and which are not restored as per the log file provided (rejedtge.rsb). compares it with backup (logfile provided --> bejczqjj.anf). Restores only files which are not restored correctly. 

This saves time as well as we dont have to restore entire backup if restore fails due to any reason. 
This has been tested in real time scenario and it works well

Be happy and Enjoy.......

Request you to for comments on this.........

No comments:

Post a Comment

Share

Widgets