Sunday, May 19, 2013

Rman catalog creation in 11gr2 database

RMAN CATALOG CREATION IN 11GR2 DATABASE

The catalog database acts as the centralized inventory of  database's and stores the backup details of all the database which is registered with it .. there are two methods the Rman can be operated the control file and the Recovery catalog
For creating the recovery catalog database we need to create the new database or we can use the existing database .. But the safe parctice is to create the new database which is dedicated for the CATALOG ..
The benefit of using the recover catalog is all the backup information of the database is stored in recover catalog database tables and we can query the status of the backup and the details of the backup from the recovery catalog database

Step 1
Create the Separate database which is going to host the Rman catalog database

Step 2
Create the Separate  table space which will hold all the catalog schema tables in it 
SQL> CREATE TABLESPACE <tables pace_name>
  2  DATAFILE '<datafile_name>' size 10240M
  3  Autoextend on;
Tablespace created.


Step3 

Create the new user which will the Owner of the Rman catalog
Create user <username> identified by <password>
Default tablespace <tablespace_name>
Temporary tablespace <temporary tablespace name>
Quota <percentage of allocated quota> on <table space>


 Step 4
Grant the recovery catalog owner role to the rcat user


Step5
Fom the O/S Prompt connect to the rman


Step 6 
Connect to the recover catalog by using the new user name which we have created 

Step 7
Connect to the recover catalog and register the database










No comments:

Post a Comment