Whole database reset Vs complete database recovery

[former_member199632]

hi,

Whats the difference between Whole Database Reset with BR*Tools  and Complete Database Recovery with BR*Tools

What are the situations that , we have to use whole db reset & complete db recovery?

I have gone through these two links as well; But unable to get clear idea.

http://help.sap.com/saphelp_nw2004s/helpdata/en/73/029e8ddd57f5408b62204da040bf8e/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f1/9d0712466515469d42b8c2c6aeb669/content.htm

please clarify;

regards,

zerandib

[former_member206552]

hi zerandib

Whole Database Reset

http://help.sap.com/saphelp_nw04/helpdata/DE/31/f8e63bed8a6126e10000000a114084/content.htm

Use

This section tells you about resetting your Oracle database after a failure. You normally need to do this if either of the following applies:

        An error  occurred in which all copies of the redo log files are lost, but the database file backup is available.

        You performed a complete offline backup or a consistent online backup immediately before the error, such as during a software upgrade.

With this function you can reset the database to a previous consistent state, at the time of either a complete offline or a consistent online backup. If you reset from an online backup, the consistent end point of the backup is used.

Complete Database Recovery

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/2ddf3bbcce4b37e10000000a114084/content.htm

Use

This section tells you about restoring damaged or lost data files after a failure in your Oracle database, and then recovering the database to the time of failure. You normally do this after a media error, such as a disk crash. With this function you can:

...

1.           Restore lost data files by using appropriate backups

     2.      Recover the restored data file to the time of failure using the redo log files

best regards

marius

[Former Member]

Hello zerandib,

the wording by SAP is very poor and hard to understand. I would formulate it differently:

Whole Database Reset with BR*Tools = Recovery with data loss. You do not recover to the latest point in time but to some consistent state in the past. Any subsequent changes are lost. (This scenario is typically avoided at all costs and rarely happens in real life with real productive systems.)

Complete Database Recovery with BR*Tools = Complete recovery, i.e. no data loss. Your database is recovered to the latest consistent state.

Regards,

Mark