- 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.
RECOVER an Image Copy of a Datafile to a Point in Time:
RMAN> RECOVER DATAFILECOPY 'D:\disk- \users.dbf' UNTIL TIME 'SYSDATE-7';
- 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: