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

本文介绍Oracle数据库的数据恢复技术,包括闪回功能、数据文件介质恢复、块修复、表空间点在时间恢复等。同时,阐述了如何手动同步RECOVERYCATALOG及通过导入方式生成RECOVERYCATALOG的过程。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 

 

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;

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值