模拟故障 关闭备库 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. 模拟插入数据,归档,并且删除归档 SQL> insert into test values(23); 1 row created. SQL> alter system switch logfile; System altered. SQL> insert into test value
oracle dg 状态检查 先检查备库的归档日志同步情况 SELECT NAME,applied FROM v$archived_log; alter database recover managed standby database cancel; select thread#,sequence#,standby_dest,archived,applied,status from v$archived_log order by 1,2; alter database recover mana
ORACLE DG在线日志添加日志成员 SQL>select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#;#记录日志应用的位置SQL> select GROUP#,BYTES/1024/1024 from v$log;SQL> select GROUP#,BYTES/1024/1024,STATUS from v$standby_log; 主库
ORACLE DG在线日志修改 SQL>select SEQUENCE#,first_time,next_time,APPLIED, THREAD# from v$archived_log order by SEQUENCE#,THREAD#; select * from v$logfile order by GROUP# ; SQL> select GROUP#,BYTES/1024/1024 from v$log; SQL> select GROUP#,BYTES/1024/102
###oracle dg 报错提示 涉及硬盘错误 Dec 23 03:28:01 xhisdg rsyslogd: [origin software="rsyslogd" swVersion="5.8.10" x-pid="4554" x-info="http://www.rsyslog.com"] rsyslogd was HUPed Dec 23 03:28:03 xhisdg rhsmd: In order for Su