Oracle12Dataguard启停

原创
2020/12/18 10:37
阅读数 130

 检查
select name,open_mode,database_role,cdb from v$database;
select name,open_mode,con_id,dbid from v$containers;
!ps -ef | grep mrp
show con_name
show parameters db_unique_name;
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

alter system switch logfile;
select max(sequence#) from v$archived_log where archived='YES';

select * from v$logfile;
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

(一)Active DataGuard启动顺序
(1)启动监听,先启从库再起主库
lsnrctl start

(2)启动数据库,先启动备库在启主库

--先启备库

sql>startup
alter database recover managed standby database disconnect from session;

        
--再启主库
sql>startup

(二)DataGuard关闭顺序

(1)先关主库数据库:

sql>shutdown immediate;

(2)再关备用库:
sql>alter database recover managed standby database cancel;
sql>shutdown immediate;

 

展开阅读全文
加载中

作者的其它热门文章

打赏
0
0 收藏
分享
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部