RMAN IMPLEMENTATION --create catalog repository

Target Database Name: Test
Catalog Database Name: Catdb

Problems:

Creating RMAN repository in catalog database (catdb) & register the target database (test) in repository.
Login into catdb.

Steps 1: Create Repository Tablespace and Schema

SQL> CREATE TABLESPACE RMAN
DATAFILE 'C:\ORACLE\ORADATA\CATALOGDB\RMAN01.DBF' SIZE 200m REUSE
AUTOEXTEND ON EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.

Steps 2: Create Repository Schema
SQL> CREATE USER RMAN IDENTIFIED BY RMAN
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE RMAN
QUOTA UNLIMITED ON RMAN;
User created.


Steps 3: Privileges Assigned to RMAN user

SQL> GRANT RECOVERY_CATALOG_OWNER TO RMAN;
Grant succeeded.

SQL> GRANT CONNECT, RESOURCE TO RMAN;
Grant succeeded.


Steps 4: Creating the Recovery Catalog

C:\Documents and Settings\raja.baskar>RMAN CATALOG RMAN@CATDB
Recovery Manager: Release 9.2.0.7.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Recovery catalog database Password:
Connected to recovery catalog database
Recovery catalog is not installed
RMAN> CREATE CATALOG;
Recovery catalog created
RMAN> Exit
Recovery Manager complete


Steps 5: Let the Catalog Database keep information in its control file for 40 days. (Optional)

SQL> ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=40;
System altered.

SQL> SHOW PARAMETER CONTROL_FILE_RECORD_KEEP_TIME
NAME TYPE VALUE
Control_file_record_keep_time integer 40

Steps 6: Setup Target Database (Register Database)

·EACH DATABASE TO BE BACKED UP BY RMAN MUST BE REGISTERED.

C:\Documents and Settings\manoj.kumar>RMAN CATALOG=RMAN/xxxx@CATDB TARGET=SYS/xxxx@test
Recovery Manager: Release 9.2.0.7.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
Connected to target database: TEST (DBID=1933922270)
Connected to recovery catalog database

RMAN> REGISTER DATABASE;
Database registered in recovery catalog
Starting full resync of recovery catalog
Full resync complete

RMAN> LIST INCARNATION; -à shows what are the database registers in catalog database..