In the customer environment, Oracle10.2.0.4DataGuard technology is used to protect data through the maximum availability mode. In the following simple test, when the slave database is closed
In the customer environment, Oracle 10.2.0.4 universal uard technology is used to protect data through the maximum availability mode. In the following simple test, when the slave database is closed
In the customer environment, Oracle 10.2.0.4 universal uard technology is used to protect data through the maximum availability mode.
In the following simple test, when the slave database is closed, restart the slave database and the response process of the master and slave databases.
Perform the following steps in the slave database:
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
When the slave database is closed, the master database immediately detects the failure of the slave database:
Tue Nov 17 20:34:58 2009
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
PING [ARC1]: Error 3113 when pinging standby.
Tue Nov 17 20:35:17 2009
LGWR: Attempting destination log_archive _dest_2 network reconnect (3113)
LGWR: Destination LOG_ARCHIVE_DEST_2 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 1 service 'standby'
Tue Nov 17 20:35:17 2009
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
LGWR: Failed to archive log 1 thread 1 sequence 3466 (3113)
Tue Nov 17 20:35:18 2009
LGWR: Closing remote archive destination LOG_ARCHIVE_DEST_2: '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 from destination LOG_ARCHIVE_DEST_2 standby host 'standby'
,