检查主库传输通道状态
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;