0 0 0

+9

Creating Recovery catalog (RMAN in Oracle 10g)

Follow following Steps:

STEP1:

Create a new database(catdb) for RMAN Recovery catalog database
And also Create a new tablespace in the new database (CATDB).

$ sqlplus /nolog
CONNECT SYS/passwd@catdb AS SYSDBA;


CREATE TABLESPACE rman
DATAFILE ‘/u02/app/oradata/rman/rman01.dbf’ size 100m;

STEP2:
Create the Recovery Catalog Owner in the new database (CATDB):

CREATE USER rman IDENTIFIED BY rman
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;

STEP3:
Grant the necessary privileges to the schema owner:

SQL> GRANT connect, resource, recovery_catalog_owner TO rman;

Here the role “RECOVERY_CATALOG_OWNER” provides the user with all privileges required to maintain and query the recovery catalog.

STEP4:
Creating the Recovery Catalog:

Connect to the database which will contain the catalog as the catalog owner. For example:

$ rman catalog rman/passwd@catdb

Recovery Manager: Release 10.2.0.3.0 – Production on Sun Apr 1 14:22:13 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database

RMAN>

Run the CREATE CATALOG command to create the catalog

RMAN> CREATE CATALOG;
recovery catalog created

STEP5:
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@catdb

Recovery Manager: Release 10.2.0.3.0 – Production on Sun Apr 1 14:25:30 2010
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

STEP6:
Make sure that the registration was successful by running REPORT SCHEMA:

RMAN>REPORT SCHEMA;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 500 SYSTEM YES /u02/app/oradata/prod/system01.dbf
2 200 UNDOTBS1 YES /u02/app/oradata/prod/undotbs01.dbf
3 325 SYSAUX NO /u02/app/oradata/prod/sysaux01.dbf
4 100 EXAMPLE NO /u02/app/oradata/prod/example01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 200 TEMP 200 /u02/app/oradata/prod/temp01.dbf

0 0 0