主库查询
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;
最新评论
这个牛
放下欲望,男人从来不醉,充分且必要
勇气、责任、自信、创新,为天下先!
软件即数据,软件即服务,软件即管理,软件就是对人类各种社会活动的仿真和记录。软件很重要,但软件不可能凌驾于业务之上,尤其不可能高人一等。