Oracle9i Recovery Manager Reference Release 1 (9.0.1) Part Number A90136-02 |
|
RMAN Commands , 32 of 60
listObjectSpec::=
listBackupOption::=
To display information about backup sets, proxy copies, and image copies recorded in the repository. The LIST
command displays the files against which you can run CROSSCHECK
and
DELETE
commands.
Use this command to list:
EXPIRED
in the RMAN repository
RMAN records the output to either standard output or the message log, but not to both at the same time. You can control how the output is organized (BY
BACKUP
or BY
FILE
) as well as the level of detail in the output (VERBOSE
or SUMMARY
).
See Also:
Oracle9i Recovery Manager User's Guide to learn how to make lists and reports, and "cmdLine" |
LIST
only at the RMAN prompt.
INCARNATION
option requires the use of a recovery catalog.
NOCATALOG
mode, then the database must be mounted. If you connect to a recovery catalog, then the target instance must be started (but it does not need to be mounted).
|
Displays information about the incarnations of a database.
The
See Also: Table 2-15 for an explanation of the column headings of the |
|
|
|
Specifies the name of the database. If you do not specify the |
|
Displays backup sets, proxy copies, and image copies marked in the repository as
To ensure that |
|
|
Specifies the type of object or objects that you are listing. See Also: "recordSpec" |
|
|
|
Displays information about backups: backup sets, backup pieces, and proxy copies. The output displays a unique key for each. The
Unless you specify the
See Also: "LIST Output" for an explanation of the column headings of the |
|
|
Displays information about datafile copies, archived redo logs, and image copies of archived redo logs. By default,
See Also: Table 2-12 and Table 2-14 for an explanation of the column headings of the |
|
Restricts the list of objects operated on to the object type specified in the listObjList clause. If you do not specify an object, then
Note: The See Also: "listObjList" |
|
|
Specifies the type of object or objects that you are listing. See Also: "recordSpec" |
|
|
|
Lists backup sets, then the contents of each backup set (pieces and files), and then proxy copies. This is the default option for |
|
|
Gives detailed description of contents of each backup set (default). |
|
|
Gives a one-line summary for each datafile (when using |
|
|
Lists a summary of backup sets, then the contents of each backup set (pieces and files), and then proxy copies. |
|
|
Lists a datafile, then its backup sets (including recovery action info), and then proxy copies. |
Restricts the range of the listing. Refer to "maintQualifier". |
||
|
Specifies datafile backups or copies whose status in the repository is
|
|
|
Specifies an end time, SCN, or log sequence number. See "untilClause". |
|
Specifies the object or objects that you are listing. Refer to "recordSpec". |
The information that appears in the output is shown in the following tables:
Table 2-2 List of Backup Sets (when in verbose mode)
Column | Indicates |
|
The number of the file that was backed up. |
|
The level of the backup: |
|
The type of backup: |
|
The checkpoint of the datafile at the time it was backed up. All database changes prior to the SCN have been written to the file; changes after the specified SCN have not been written to the file. |
|
The checkpoint of the datafile at the time it was backed up. All database changes prior to the time have been written to the file; changes after the specified time have not been written to the file. |
|
The location where this file would be restored now if it were restored from this backup set and no See Also: "SET" |
Column | Indicates |
|
A unique key identifying this proxy copy.
If you are connected to a catalog, then |
|
The absolute datafile number of the file that was copied. |
|
The proxy copy status: |
|
The date and time that the backup set completed. Note that the format of this field depends on the |
|
The SCN of the proxy copy control file checkpoint. All database changes recorded in the redo records before the specified SCN are reflected in this control file. |
|
The time of the proxy copy control file checkpoint. All database changes recorded in the redo records before the specified time are reflected in this control file. |
|
The location where this file would be restored now if it were restored from this backup set and no See Also: "SET" |
|
The media manager's handle for the proxy copy. |
|
The tag applied to the proxy copy; |
This example lists all backups in default verbose mode:
LIST BACKUP; List of Backup Sets =================== BS Key Device Type Elapse Time Completion Time ------- ----------- ----------- --------------- 236 DISK 00:00:08 21-SEP-00 BP Key: 237 Status: AVAILABLE Tag: Piece Name: /oracle/dbs/09c5unih_1_1 List of Archived Logs in backup set 236 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 141 49173 21-SEP-00 49784 21-SEP-00 1 142 49784 21-SEP-00 50331 21-SEP-00 BS Key Type LV Size Device Type Elapse Time Completion Time ------- ---- -- ---------- ----------- ----------- --------------- 244 Full 61M DISK 00:00:18 21-SEP-00 BP Key: 245 Status: AVAILABLE Tag: Piece Name: /oracle/dbs/0ac5unj5_1_1 Controlfile Included: Ckp SCN: 51554 Ckp time: 21-SEP-00 List of Datafiles in backup set 244 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 51555 21-SEP-00 /oracle/dbs/tbs_01.f 2 Full 51555 21-SEP-00 /oracle/dbs/tbs_02.f List of Proxy Copies ==================== PC Key File Status Completion time Ckp SCN Ckp time ------- ---- ----------- ------------------- ---------- ------------------- 552 1 AVAILABLE 10/07/2000 03:05:21 78022 10/07/2000 03:05:10 Datafile name: /oracle/dbs/tbs_01.f Handle: 0jb8l876_1_0 561 1 AVAILABLE 10/07/2000 03:38:22 78025 10/07/2000 03:38:09 Datafile name: /oracle/dbs/tbs_01.f Handle: 0lb8la51_1_0 Tag: wklybkup
The following example lists a summarized version of all RMAN backups:
LIST BACKUP SUMMARY; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Tag ------- -- -- - ----------- --------------- ------- ------- --- 164 B A DISK 14-SEP-00 1 1 170 B A DISK 14-SEP-00 1 1
This example groups all backups by file:
LIST BACKUP BY FILE; List of Datafile Backups ======================== File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Tag ---- ------- - -- - ---------- ----------------- ------- ------- --- 1 502 B 0 A 37973 09/28/99 19:28:36 1 2 * 552 P F X 78022 10/07/99 03:05:10 1 1 561 P 0 A 78025 10/07/99 03:38:09 1 1 DF_1_2 2 502 B 0 A 37973 09/28/99 19:28:36 1 2 * 562 P 0 U 78027 10/07/99 03:38:22 1 1 DF_1_2 List of Archived Log Backups ============================ Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Tag ---- ------- ---------- --------- ------- - ------- ------- --- 1 141 49463 14-SEP-00 213 A 1 1 List of Controlfile Backups =========================== CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Tag ---------- --------- ------- - ------- ------- --- 51593 14-SEP-00 222 A 1 1
The following example lists archived logs and copies of logs:
LIST COPY OF DATABASE ARCHIVELOG ALL; List of Archived Log Copies Key Thrd Seq S Low Time Name ------- ---- ------- - --------- ---- 153 1 141 A 14-SEP-00 /oracle/work/arc_dest/arcr_1_141.arc 154 1 142 A 14-SEP-00 /oracle/work/arc_dest/arcr_1_142.arc
The following example lists backups of datafile 11 in summary mode:
LIST BACKUP OF DATAFILE 11 SUMMARY; List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Tag ------- -- -- - ----------- --------------- ------- ------- --- 180 B 0 A DISK 14-SEP-00 1 2
This example lists all database incarnations:
LIST INCARNATION; List of Database Incarnations DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 2 RDBMS 674879952 YES 1 14-SEP-00
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|