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:
- To list all file copies or backup sets of your database:
list copy of database list backupset of database
- 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:
- This is an example of the list copy of database command.
- This is an example of the list copy of datafile command.
- 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