Rman's Show,list,crosscheck,delete command

1. Show command:
Display RMAN configuration: rman> Show All;

2. Report command:
2.1. Rman> report schema reports the physical structure of the target database;
2.2, Rman>report need backup days=3; Reports data files that have not been backed up in the last 3 days;
2.3, rman> need backup days 3 tablespace users; Data files that were not backed up for 3 days on the Users table space;
2.4, rman> report need backup incremental 3; Report data files that require more than 3 incremental backups to recover data files;
2.5, rman> report need backup redundancy 2 database; Report all data files with less than 2 copies of the backup file;
Rman>report need backup redundancy=2;
2.6. Rman> report need backup recovery windows of 6 days; Report File Report recovery requires more than 6 days of archived log data files;
2.7, rman> report unrecoverable; Report all non-recoverable data files of the database;
2.8, rman> report obsolete redunndancy 2; Report obsolete backups with more than 2 backups;
2.9, Rman>report obsolete; Report redundant backups;

3. List command: List backup information
3.1. list data file backup sets
Rman> list backup lists detailed backups;
rman> list expired backup; list outdated backups;
Rman> list Backup of database; Lists the backup sets for all data files;
Rman> list Backup of tablespace User01; Lists all data file backup sets for a particular tablespace;
3.2. rman> list Backup of Controlfile lists the control file back up set;
3.3. rman> list Backup of Archivelog all lists the archive log backup set details;
Rman>list Archivelog All; List Archive Log backup sets brief information
3.4. rman> list Backup of SPFile lists spfile back up sets;
3.5. rman> list Copy of datafile 5 lists the image copy of the data file;
3.6. rman> list copy of Controlfile lists the control file image copy;
3.7. rman> list copy of Archivelog all lists the archived log image copies;
3.8, rman> list incarnation of the database list the corresponding/list of databases copies;
3.9, rman> list backup summary; Overview of available backups;
b indicates backup
F indicates full
A means archive log
0 1 indicates incremental backup
S description Backup status (A AVAILABLE X EXPIRED)

3.10. Rman>list Backup by file lists backups by backup type;
Follow data file backup, archive log backup, control file backup, server parameter file backup list

4. Crosscheck command: Verify backup information
4.1, rman> crosscheck backup check all backups set;
4.2, rman> crosscheck Backup of the database to check all data files of the back-up set;
4.3. rman> crosscheck Backup of tablespace users to check back-up sets of specific tablespace;
4.4, rman> crosscheck Backup of datafile 4 to check the specific data files of the back-up set;
4.5, rman> crosscheck Backup of controlfile Check the control files of the back-up set;
4.6, rman> crosscheck Backup of the SPFile check spfile back up set;
4.7, rman> Crosscheck backup of the Archivelog sequence 3 check the archive log of the back-up set;
4.8, rman> crosscheck Copy check all image copies;
4.9, rman> crosscheck copy of the database to verify the image copy of all data files;
4.10. rman> crosscheck Copy of tablespace users to check the image copy of a particular tablespace;
4.11, rman> crosscheck copy of datafile 6 to check the image copy of the specific data files;
4.12, rman> crosscheck copy of Archivelog sequence 4 Check the image copy of the archive log;
4.13, rman> crosscheck copy of controlfile Check the image copies of the control files;
4.14, rman> crosscheck backup tag= ' Sat_backup ';
4.15. rman> crosscheck backup completed after ' sysdate-2 '
4.16. rman> crosscheck backup completed between ' sysdate-5 ' and ' sysdate-2 '
4.17, rman> crosscheck backup device type SBT;
4.18, rman> crosscheck archivelog all;
4.19, rman> crosscheck archivelog like '%arc00012.001 '
4.20, rman> crosscheck archivelog from sequence 12;
4.21, rman> crosscheck archivelog until sequence 522;

5. Delete: Remove backup
5.1, rman> delete obsolete; Delete stale backups;
5.2, rman> delete expired backup; Delete Expired Backup
5.3, rman> delete expired copy; Delete expired copy;
5.4, rman> delete backupset 19; Delete a specific backup set;
5.5, rman> delete backuppiece "D:backupdemo_19.bak" Remove the specific backup slice;
5.6. Delete all backup sets by rman> delete backup;
5.7, rman> delete datafilecopy "D:backupdemo_19.bak" to remove a specific image copy;
5.8. rman> Delete Copy deletes all copies of the image;
5.9, rman> backup archivelog all delete input;
rman> backup backupset format = ' d:backup%u.bak ' Delete input
Delete the input object after the backup;

5.10, rman> delete backupset id; Delete a backup set

A consistent backup is a backup under the Sql>startup mount, and a non-conforming backup is a backup in the open state;

Rman's Show,list,crosscheck,delete command