NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

RMAN Useful Commands-LIST

No comments
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

No comments :

Post a Comment