如果考到一半，缺了部分数据文件

方法：

重新考失败的数据文件，如下图，缺少了1、2、5数据文件

备库执行。

如果是缺数据文件

连接

rman target sys/oracle@blj auxiliary sys/oracle@bljdg

拷 1，2，5号数据文件，后面的format是指定备库恢复出来的位置和名字。

backup as copy reuse datafile 1 auxiliary format '/oradata/data/system01.dbf';

backup as copy reuse datafile 5 auxiliary format '/oradata/data/bb01.dbf';

backup as copy reuse datafile 2 auxiliary format '/oradata/data/sysaux01.dbf';

连接

rman target sys/oracle@blj auxiliary sys/oracle@bljdg

考一个控制文件过来

backup as copy current controlfile for standby auxiliary format '/oracle/con/control01.ctl';

克隆一个控制文件

restore clone controlfile to '/oracle/con/control02.ctl' from '/oracle/con/control01.ctl';

连接

rman target sys/oracle@blj auxiliary sys/oracle@bljdg

拷归档/oracle/arch/1_13_1103888056.dbf到目标端/oracle/oradata/data/hahaha.dbf

backup as copy reuse archivelog like '/oracle/arch/1_13_1103888056.dbf' auxiliary format '/oracle/oradata/data/hahaha.dbf';

主库刷一下defer

alter system set log_archive_dest_state_2=defer;

alter system set log_archive_dest_state_2=enable;

select dest_name,status,error from v$archive_dest where dest_id=2;

主库看dest_的error

DEST_NAME STATUS ERROR ORA-16B58: ERROR standby database instance is not mounted

重启备库即可。