![](https://img-blog.csdnimg.cn/20200410114713133.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
Oracle ADG
关于Oracle ADG
lsdb
这个作者很懒,什么都没留下…
展开
-
Oracle DG 状态健康检查
-- 在PRIMARY 确认正常:primary> select status, error from v$archive_dest where status <> 'INACTIVE';select * from v$archive_processes where status <> 'STOPPED';show parameter dest_2show parameter state_2--alter system set log_archive_dest_s.原创 2020-06-02 10:37:06 · 4109 阅读 · 0 评论 -
ADG 读库重启步骤
ADG 读库先关闭MRP进程 然后关闭实例# connect / as sysdbaSQL> alter database recover managed standby database cancel;SQL> recover standby database until cancel;autoSQL> shutdown immediateSQL> exitADG 读库开启# connect / as sysdbaSQL> startup nom.原创 2020-05-28 12:18:56 · 730 阅读 · 0 评论