RMAN Catalog  (Oracle 10 g and above)

Add information about a datafile copy, archived redo log, or control file copy to the repository.

Syntax:

   CATALOG {ARCHIVELOG | BACKUPPIECE | CONTROLFILECOPY | DATAFILECOPY} 'FileName'… [LEVEL = Integer];

   CATALOG RECOVERYAREA [NOPROMPT]

   CATALOG DB_RECOVERY_FILE_DEST [NOPROMPT]

   CATALOG START WITH 'string pattern' [NOPROMPT]

Key

   ARCHIVELOG 'filename'  The filename of an archived log to be added to
                          or updated in the RMAN repository.

   BACKUPPIECE            The name of a backup piece to be added to the RMAN repository.
                          The backup piece must be on disk.
                          RMAN verifies the backup piece header before cataloging it. RMAN can catalog a backup piece from a prior incarnation.

Typically, you would catalog a backup piece in the following situations:

You have copied a backup piece with an operating system utility. In this case, the original backup piece is cataloged but the piece copy is not.
You want to move a backup piece from one disk to another under a different absolute filename.
You run in NOCATALOG mode and must re-create the control file, thereby losing all RMAN metadata.

If you specify a list of backup pieces, RMAN catalogs all pieces in the given list even if one of them fails. Cataloging a backup piece creates a new row in V$BACKUP_PIECE. A backup set is only usable when all backup pieces are cataloged. Otherwise it would be in partially available state.

Note: When cataloging backup pieces from releases prior to Oracle9i, performance improves when you catalog higher copy numbers first. For example, if you need to catalog copies 1, 2, and 3 of a backup piece, then specify copy 3 as the first item in the CATALOG list.

   CONTROLFILECOPY        The filename of a control file copy to be added to
                          or updated in the RMAN repository.

The control file copy can be:
A copy of a normal control file (that is, not a standby control file) created with the RMAN command BACKUP AS COPY CURRENT CONTROLFILE command or the SQL statement ALTER DATABASE BACKUP CONTROLFILE
A standby control file copy created with the RMAN command BACKUP AS COPY STANDBY CONTROLFILE or the SQL statement ALTER DATABASE CREATE STANDBY CONTROLFILE

   DATAFILECOPY           The filename of a datafile copy to be added to or
                          updated in the RMAN repository.
   LEVEL = 0              For datafile copies only, indicates that the copy should be
                          recorded as a level 0 incremental backup.
                          Perform incremental backups by using this datafile copy as the base level 0 backup.

   (RECOVERY AREA |
   DB_RECOVERY_FILE_DEST)
   [ NOPROMPT ]           Catalog all valid backup sets, datafile copies, and
                          archived redo logs in the flash recovery area.
                          RMAN must be connected to the target database and the target database
                          must be mounted or open.
                          Specify NOPROMPT if you do not want to be prompted after every match.
                          The keywords RECOVERY AREA and DB_RECOVERY_FILE_DEST are exact synonyms.

   START WITH 'string_pattern' [ NOPROMPT ]

Catalogs all valid backups in the specified location, which can be an Automatic Storage Management disk group, Oracle Managed Files directory, or part of a filename. RMAN will report any files in the disk location that cannot be cataloged. RMAN must be connected to the target database and the target database must be mounted. Specify NOPROMPT if you do not want to be prompted after every match.

If the string pattern specifies a filename, then it matches the left part of the filename pattern. For example, /tmp/arc matches everything in directory /tmp/arc_dest and /tmp/archive/january as well as a file /tmp/arc.cpy.

Note: You cannot use wildcard characters.

Examples

Catalog all files and the contents of directories which begin with the pattern "e:\backup\Live\"
RMAN> CATALOG start with 'e:\backup\Live\';

Catalog all files in the current recovery area.
RMAN> CATALOG RECOVERY AREA NOPROMPT;

“I once had a rose named after me and I was very flattered. But I was not pleased to read the description in the catalogue: no good in a bed, but fine up against a wall” - Eleanor Roosevelt

Related Commands:

BACKUP - Back up database files, archive logs, backups, or copies.
CROSSCHECK - Check whether backup items still exist.
RECOVER - Perform media recovery from RMAN backups and copies.
RESTORE - Restore RMAN backups and copies.
RUN
- Some RMAN commands are only valid inside a RUN block.
SET
- Settings for the current RMAN session.
SHOW
- Display the current configuration


© Copyright SS64.com 1999-2013
Some rights reserved