The LIST Command:
- This command may be used to determine which backups are currently available
- Displays details of backups of the database, tablespaces, datafiles, archived logs and control files
Examples:
1 2 3 4 5 6 7 8 | RMAN> LIST BACKUP BY BACKUP;orRMAN> LIST BACKUPSET BY BACKUP;orRMAN> LIST BACKUP BY BACKUP VERBOSE;RMAN> LIST COPY OF DATABASE;RMAN> LIST COPY OF TABLESPACE USERS;RMAN> LIST COPY OF DATAFILE 3; |
The REPORT Command:
- Helps a database administrator answer questions that are relevant to the backup and recovery strategy being implemented
- Some questions that are answered by the REPORT command are:
123
Which files areinneedofa backup?Which files are obsoleteandmay be deleted?Whatisthecurrentphysical structureofthedatabase,andwhat was itata previous pointintime?
Examples:
1 2 3 4 5 6 7 8 | RMAN>REPORT NEED BACKUP;RMAN> REPORT NEED BACKUP DAYS=7 DATABASE;RMAN> REPORT OBSOLETE;RMAN> REPORT SCHEMA;RMAN> REPORT NEED BACKUP RECOVERY WINDOW OF 2 DAYS DATABASE SKIP TABLESPACE TBS_2;RMAN> REPORT NEED BACKUP REDUNDANCY 2 DATAFILE 1;RMAN> REPORT NEED BACKUP TABLESPACE TBS_3; RMAN> REPORT NEED BACKUP INCREMENTAL 2; |
meda Edited answer 06/03/2022