RMAN List Command
To list all existing backups :
RMAN> LIST BACKUP;
To list all existing database backups :
RMAN> LIST BACKUP OF DATABASE;
To list all existing backups of a specific datafile :
RMAN> LIST BACKUP OF DATAFILE;
For example:
RMAN> LIST BACKUP OF DATAFILE 4;
Alternatively specify the datafile name. For example:
RMAN> LIST BACKUP OF DATAFILE '/u01/app/oradata/COREDB/users01.dbf';
To list all existing archivelog backups :
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
To list all existing controfile backups :
RMAN> LIST BACKUP OF CONTROLFILE;
To list all existing SPFILE backups :
RMAN> LIST BACKUP OF SPFILE;
To list all archive logs :
RMAN> LIST ARCHIVELOG ALL;
To list the contents of an individual backup set :
RMAN> LIST BACKUPSET;
For example:
RMAN> LIST BACKUPSET 44;
To list all datafile image copies use:
RMAN> LIST DATAFILECOPY ALL;
To list an individual datafile image copy :
RMAN> LIST DATAFILECOPY;
For example:
RMAN> LIST DATAFILECOPY 26;
Alternatively specify the name of the datafile image copy file:
RMAN> LIST DATAFILECOPY '/u01/app/oracle/backup/users01.dbf';
To list all controlfile copies:
RMAN> LIST COPY OF CONTROLFILE;
For example:
RMAN> LIST COPY OF CONTROLFILE;
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
25 A 17-Apr-19 4325628 17-Apr-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_23qekadv
Tag: WEEK_BKPAPR19
20 A 17-AUG-19 4325628 17-AUG-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_1tqek8bd
Tag: WEEK_BKPAPR19
15 A 17-AUG-19 4325628 17-AUG-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_1nqek7j8
Tag: CONTROL_BKPAPR19
To list an individual control file copy :
RMAN> LIST CONTROLFILECOPY;
For example:
RMAN> LIST CONTROLFILECOPY 20;
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
20 A 17-AUG-19 4325628 17-AUG-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_1tqek8bd
Tag: WEEK_BKPAPR19
To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command. For example:
RMAN> LIST BACKUP OF TABLESPACE USERS;
The LIST INCARNATION command shows the incarnations of the database. Note that multiple incarnations may share the same database ID.
RMAN> LIST INCARNATION;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 COREDB 3456123892 PARENT 1 13-JAN-19
2 2 COREDB 3456123892 PARENT 995548 30-JAN-19
To list all existing backups :
RMAN> LIST BACKUP;
To list all existing database backups :
RMAN> LIST BACKUP OF DATABASE;
To list all existing backups of a specific datafile :
RMAN> LIST BACKUP OF DATAFILE
For example:
RMAN> LIST BACKUP OF DATAFILE 4;
Alternatively specify the datafile name. For example:
RMAN> LIST BACKUP OF DATAFILE '/u01/app/oradata/COREDB/users01.dbf';
To list all existing archivelog backups :
RMAN> LIST BACKUP OF ARCHIVELOG ALL;
To list all existing controfile backups :
RMAN> LIST BACKUP OF CONTROLFILE;
To list all existing SPFILE backups :
RMAN> LIST BACKUP OF SPFILE;
To list all archive logs :
RMAN> LIST ARCHIVELOG ALL;
To list the contents of an individual backup set :
RMAN> LIST BACKUPSET
For example:
RMAN> LIST BACKUPSET 44;
To list all datafile image copies use:
RMAN> LIST DATAFILECOPY ALL;
To list an individual datafile image copy :
RMAN> LIST DATAFILECOPY
For example:
RMAN> LIST DATAFILECOPY 26;
Alternatively specify the name of the datafile image copy file:
RMAN> LIST DATAFILECOPY '/u01/app/oracle/backup/users01.dbf';
To list all controlfile copies:
RMAN> LIST COPY OF CONTROLFILE;
For example:
RMAN> LIST COPY OF CONTROLFILE;
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
25 A 17-Apr-19 4325628 17-Apr-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_23qekadv
Tag: WEEK_BKPAPR19
20 A 17-AUG-19 4325628 17-AUG-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_1tqek8bd
Tag: WEEK_BKPAPR19
15 A 17-AUG-19 4325628 17-AUG-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_1nqek7j8
Tag: CONTROL_BKPAPR19
To list an individual control file copy :
RMAN> LIST CONTROLFILECOPY
For example:
RMAN> LIST CONTROLFILECOPY 20;
List of Control File Copies
===========================
Key S Completion Time Ckp SCN Ckp Time
------- - --------------- ---------- ---------------
20 A 17-AUG-19 4325628 17-AUG-19
Name: /u01/app/oracle/backup/cf_D-COREDB_id-3456123892_1tqek8bd
Tag: WEEK_BKPAPR19
To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command. For example:
RMAN> LIST BACKUP OF TABLESPACE USERS;
The LIST INCARNATION command shows the incarnations of the database. Note that multiple incarnations may share the same database ID.
RMAN> LIST INCARNATION;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 COREDB 3456123892 PARENT 1 13-JAN-19
2 2 COREDB 3456123892 PARENT 995548 30-JAN-19
Post a Comment
Post a Comment