恢复目录 catalog

It is always recommended to have the recovery catalog. If the target database controlfiles are lost recovery can become difficult if not impossible.Having recovery catalog makes the DBA life easier at the time of critical scenario. Even for larger system the use of a recovery catalog can increase the backup performance.        Recovery Catalog Schema can be created in the Target database or in any test or development database. It is  not at all recommended  to create the recovery catalog in the target database itself. Make sure to have a separate database for the recovery catalog always .Also its recommended to create the recovery catalog database in a different machine. If creating the Recovery catalog database in different machine is not possible then ensure that the recovery catalog and target databases do not reside on the same disk. If both your recovery catalog and your target database suffer hard disk failure, your recovery process is much more difficult. If possible, take other measures as well to eliminate common points of failure between your recovery catalog database and the databases you are backing up.

How to create recovery catalog ?

Creating recovery catalog is a 3 step process .The recovery catalog is stored in the default tablespace of the recovery catalog schema. SYS cannot be the owner of the recovery catalog.

1. Creating the Recovery Catalog Owner
2. Creating the Recovery Catalog
3. Registering the target database


C:\Documents and Settings\DB>rman  catalog  rman/rman@orcl
恢复管理器: Release 10.2.0.1.0 - Production on 星期四 4月 24 14:43:36 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: 内部恢复管理器程序包初始化失败
RMAN-04004: 来自恢复目录数据库的警告: ORA-04098: 触发器 'SYS.LOGON_HISTORY' 无效
且未通过重新验证
将触发器'SYS.LOGON_HISTORY' 删除后
C:\Documents and Settings\DB>rman  catalog  rman/rman@orcl
恢复管理器: Release 10.2.0.1.0 - Production on 星期四 4月 24 14:50:12 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
连接到恢复目录数据库

主题:  Recovery catalog for RMAN backup
  文档 ID:  注释:452529.1 类型:  BULLETIN
  上次修订日期:  12-MAR-2008 状态:  PUBLISHED