Tuesday, August 9, 2011

"RECOVER" and "REPORT" command


RECOVER

Purpose:
- Performing complete recovery of one or more restored datafiles, or the entire database.
- Applying incremental backups to a datafile image copy (not a restored datafile) to roll it forward in time.

==> When performing media recovery, RMAN first looks for archived logs on disk, and if none are available, then it restores logs from backups to the LOG_ARCHIVE_DEST_- destination (or the SET ARCHIVELOG DESTINATION) as needed for the recovery.

Examples:

RECOVER an Image Copy of a Datafile to a Point in Time: 

RMAN> RECOVER DATAFILECOPY 'D:\disk- \users.dbf' UNTIL TIME 'SYSDATE-7';


REPORT

Purpose:
- It is used to perform detailed analyses of the RMAN repository.


Use the REPORT command to answer the below questions:

- Which files need a backup?
- Which files have not had a backup for some time?
- Which files are not recoverable due to unrecoverable operations?
- Which backup files can be deleted?
- What was the physical schema of the database at a previous time?

Reporting Database Schema:

It reports the names of all datafiles and tablespaces one week ago.

REPORT SCHEMA AT TIME 'SYSDATE-7';

Reporting Datafiles Needing Incremental Backups: Below command reports all datafiles in the database that require the application of five or more incremental backups to be recovered to their current state:

REPORT NEED BACKUP INCREMENTAL 5 DATABASE;


Reporting Unrecoverable Datafiles:Below command reports all datafiles that cannot be recovered from existing backups because redo may be missing: 

REPORT UNRECOVERABLE;

Enjoy:-)