What's the difference between BRRESTORE & BRRECOVER

[Former Member]

In BRTools, there are BRRESTORE & BRRECOVER, which can restore database. I am not sure what's difference with them, and I have not found clear definition about these. I guess that BRRESTORE just restores files(data, control, redo, etc) from media to disk, and BRRECOVER restore database to a particular time point according to these files restored by BRRESTORE. I am not sure whether my thought is right. Please advise more details. Thanks.

James

[Former Member · Accepted solution]

The program BRRESTORE can restore all files belonging to the

database system from the backups, that is both database files and

offline redo log files.

The interactive program BRRECOVER checks the database for

missing files, calls BRRESTORE for restoration of missing data files or

for restoration of offline redo log files needed for recovery, performs

the recovery, and opens the database.

[fidel_vales]

Hi,

you are correct.

BRRESTORE only "copies" the data from the backup location (tape/disk) to the disk.

BRRECOVER does the full recover process:

- ask you the kind of recovery you want

- calls BRRESTORE to get the files

- recovers the database.

for detailed information, check th eonline help:

• [BRRESTORE|http://help.sap.com/saphelp_nw70/helpdata/EN/88/cadaca94734ae5b8ea3491f615741b/frameset.htm]

> This SAP tool enables you to restore an entire database backup or parts of it, when the backup was performed with Structure linkBRBACKUP.

• [BRRECOVER|http://help.sap.com/saphelp_nw70/helpdata/EN/cd/80e67d94460e4fb0b3e9ca89967e47/frameset.htm]

> The SAP tool BRRECOVER for Oracle databases is used as a database administration tool to help you recover your database.