http://psoug.org/reference/rman.html
SPOOL LOG TO /export/home/oracle/prv.lst;
RESTORE DATABASE FROM TAG DMCls -l PRD100720122239 PREVIEW SUMMARY;
restore database validate;
restore database from tag DMCls -l PRD100720122239 validate;
SPOOL LOG OFF;
select PIECE# ,HANDLE ,START_TIME,COMPLETION_TIME ,BYTES from V$BACKUP_PIECE where TAG =''
http://ss64.com/ora/rman_list.html
RMAN> LIST ARCHIVELOG ALL;
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
RMAN> LIST BACKUP OF DATAFILE 1;
RMAN> LIST BACKUP SUMMARY;
RMAN> LIST INCARNATION;
RMAN> LIST BACKUP BY FILE;
RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;
RMAN> LIST COPY OF DATAFILE 1, 2, 3;
RMAN> LIST BACKUP OF DATAFILE 11 SUMMARY;
RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
RMAN> LIST BACKUPSET OF DATAFILE 1;
RMAN> LIST FAILURE;
RMAN> LIST FAILURE 641231 detail;
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
RMAN> LIST BACKUP;
RMAN> LIST BACKUP OF DATABASE;
RMAN> LIST BACKUP OF DATAFILE 1;
RMAN> LIST BACKUP SUMMARY;
RMAN> LIST INCARNATION;
RMAN> LIST BACKUP BY FILE;
RMAN> LIST COPY OF DATABASE ARCHIVELOG ALL;
RMAN> LIST COPY OF DATAFILE 1, 2, 3;
RMAN> LIST BACKUP OF DATAFILE 11 SUMMARY;
RMAN> LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 1437;
RMAN> LIST CONTROLFILECOPY "/tmp/cntrlfile.copy";
RMAN> LIST BACKUPSET OF DATAFILE 1;
RMAN> LIST FAILURE;
RMAN> LIST FAILURE 641231 detail;
“I see no reason for recording the obvious” - Edward Weston
Related Commands:
BACKUP - Back up database files, archive logs, backups, or copies.
CHANGE - Update the status of a backup in the RMAN repository.
CROSSCHECK - Check whether backup items still exist.
DELETE - Delete backups from disk or tape
REPORT - Report backup status: database, files, backups
RESTORE - Restore RMAN backups and copies.
ADVISE FAILURE - Display repair options (11g Data Recovery Advisor)
REPAIR FAILURE - Repair database failures (11g Data Recovery Advisor)
BACKUP - Back up database files, archive logs, backups, or copies.
CHANGE - Update the status of a backup in the RMAN repository.
CROSSCHECK - Check whether backup items still exist.
DELETE - Delete backups from disk or tape
REPORT - Report backup status: database, files, backups
RESTORE - Restore RMAN backups and copies.
ADVISE FAILURE - Display repair options (11g Data Recovery Advisor)
REPAIR FAILURE - Repair database failures (11g Data Recovery Advisor)
Related Views:
RC_BACKUP_SET V$BACKUP_SET Backup sets RC_BACKUP_SPFILE V$BACKUP_SPFILE Server parameter files in backup sets RC_BACKUP_FILES V$BACKUP_FILES RMAN backups and copies in the repository. RC_BACKUP_PIECE V$BACKUP_PIECE Backup pieces Datafiles: RC_TABLESPACE V$TABLESPACE All tablespaces registered in the recovery catalog. RC_DATAFILE V$DATAFILE All datafiles registered in the recovery catalog RC_BACKUP_DATAFILE V$BACKUP_DATAFILE Datafiles in backup sets RC_DATAFILE_COPY V$DATAFILE_COPY Datafile image copies RC_PROXY_DATAFILE V$PROXY_DATAFILE Datafile backups created by proxy copy Control Files: RC_BACKUP_CONTROLFILE V$BACKUP_DATAFILE Control files in backup sets RC_PROXY_CONTROLFILE V$PROXY_DATAFILE Control file backups created by proxy copy RC_CONTROLFILE_COPY V$DATAFILE_COPY Control file copies on disk
RMAN> restore database preview;RMAN> restore database from tag FULL_BKP preview;RMAN> restore datafile 1, 2 preview;RMAN> restore archivelog all preview summary;RMAN> restore archivelog from time ’sysdate – 1/24′ preview summary;RMAN> restore archivelog from scn 25 preview summary;RMAN> restore database validate check logical;RMAN> restore database validate;RMAN> restore database from tag FULL_BKP validate;RMAN> restore datafile 1 validate;RMAN> restore archivelog all validate;RMAN> restore controlfile validate;RMAN> restore tablespace users validate;—————————————————————RMAN> validate backupset 112 check logical;Use the RMAN> list backup; command to obtain the backupset key (112 above)RMAN> validate database check logical;RMAN> validate database;
