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;