By default, restore jobs that you perform from the CommCell Console resume from the beginning of the job. To restart the restores from the point of failure use the command line brrestore procedure.
Restart Data Restores from the Failure Point for In-Place and Out-of-Place Restores
Use the following commands to restore the remaining files from the latest backup job. You can view the BR*Tools log files for the CommCell Console restores to see what data was partially restored.
The details files are generally located on the client in the sapbackup folder.
brrestore -d util_file -f <restore detail file> -c force -u /
Example
brrestore -d util_file -f rewtbpjz.rsb, rewtbqls.rsb -c force -u /
Restore from a Point-in-Time Backup Job
Use the following commands to restore the remaining files from a point-in-time backup job.
brrestore -d util_file -b <backupdetail file> -f <previousrestored data detail file> -c force -u /
Example
brrestore -d util_file -b bewtloeq.anf -f rewtbpjz.rsb, rewtbqls.rsb -c force -u /
Rman_util
Use the following commands to restore the files from the point of failure. Check the detail file and find the files that need to be restored.
brrestore -d rman_util -m '<datafile path>’,’ <datafile path>’, -c force -u /
Example
brrestore -d rman_util -m '/database/oracle114/app/oracle/product/11.2.0/dbhome_1/CER/sapdata1/system_1/test2126_01.dbf', '/database/oracle114/app/oracle/product/11.2.0/dbhome_1/CER/sapdata1/btabd_1/btabd.data2' -c force -u /
Restore the Archive Logs for In-Place and Out-of-Place Restores with the Same Directory Structure as the Source
Util_file
Use the following commands to restore the remaining files.
brrestore -d util_file -f <log restore detailfile> -a <startlogrange>-<endlogrange> -c force -u /
Example
brrestore -d util_file -a 120-250 -c force -u /
Rman_util
brrestore -d util_file -a <startlogrange>-<endlogrange> -c force -u /
Restore the Archive Logs for Out-of-Place Restores with a Different Directory Structure from the Source
Util_file
Use the following commands to restore the remaining files.
brrestore -d util_file -f <log restore detailfile> -a <startlogrange>-<endlogrange> =<destination archivelog directory> -c force -u /
Example
brrestore -d util_file -f rewuobix.rsa -a 179-192=-/database/oracle114/app/oracle/product/11.2.0/dbhome_2/CER/saparch/CERarch -c force -u /
Rman_util
Use the following commands to restore the remaining files.
brrestore -d rman_util -a <startlogrange>-<endlogrange> =<destination archivelog directory> -c force -u /
Example
brrestore -d rman_util -a 179-192=-/database/oracle114/app/oracle/product/11.2.0/dbhome_2/CER/saparch/CERarch -c force -u /
If you need to rename a datafile, then create an SQL script that contains all data file rename commands. Then, run the script by connecting to sqlplus.