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:ORACLEORADATACATALOGDBRMAN01.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 Settingsraja.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 Settingsraja.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.