Restarting a BRRECOVER database recovery.

[pradeepkumar_singapuri2]

We use BRRECOVER to restore and rename a database as part of our system copy / overlay process.

We have had several occasion where BRRECOVER fails after it has restored all the data files and was performing a point-in-time recovery.

Running the BRRECOVER command again will restore all the data files again and many more hours of restore time.

In our case, failure of BRRECOVER is usually not being able to find the redo log files on TAPE.

We would then manually restore the redo log files from TAPE (after locating and mounting the TAPE) before running the BRRECOVER command again.

Now, BRRECOVER has a restartable mode. You can use the following command to skip restore of data files.

brrecover -c force -t dbpit -b <backupfilename>.anf -f <target_SID> -pit "2012-05-07 15.00.00" -SDR

The -SDR option is skip datafile restore. You can also refer to SAP Note 1441450

Hope the above helps in making your BRRECOVER process more efficient.