Oracle: RMAN IMPLEMENTATION -- Create Catalog Repository

RMAN IMPLEMENTATION

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.

Step 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.

Step 2

Create Repository Schema

SQL> CREATE USER RMAN IDENTIFIED BY RMAN
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE RMAN
QUOTA UNLIMITED ON RMAN;

User created.

Step 3

Privileges Assigned to RMAN user

SQL> GRANT RECOVERY_CATALOG_OWNER TO RMAN;

Grant succeeded.

SQL> GRANT CONNECT, RESOURCE TO RMAN;

Grant succeeded.

Step 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

Step 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

Step 6

Setup Target Database (Register Database)

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

C:\Documents and Settings\raja.baskar>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?

I Hope this article helped you to understand RMAN implementation.Suggestions are welcome.

Oracle , DB , DBA , database , database administrator , administrator , RMAN , RMAN implementation , cat db , catdb , catalog db , catalog database , register , repository tablespace , tablespace , schema , table , datafile , segment , system , SQL , catalog , create , recovery , repository , target , release 92070 , manager: release , production copyright c 1995 , create repository , corporation , settings\\rajabaskarrman , rman; grant , rights , grant , resync , recovery catalog , sql , steps , rman , target database , recovery manager , recovery catalog database , created , name , user , connected , manager , test , succeeded , production , release , copyright , settings\rajabaskarrman ,