错误信息:
ORA-07286: sksagdi: cannot obtain device information.
主库日志状态:
show parameter dest;
select error,status from gv$archive_dest where dest_id=11;
show parameter dest;
select error,status from gv$archive_dest where dest_id=11;
解决方法,重新备数据库,重启日志进程:
alter database recover managed standby database cancel;
shutdown immediate;
startup;
alter database recover managed standby database using current logfile disconnect from session;
alter system set log_archive_dest_state_11=defer;
alter system set log_archive_dest_state_11=enable;
alter system switch logfile;
select error,status from gv$archive_dest where dest_id=11;