Recovery Manager, or RMAN, can create useful lists and reports of backups and image copies.
RMAN obtains the information from your metadata repository, either the control file or the recovery catalog. Use the report and list commands to determine what you have, or need to back up or copy.
The information, which is available whether or not you use a recovery catalog, is extremely helpful in developing an effective backup strategy.
The list command shows the contents of RMAN's metadata repository, all RMAN backups (both backup sets and proxy copies) and image copies.
The report command performs a more detailed analysis. For example, it can generate a report on the datafiles that need a backup when the backup pieces are obsolete.
The report command can list backup sets and datafile copies that can be deleted either because they are redundant or because they are unrecoverable.
RMAN writes the output from these commands to the screen or to a log file.
The list command queries the recovery catalog or control file and produces a record of its contents. Use it to list:
- Backups of a specified list of datafiles
- Image copies of a specified list of datafiles
- Backups of any datafile that is a member of a specified list of tablespaces
- Image copies of any datafile that is a member of a specified list of tablespaces
- Backups of any archived redo logs with a specified name and/or within a specified range
- Image copies of any archived redo log with a specified name and/or within a specified range
- Incarnations of a specified database
Within Oracle, the output of the
command is significantly improved. It now prints the list of backups belonging to a backup set.
This is contained within a separate section of the report, from the list of data files or archived logs included within the backup set.
A new command,
REPORT NEED BACKUP REDUNDANCY
, has been implemented. When fewer than a user-specified number of backups of a data file exist, this report alerts the user that a new backup is required.
In the following simulation, we will connect to RMAN and run one
command, and review the results displayed by it.
Writing list Report Commands
The following SlideShow lists some of the new commands for the
feature within RMAN.