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:
- Create tns entry under tnsnames.ora on database server for which need registration.
- connect to catalog using catalog owner from database server.
- 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:
Post a Comment