Friday, October 07, 2011

Register database with recovery catalog

If you are connected to RMAN catalog but didn’t register the database with catalog server then you are allowed to connect to catalog

-bash-3.2$ rman target RMANUSER/****@SOURCEDB catalog backup_user/*****@catalog_rman.world

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 7 09:13:06 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: SOURCEDB (DBID=3625558458)
connected to recovery catalog database

But,  Backup or any other operations will fail!

RMAN> report schema;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 10/07/2011 09:13:14
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog


Register your database using following command.

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> report schema;

RMAN> report schema;

Report of database schema for database with db_unique_name SOURCEDB

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    890      SYSTEM               YES     /oradata/DB/system01.dbf
2    750      SYSAUX               NO      /oradata/DB/sysaux01.dbf
3    1835     UNDOTBS1             YES     /oradata/DB/undotbs01.dbf
4    645      USERS                NO      /oradata/DB/users01.dbf
......................................................................

No comments: