"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:-)