在客户环境中,应用了Oracle 10.2.0.4 DataGuard技术,透过最大可用性形式进展数据保护。
以次简略测试,应备库封闭后,再重启备库,主库及备库的响应历程。
在备库实施如次方法:
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084400 bytes
Variable Size 385876432 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14692352 bytes
Database mounted.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> exit
应备库封锁后,主库马上检测到备库的失败:
Tue Nov 17 20:34:58 2009
ARC一: Attempting destination LOG_ARCHIVE_DEST_二 network reconnect (3113)
ARC一: Destination LOG_ARCHIVE_DEST_二 network reconnect abandoned
PING[ARC一]: Error 3113 when pinging standby STANDBY.
Tue Nov 17 20:35:17 2009
LGWR: Attempting destination LOG_ARCHIVE_DEST_二 network reconnect (3113)
LGWR: Destination LOG_ARCHIVE_DEST_二 network reconnect abandoned
Tue Nov 17 20:35:17 2009
Errors in file /opt/oracle/admin/oradbt/bdump/oradbt_lgwr_319632.trc:
ORA-03113: end-of-file on communication channel
LGWR: Network asynch I/O wait error 3113 log 一 service 'STANDBY'
Tue Nov 17 20:35:17 2009
Destination LOG_ARCHIVE_DEST_二 is UNSYNCHRONIZED
LGWR: Failed to archive log 一 thread 一 sequence 3466 (3113)
Tue Nov 17 20:35:18 2009
LGWR: Closing remote archive destination LOG_ARCHIVE_DEST_二: 'STANDBY' (error 3113)
(oradbt)
Tue Nov 17 20:35:18 2009
Errors in file /opt/oracle/admin/oradbt/bdump/oradbt_lgwr_319632.trc:
ORA-01041: internal error. hostdef extension doesn't exist
LGWR: Error 1041 closing archivelog file 'STANDBY'
LGWR: Error 1041 disconnecting
Oracle Dataguard备库失败与主库响应测试方案
最新推荐文章于 2022-02-10 08:00:00 发布
本文介绍了在Oracle 10.2.0.4 DataGuard环境中,当备库关闭并重新启动后,主库和备库的响应过程。主库在备库关闭时会立即检测到失败,并尝试重新连接。备库重启后,经过一段时间的恢复,最终恢复同步。详细记录了主库和备库的恢复日志,展示了DataGuard在故障恢复中的行为。
摘要由CSDN通过智能技术生成