Creating a Recovery Catalog


$ sqlplus /nolog
CONNECT SYS/passwd@OCM AS SYSDBA;
CREATE TABLESPACE rman
DATAFILE '/u02/app/oradata/rman/rman01.dbf' size 100m;
Create the Recovery Catalog Owner in the new database (OCM)
CREATE USER rman IDENTIFIED BY rman
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;

SQL> GRANT connect, resource, recovery_catalog_owner TO rman;

$ rman catalog rman/passwd@OCM
Recovery Manager: Release 10.2.0.3.0 - Production on Sun Apr 1 14:22:13 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN>

RMAN> CREATE CATALOG;
recovery catalog created
Registering a Database in the Recovery Catalog
Connect to the target database and recovery catalog database.
$ ORACLE_SID=prod; export ORACLE_SID
$ rman target / catalog rman/passwd@OCM
Recovery Manager: Release 10.2.0.3.0 - Production on Sun Apr 1 14:25:30 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PROD (DBID=3677528376)
connected to recovery catalog database
RMAN> REGISTER DATABASE;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: