管理recovery catalog

1在recovery catalog 数据库中创建用户

CREATE USER rman IDENTIFIED BY cat
  TEMPORARY TABLESPACE temp
  DEFAULT TABLESPACE tools
  QUOTA UNLIMITED ON tools;

2分发角色

SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;

3创建recovery catalog

a RMAN> CONNECT CATALOG rman/cat@catdb

b运行create catalog;

4检查是否创建了

SQL> SELECT TABLE_NAME FROM USER_TABLES;

在recovery catalog中注册数据库

1rman target_database / catalog rman/cat@catdb

2RMAN>startup mount

3RMAN>register database;

使用report schema确认成功的注册了

在recover catalog中注销数据库

1 rman target /catalog rman/cat@catdb

2list backup summary检查下

3ungregister database;

在recovery catalog中重置数据库incarnation

1 list incarnation of database orcl

2RESET DATABASE TO INCARNATION 2;

3如果前面incarnation的控制文件可用并且mount了，跳到步骤6上去，否则关闭数据库，并mout

shutdown immediate

start nomount

4恢复控制文件

RUN
{
  SET UNTIL 'SYSDATE-45';
  RESTORE CONTROLFILE; # only if current control file is not available
}

5alter database mount

6

Run RESTORE and RECOVER commands to restore and recover the database files from the prior incarnation, then open the database with the RESETLOGS option. For example, enter:

RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;

同步recovery catalog

当同步的时候，rman做下面的操作

1创建一个控制文件快照

2对比recovery catalog与控制文件

3用丢失或改变的额信息更新recovery catalo

RMAN>RESYNC CATALOG;