ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Recovery catalog for RMAN backup

Recovery catalog for RMAN backup

原创 Linux操作系统 作者:guo_li_yuan 时间:2008-04-24 14:09:49 0 删除 编辑
Purpose
  Scope and Application
  Recovery catalog for RMAN backup
     Why Recovery catalog ?
     How to create recovery catalog ?
     1. Creating the Recovery Catalog Owner
     2. Creating the Recovery Catalog
     3. Registering the target database
 
     How to Upgrade recovery catalog Schema ?
     How to upgrade recovery catalog database ?
     How to remove catalog ?
     How to unregister the target database from the recovery catalog ?
     
     How to backup of the Recovery Catalog ?
     How to restore and Recover recovery catalog from Backup ?
     Compatibility of the Recovery Catalog
     How to identify recovery catalog schema version ?
  References



恢复目录 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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/377444/viewspace-250506/,如需转载,请注明出处,否则将追究法律责任。

下一篇: logminer例
请登录后发表评论 登录
全部评论

注册时间:2008-01-04

  • 博文量
    11
  • 访问量
    18399