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