基于 SCN 增量恢复

备库停掉 MRP 进程

SQL> alter database recover managed standby database cancel;

1. 查询最小 SCN

#### 生产库 ####

SQL> select min(f.fhscn) from x$kcvfh f,v$datafile d where f.hxfil=d.file# and d.enabled!='READ ONLY';

MIN(F.FHSCN)

----------------

14847289822558

#### 备份库 ####

SQL> select min(f.fhscn) from x$kcvfh f,v$datafile d where f.hxfil=d.file# and d.enabled!='READ ONLY';

MIN(F.FHSCN)

----------------

14846580672421

===> 14846580672421 <===

2. 在主库上执行基于 SCN 的 rman 备份

run{

allocate channel c1 type disk;

allocate channel c2 type disk;

backup incremental from scn 14846580672421 database format '/oradata/st_%U' tag '14846580672421';

###### 备份集压缩

#######backup as compressed backupset incremental from scn 14846580672421 database format '/rman/bak_%U%t';

release channel c1;

release channel c2;

}

控制文件备份

SQL>alter database create standby controlfile as '/tmp/rman/standby.ctl';

或使用 backup current controlfile 备份

RMAN> backup current controlfile for standby format '/backup/control%s.bak';

3. 把备份片拷到备库

$ scp st* 10.87.250.91:/Tbackup/backup/

4. 控制文件恢复

若之前用 rman 备份

备库：

sql > shutdown immediate

sql > startup nomount 

rman > restore standby controlfile from '/Tbackup/backup/control65.bak';

rman > alter database mount;

5. 在备库主机上，注册备份片

RMAN> catalog backuppiece '/Tbackup/hdyy/st_crrl2dc5_1_1';

或者

RMAN> catalog start with '/Tbackup/backup'; 

RMAN> recover database noredo;

重建备库controlfile

查看数据文件头，验证恢复情况

select file#, to_char(checkpoint_change#) from v$datafile_header;

6. 备库重新启动应用日志

SQL>alter database recover managed standby database disconnect from session;

或者 SQL > alter database recover managed standby database using current logfile  disconnect from session;

主库操作往备库传输归档日志

SQL>alter system set log_archive_dest_state_2 ='enable';

主备库查看归档日志情况

SQL>archive log list;

主库切下归档看是否用到备库

Alter system switch lofile;