Oracle8i Backup and Recovery Guide
Release 8.1.5

A67773-01

Library

Product

Contents

Index

Prev Prev Next


catalog

Syntax


Purpose

Use the catalog command to:

Requirements

You cannot use catalog to perform the following operations:

Keywords and Parameters

controlfilecopy 'filename'  

specifies the filename of a control file copy to be added to or updated in the recovery catalog and control file.  

datafilecopy 'filename'  

specifies the filename of a datafile copy to be added to or updated in the recovery catalog and control file.  

archivelog 'filename'  

specifies the filename of an archivelog copy to be added to or updated in the recovery catalog and control file.  

tag tag_name  

specifies the tag of the input file, e.g., Sunday_PM_Backup.  

level integer  

indicates that the file copy should be recorded as an incremental backup at the specified level, typically level 0. You can perform incremental backups using a datafile copy as the base level 0 backup.  

Examples

Cataloging an Archived Redo Log

This statement catalogs the archived redo logs log1, log2, and log3:

catalog archivelog 'log1', 'log2', 'log3';
Cataloging a File Copy as an Incremental Backup

The following example catalogs datafile copy tbs_2.c as an incremental level 0 backup:

catalog datafile '/oracle/copy/tbs_2.c' level 0;
Cataloging an O/S Copy

The following makes an O/S copy of a datafile using the RMAN host command and then catalogs the copy (sample output included):

host 'cp $ORACLE_HOME/dbs/sales.f $ORACLE_HOME/dbs/sales.bak';
catalog datafilecopy '$ORACLE_HOME/dbs/sales.bak';

RMAN-03022: compiling command: catalog
RMAN-03023: executing command: catalog
RMAN-08050: cataloged datafile copy
RMAN-08513: datafile copy filename=/oracle/dbs/sales.bak recid=121 stamp=342972501
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete

Related Topics

"list"

"report"




Prev

Top

Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index