RMAN Recovery catalog

SQL> create tablespace cattbs datafile '/data01/app/oracle/datafiles/racdb/catalog.dbf' size 500M ;

Tablespace created.

SQL> create user rman identified by rman default tablespace cattbs quota unlimited on cattbs;

User created.

SQL> grant recovery_catalog_owner to rman;

Grant succeeded.

RMAN> connect catalog rman/rman

connected to recovery catalog database

[oracle@DB11G dbs]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 20 09:38:17 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RACDB (DBID=876245389)

RMAN> connect catalog rman/rman

connected to recovery catalog database

RMAN> list incarnation ;


RMAN> list incarnation ;


RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       14      RACDB    876245389        PARENT  1          17-SEP-11
1       2       RACDB    876245389        CURRENT 995548     02-MAY-15


Cataloging Older Files

RMAN> catalog datafilecopy '/u01/app/oracle/users01.dbf';
cataloged datafile copy
datafile copy filename=/u01/app/oracle/users01.dbf recid=2 stamp=604202000
RMAN>

RMAN> catalog backuppiece '/disk1/backups/backup_820.bkp';
RMAN> catalog archivelog '/disk1/arch_logs/archive1_731.dbf',
'/disk1/arch_logs/archive1_732.dbf';

The files you want to catalog can exist only on disk and not on tape, and they must belong
to one of the following types:
• Datafile copy
• Control file copy
• Archived redo log
• Backup piece

Cataloging a Datafile Copy As an Incremental Backup
====================================================

RMAN> catalog datafilecopy '?/oradata/users01.bak' level 0;

Once you catalog a datafile copy as a level 0 backup, you can then perform an incremental backup by using that copy as your base.

RMAN> catalog start with '/disk1/arch_logs/';
RMAN> catalog start with '/disk1/arch_logs/' noprompt;

Updating the Recovery Catalog

RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
RMAN>