Oracle: RMAN IMPLEMENTATION -- Create Catalog Repository

Quick Links

Oracle DBA - RMAN IMPLEMENTATION --create catalog repositoryRMAN 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.

Help Us Grow

If you like this post, please share it with your friends.

You are free to copy and redistribute this article in any medium or format, as long as you keep the links in the articles or provide a link back to this page.

Subscribe to our mailing list