Backup Recovery   «Prev 

Connect Target RMAN

LIST commands in Oracle

LIST COPY OF DATABASE ARCHIVELOG ALL;
The command displays all the archive log files and datafiles that have been backed up.

LIST BACKUP;
This command displays information about backup set and pieces (partial backups), the control files and the datafiles included within it.

LIST BACKUP OF DATABASE;
This command displays backups of all files within the database.

LIST COPY OF DATAFILE 'D:\ORACLE\ORADATA\PETS\INDX01.DBF';
This command lists copy of the specified datafile.

LIST BACKUP OF TABLESPACE SYSTEM;
This command lists all backups of the SYSTEM tablespace.

LIST COPY OF ARCHIVELOG ALL;
This command lists all archived redo logs and copies of logs.

Oracle Backup Recovery
LIST BACKUP OF CONTROLFILE;
This command lists all control file backups.

LIST BACKUP TAG 'WEEKLY_FULL_DB_BACKUP';
This command list all the backups by tag name.

LIST COPY LIKE 'D:\ORACLE\BACKUPS\OCB%';
This command lists all backups based on the filename patterns.

LIST BACKUP OF ARCHIVELOG UNITL TIME 'SYSDATE-30';
This command lists all backups by time.

LIST COPY OF DATAFILE 2 COMPLETED BETWEEN '10-MAR-2000' AND '17-MAR-2000';
This command lists all backups for a data range.