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