Recovery Catalog   «Prev  Next»

Lesson 5 Using the list command
Objective Use the list command.

Using Oracle List Command

In this lesson, you will learn how to use the list command. The list command provides information about your backup sets, file copies, and archived log files. Keep in mind that the report command provides a deeper analysis of the recovery catalog than the list command.

Syntax and examples

Below are the more frequent uses of the list command. To obtain a detailed listing, please refer to the Oracle8 documentation.
When you use the list command, you must connect to both the target database and the recovery catalog. Following the previous examples, this would be: 

rman80 target system/manager@mydb 
rcvcat rman/rman@mydb

Backup sets and data file copies

The following syntax can be used to list information on backup sets and copies of data files for your database or a specific tablespace. It can also be used to list backup sets and copies containing a specific range of archived log files. Below is a review of the basic syntax of the list command. 

list <option1> of <option2> <values>

option1 {copy, backupset}
option2 {datafile 'string', tablespace 'string', database, archive all}
Values tag='string'
devicetype 'string'
like 'string'
from time='string'
until time='string'

Oracle Backup Recovery
You can use the list command for the following:
  1. To list all file copies or backup sets of your database:
    list copy of database list backupset of database
    1. To list a specific data file:
      list backupset of datafile 'C:\oracle8\database\usrorc1.dbf'

Incarnations

To list incarnation information about your database, use:
list incarnation of <values>

To list all the incarnations of your database, use: 
list incarnation of database mydb

The SlideShow below provides examples of the list command:


  1. This is an example of the list copy of database command.
  2. This is an example of the list copy of datafile command.
  3. This is an example of the list incarnation command.

Oracle List Command
In the next lesson, you will learn about stored scripts.

Oracle Report Commands

Click the link below to read about the Oracle report command syntax.
Oracle Report Commands