OCP 1Z0 053 264

264.Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the 
RMAN repository can be listed? (Choose two.) 

A. stored scripts in the recovery catalog 
B. backups that can be deleted from disk 
C. backup sets and image copies are obsolete 
D. backups that do not have the AVAILABLE status in the RMAN repository 

Answer: AD 

BC需要看OBSOLETE 状态的数据，而这要用report

RMAN> report OBSOLETE ;

RMAN 保留策略将应用于该命令
将 RMAN 保留策略设置为冗余 1
未找到已废弃的备份

RMAN>

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmreprt.htm#BRADV89585

About the LIST Command

The primary purpose of the LIST command is to list backup and copies. For example, you can list:

• Backups and proxy copies of a database, tablespace, data file, archived redo log, or control file

• Backups that have expired

• Backups restricted by time, path name, device type, tag, or recoverability

• Archived redo log files and disk copies

Besides backups and copies, RMAN can list other types of data. Table 11-1 summarizes several useful objects that you can list.

Table 11-1 LIST Objects

Contents of List	Command	Description
Backup sets and proxy copies	LIST BACKUP	You can list all backup sets, copies, and proxy copies of a database, tablespace, data file, archived redo log, control file, or server parameter file.
Image copies	LIST COPY	You can list data file copies and archived redo log files. By default, LIST COPY displays copies of all database files and archived redo logs. Both usable and unusable image copies are included in the output, even those that cannot be restored or are expired or unavailable.
Archived redo log files	LIST ARCHIVELOG	You can list archive redo log files. You can list all archive log redo log files or specify individual archive log files through SCN, time, or sequence number ranges. If you specify a range you can further restrict the list returned by specifying an incarnation number.
Database incarnations	LIST INCARNATION	You can list all incarnations of a database. A new database incarnation is created when you open with the RESETLOGS option.
Databases in a Data Guard environment	LIST DB_UNIQUE_NAME	A database in a Data Guard environment is distinguished by its DB_UNIQUE_NAMEinitialization parameter setting. You can list all databases that have the same DBID.
Backups and copies for a primary or standby database in a Data Guard environment	LIST ... FOR DB_UNIQUE_NAME	You can list all backups and copies for a specified database in a Data Guard environment or for all databases in the environment. RMAN restricts the output to files or objects associated exclusively with the database with the specified DB_UNIQUE_NAME. For example, you can use LIST with FOR DB_UNIQUE_NAME to display the list of archived redo log files associated with a particular standby or primary database. Objects that are not owned by any database (SITE_KEYcolumn in the recovery catalog view is null) are not listed.
Restore points	LIST RESTORE POINT	You can list restore points known to the RMAN repository.
Names of stored scripts	LIST SCRIPT NAMES	You can list the names of recovery catalog scripts created with the CREATE SCRIPT orREPLACE SCRIPT command. A recovery catalog is required.
Failures for use with Data Recovery Advisor	LIST FAILURE	A failure is a persistent data corruption mapped to a repair option. Chapter 15, "Diagnosing and Repairing Failures with Data Recovery Advisor" explains how to useLIST FAILURE with the ADVISE and REPAIR commands.