一个standby库出问题,丢了1个归档
检查主库的日志,发现丢失的归档的SEQ的redo还未被覆盖,马上将其拷贝出来传递到备库上
尝试catalog,虽然没有报错,但是实际没有注册成功
RMAN> catalog archivelog '/u01/app/oracle/oradata/ORCL/redo03_281.arc';
cataloged archived log
archived log file name=/u01/app/oracle/oradata/ORCL/redo03_281.arc RECID=297 STAMP=840464160
尝试使用sqlplus的recover命令来恢复,提示是standby controlfile,无法进行
SQL> recover database ;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01666: control file is for a standby database
没找到sqlplus下recover命令的reference,最后瞎尝试,总算试了出来
SQL> recover standby database;