ORA-03113:end-of-fileoncommunicationchannelORA-16072:aminimumof
altert.log内容如下:
LGWR:STARTINGARCHPROCESSESCOMPLETE
LGWR:PrimarydatabaseisinMAXIMUMPROTECTIONmode
ThuAug3017:18:052012
DestinationLOG_ARCHIVE_DEST_2isSYNCHRONIZED
LGWR:DestinationLOG_ARCHIVE_DEST_1isnotservicedbyLGWR
ARCtstartedwithp id=46,OS id=21202
ARCnstartedwithp id=40,OS id=21190
LNSbstartedwithp id=47,OS id=21204
ThuAug3017:18:082012
Errorsinfile/u01/oracle/admin/beijing/bdump/beijing_lgwr_20933.trc:
ORA-16143:RFSconnectionsnotallowedduringorafterterminalrecovery
ThuAug3017:18:082012
LGWR:Error16143verifyingarchivelogdestinationLOG_ARCHIVE_DEST_2
ThuAug3017:18:082012
DestinationLOG_ARCHIVE_DEST_2isUNSYNCHRONIZED
LGWR:Error16143disconnectingfromdestinationLOG_ARCHIVE_DEST_2standbyhost'tianjin'
LGWR:Continuing...
LGWR:Minimumof1applicablestandbydatabaserequired
ThuAug3017:18:122012
Errorsinfile/u01/oracle/admin/beijing/bdump/beijing_lgwr_20933.trc:
ORA-16072:aminimumofonestandbydatabasedestinationisrequired
ThuAug3017:18:122012
Errorsinfile/u01/oracle/admin/beijing/bdump/beijing_lgwr_20933.trc:
ORA-16072:aminimumofonestandbydatabasedestinationisrequired
LGWR:terminatinginstanceduetoerror16072
InstanceterminatedbyLGWR,p id=20933
beijing_lgwr_20933.trc内容如下:
Error16143attachingRFSservertostandbyinstanceathost'tianjin'
ORA-16143:RFSconnectionsnotallowedduringorafterterminalrecovery
***2012-08-3017:18:08.56560679kcrr.c
LGWR:Error16143verifyingarchivelogdestinationLOG_ARCHIVE_DEST_2
***2012-08-3017:18:08.56655444kcrr.c
MakingupidhsrequesttoLNSb(ocis0x0xbfffdb58).BegintimeisandNET_TIMEOUTseconds
NetServerpid:21204
***2012-08-3017:18:12.56755616kcrr.c
upidhsdonestatus16143