Scribd Logo
Upload

Welcome to Scribd!

  • 61 views

    Rman Command List

    Uploaded by

    Raihan
    The LIST command in RMAN allows you to view existing backups. You can list backups of the whole database, individual datafiles, archived logs, backup sets, datafile image copies, control file copies, tablespaces, and database incarnations. For each type of backup, the document provides the RMAN syntax to list it, such as LIST BACKUP OF DATABASE to view all database backups.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Rman Command List

    Uploaded by

    Raihan
    61 views3 pages
    The LIST command in RMAN allows you to view existing backups. You can list backups of the whole database, individual datafiles, archived logs, backup sets, datafile image copies, control file copies, tablespaces, and database incarnations. For each type of backup, the document provides the RMAN syntax to list it, such as LIST BACKUP OF DATABASE to view all database backups.

    Original Title

    RMAN COMMAND LIST

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The LIST command in RMAN allows you to view existing backups. You can list backups of the whole database, individual datafiles, archived logs, backup sets, datafile image copies, control file copies, tablespaces, and database incarnations. For each type of backup, the document provides the RMAN syntax to list it, such as LIST BACKUP OF DATABASE to view all database backups.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    61 views3 pages

    Rman Command List

    Uploaded by

    Raihan
    The LIST command in RMAN allows you to view existing backups. You can list backups of the whole database, individual datafiles, archived logs, backup sets, datafile image copies, control file copies, tablespaces, and database incarnations. For each type of backup, the document provides the RMAN syntax to list it, such as LIST BACKUP OF DATABASE to view all database backups.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    RMAN List Command http://www.juliandyke.com/Research/RMAN/ListCommand.

    php

    Welcome Projects Presentations Research

    RMAN List Command


    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>;

    1 of 3 8/17/2020, 8:40 AM
    RMAN List Command http://www.juliandyke.com/Research/RMAN/ListCommand.php

    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


    ===========================

    2 of 3 8/17/2020, 8:40 AM
    RMAN List Command http://www.juliandyke.com/Research/RMAN/ListCommand.php

    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

    3 of 3 8/17/2020, 8:40 AM

    You might also like