2012-11-20 11gR2 "Backup and Recovery User's Guide" page 257 - 300

 

 

RMAN Data Repair Techniques -- 数据恢复技术
 -- Data Recovery Advisor -- 数据恢复的建议器
 -- logical flashback features 闪回查询等
 -- Oracle Flashback Database 闪回数据库
 -- datafile media recovery -- 数据文件介质恢复
 -- block media recovery -- 块修复
 -- tablespace point-in-time recovery (TSPITR)


Manually Resynchronizing the Recovery Catalog -- 手工同步RECOVERY CATALOG
1. Start RMAN and connect to a target database and recovery catalog.

2. Mount or open the target database if it is not already mounted or open:
STARTUP MOUNT;

3. Resynchronize the recovery catalog.
Run the RESYNC CATALOG command at the RMAN prompt as follows:
RESYNC CATALOG;

The following example resynchronizes the control file of standby1:
RESYNC CATALOG FROM DB_UNIQUE_NAME standby1;
The following variation resynchronizes the control files for all databases in the
Data Guard environment:
RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
 -- DATA GUARD环境同步过程


Importing and Moving a Recovery Catalog -- 用导入的方式生成RECOVERY CATALOG
To import a recovery catalog:
1. Start RMAN and connect as CATALOG to the destination recovery catalog schema.
For example:
% rman
RMAN> CONNECT CATALOG
111cat@destdb;

2. Import the source recovery catalog schema, specifying the connection string for
the source catalog.
For example, enter the following command to import the catalog owned by
102cat on database srcdb:
IMPORT CATALOG
102cat@srcdb; -- 将源端导入(连的是目的端)

A variation is to import metadata for a subset of the target databases registered in
the source catalog. You can specify the databases by DBID or database name, as
shown in the following examples:
IMPORT CATALOG
102cat@srcdb DBID=1423241, 1423242;
IMPORT CATALOG
102cat@srcdb DB_NAME=prod3, prod4;

3. Optionally, connect to a target database to check that the metadata was
successfully imported. For example, the following commands connect to database
prod1 as TARGET and list all backups for this database:
LIST BACKUP;

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值