RelationalDBDesign RelationalDBDesign


Backup Recovery   «Prev 

Writing Oracle LIST and REPORT Commands

  1. You have connected to the RMAN command line by using RMAN as the User Name, RMAN as the Password, and BACKUP as the Host String. You have also connected to the target database. Now, issue a LIST command to display all the backups performed on the database. Then click Enter to continue.
  2. RMAN now displays all the backups performed on the database. But what if there are obsolete backups? Press Enter to learn how to access that report.
  3. Issue a REPORT command to display all the obsolete backups performed on the database, which can be deleted. Approve the entries.
  4. RMAN now displays all the obsolete backups performed on the database, which can be deleted. This is the end of the simulation. Click Exit.

LIST Purpose

Use the LIST command to display backups and information about other objects recorded in the RMAN repository.

Additional Topics

  1. Prerequisites
  2. Usage Notes
  3. Syntax
  4. Semantics
  5. LIST Command Output
  6. Examples

Prerequisites

Execute LIST only at the RMAN prompt. Either of the following conditions must be met:
  1. RMAN must be connected to a target database. If RMAN is not connected to a recovery catalog, and if you are not executing the LIST FAILURE command, then the target database must be mounted or open. If RMAN is connected to a recovery catalog, then the target database instance must be started.
  2. RMAN must be connected to a recovery catalog and SET DBID must have been run.

Usage Notes

Except for LIST FAILURE, the LIST command displays the backups and copies against which you can run CROSSCHECK and DELETE commands. The LIST FAILURE command displays failures against which you can run the ADVISE FAILURE and REPAIR FAILURE commands.
"RMAN Backups in a Data Guard Environment" explains how RMAN handles backups in a Data Guard environment. In general, RMAN considers tape backups created on one database in the environment as accessible to all databases in the environment, whereas disk backups are accessible only to the database that created them. In a Data Guard environment, LIST displays those files that are accessible to the connected target database. RMAN prints the LIST output to either standard output or the message log, but not to both at the same time.