Thursday, April 10, 2014

Registering database with Recovery catalog

In order for oracle RMAN catalog to hold the backup information we need to register the database with recovery catalog and that can be done using the steps below:

  1. Create tns entry under tnsnames.ora on database server for which need registration.
  2. connect to catalog using catalog owner from database server.
  3. register database;
Step 1:
Added the entry below on the database server

RCAT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rcat1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RCAT1.localdomain)
    )
  )
Step 2:
[oracle@dbs1 ~]$ rman target /
Recovery Manager: Release 11.2.0 - Production on
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: ORCL (DBID=1372201017)
RMAN> connect catalog catowner@rcat
recovery catalog database Password:
connected to recovery catalog database
RMAN> 
Step 3:
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN>




No comments: