正德厚生,臻于至善

DataGuard ORA-07286: sksagdi: cannot obtain device information.

主库查询
show parameter dest;
set lines 200 pages 50000
select dest_id,error from v$archive_dest;
select dest_id,status,error from v$archive_dest_status where dest_id=2;
select dest_id,status,error from v$archive_dest where dest_id=2;

重启备库
shutdown immediate;
startup nomount;
alter database mount;
alter database open read only;
alter pluggable database all open read only;
alter database recover managed standby database cancel;
alter database recover managed standby database using current logfile disconnect from session;

重启通道
alter system set log_archive_dest_state_2=defer scope=memory sid='*';
alter system set log_archive_dest_state_2=enable scope=memory sid='*';
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
select error,status from gv$archive_dest where dest_id=2;
赞(0) 打赏
未经允许不得转载:徐万新之路 » DataGuard ORA-07286: sksagdi: cannot obtain device information.

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫

微信扫一扫

登录

找回密码

注册