RMAN Command List

-

 

Database

The LIST command allows the backup data to be listed in the RMAN utility

To list all existing backups use:

RMAN> LIST BACKUP;

To list all existing database backups use:

RMAN> LIST BACKUP OF DATABASE;

To list all existing backups of a specific datafile use:

RMAN> LIST BACKUP OF DATAFILE <file#>;

For example:

RMAN> LIST BACKUP OF DATAFILE 4;

Alternatively specify the datafile name. For example:

RMAN> LIST BACKUP OF DATAFILE '/u01/app/oradata/TEST/users01.dbf';

To list all existing archivelog backups use:

RMAN> LIST BACKUP OF ARCHIVELOG ALL;

To list all existing controfile backups use:

RMAN> LIST BACKUP OF CONTROLFILE;

To list all existing SPFILE backups use:

RMAN> LIST BACKUP OF SPFILE;

Archive Logs

To list all archive logs use:

RMAN> LIST ARCHIVELOG ALL;

Backup sets

To list the contents of an individual backup set use:

RMAN> LIST BACKUPSET <key>;

For example:

RMAN> LIST BACKUPSET 44;

Datafile Image Copies

To list all datafile image copies use:

RMAN> LIST DATAFILECOPY ALL;

To list an individual datafile image copy use:

RMAN> LIST DATAFILECOPY <key>;

For example:

RMAN> LIST DATAFILECOPY 26;

Alternatively specify the name of the datafile image copy file:

RMAN> LIST DATAFILECOPY '/u01/app/oracle/copy/users01.dbf';

Controlfile Image Copies

To list all controlfile copies use

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 15-AUG-15       3324254    15-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_23qekadv
        Tag: TAG20150815T001910

20      A 14-AUG-15       3322965    14-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_1tqek8bd
        Tag: TAG20150814T234341

15      A 14-AUG-15       3322589    14-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_1nqek7j8
        Tag: TAG20150814T232907

To list an individual control file copy use:

RMAN> LIST CONTROLFILECOPY <key>;

For example:

RMAN> LIST CONTROLFILECOPY 20;

List of Control File Copies
===========================

Key     S Completion Time Ckp SCN    Ckp Time
------- - --------------- ---------- ---------------
20      A 14-AUG-15       3322965    14-AUG-15
        Name: /u01/app/oracle/copy/cf_D-TEST_id-2066695660_1tqek8bd
        Tag: TAG20150814T234341

Tablespaces

To list backups of a tablespace use the LIST BACKUP OF TABLESPACE command. For example:

RMAN> LIST BACKUP OF TABLESPACE USERS;

Incarnations

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       TEST     2066695660       PARENT  1          17-SEP-11
2       2       TEST     2066695660       PARENT  995548     30-NOV-11
3       3       TEST     2066695660       ORPHAN  1190860    09-FEB-12
4       4       TEST     2066695660       CURRENT 1190860    09-FEB-12

Comments

Post a Comment

Popular posts from this blog

Check the Oracle Database size of non CDB, CDB and PDB

-
Image
Queries for the non-CDB databases- on Check the Oracle Database size CDB and PDB Following Queries for NON-CDB database: Check the database physical consumed size select sum(bytes)/1024/1024/1024 size_in_gb from dba_data_files; Total space used by the data in the database. select sum(bytes)/1024/1024/1024 size_in_gb from dba_segments; Check the size of the User or Schema in Oracle database. select owner, sum(bytes)/1024/1024/1024 Size_GB from dba_segments group by owner; Find free space and used space in the Oracle database. select "Reserved_Space(MB)", "Reserved_Space(MB)" - "Free_Space(MB)" "Used_Space(MB)","Free_Space(MB)" from( select (select sum(bytes/(1014 1024)) from dba_data_files) "Reserved_Space(MB)", (select sum(bytes/(1024 1024)) from dba_free_space) "Free_Space(MB)" from dual ); Check overall size of database,temp and redo file. select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) + ...
Read more

Kill or Release PORT of LISTENER which is already in use

-
Port No. : 1521  sudo kill -9 $(sudo lsof -t -i :1521) OR [root@test ~]# sudo netstat -tulnp | grep 1521 tcp        0      0 127.0.0.1:1521          0.0.0.0:*               LISTEN      3168/tnslsnr [root@test ~]# sudo ss -tulnp | grep 1521 tcp   LISTEN 0      128         127.0.0.1:1521       0.0.0.0:*    users:(("tnslsnr",pid=3168,fd=8)) [root@test ~]# sudo kill -9 3168 [root@test ~]# sudo ss -tulnp | grep 1521
Read more

Confusion of Service Name in Oracle Networking in 12c,19c, 21c,23c Oracle Database

-
Image
********For Connection through SQL Developer (or any IDE) using service name *************  Let Suppose, sid,db_name,db_unique_name,instance_name = oradb (are same by default installation in Single Instances) service_names (in DB) =oradb (by default)  Suppose, we set service names (in DB) = ora 1. Service name inside oracle database. show parameter service_names; 2. Global names should be same in case of Static Listener.  3. For Connection through SQL developer using service should match above criteria. Service name = " ora " will be used   ******************For Connection through " tnsnames.ora " alias name ********************* Let Suppose, SID = oradb service_names (in DB) =oradb (by default)  Suppose, we set service names (in DB) = ora We can give Alias name in tnsnames.ora file whatever like oradb, but there service name must be the ora. If we set service name in tnsnames.ora or in db. We must bounce the Listener. For Testing TNS connection is working...
Read more