早教吧 育儿知识 作业答案 考试题库 百科 知识分享

ORA-03113:end-of-fileoncommunicationchannelORA-16072:aminimumofaltert.log内容如下:LGWR:STARTINGARCHPROCESSESCOMPLETELGWR:PrimarydatabaseisinMAXIMUMPROTECTIONmodeThuAug3017:18:052012DestinationLOGARCHIVEDEST2isSYNCHRON

题目详情
ORA-03113: end-of-file on communication channel ORA-16072: a minimum of
altert.log内容如下:
LGWR: STARTING ARCH PROCESSES COMPLETE
LGWR: Primary database is in MAXIMUM PROTECTION mode
Thu Aug 30 17:18:05 2012
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED
LGWR: Destination LOG_ARCHIVE_DEST_1 is not serviced by LGWR
ARCt started with pid=46, OS id=21202
ARCn started with pid=40, OS id=21190
LNSb started with pid=47, OS id=21204
Thu Aug 30 17:18:08 2012
Errors in file /u01/oracle/admin/beijing/bdump/beijing_lgwr_20933.trc:
ORA-16143: RFS connections not allowed during or after terminal recovery
Thu Aug 30 17:18:08 2012
LGWR: Error 16143 verifying archivelog destination LOG_ARCHIVE_DEST_2
Thu Aug 30 17:18:08 2012
Destination LOG_ARCHIVE_DEST_2 is UNSYNCHRONIZED
LGWR: Error 16143 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'tianjin'
LGWR: Continuing...
LGWR: Minimum of 1 applicable standby database required
Thu Aug 30 17:18:12 2012
Errors in file /u01/oracle/admin/beijing/bdump/beijing_lgwr_20933.trc:
ORA-16072: a minimum of one standby database destination is required
Thu Aug 30 17:18:12 2012
Errors in file /u01/oracle/admin/beijing/bdump/beijing_lgwr_20933.trc:
ORA-16072: a minimum of one standby database destination is required
LGWR: terminating instance due to error 16072
Instance terminated by LGWR, pid = 20933
beijing_lgwr_20933.trc内容如下:
Error 16143 attaching RFS server to standby instance at host 'tianjin'
ORA-16143: RFS connections not allowed during or after terminal recovery
*** 2012-08-30 17:18:08.565 60679 kcrr.c
LGWR: Error 16143 verifying archivelog destination LOG_ARCHIVE_DEST_2
*** 2012-08-30 17:18:08.566 55444 kcrr.c
Making upidhs request to LNSb (ocis 0x0xbfffdb58). Begin time is and NET_TIMEOUT seconds
NetServer pid:21204
*** 2012-08-30 17:18:12.567 55616 kcrr.c
upidhs done status 16143
*** 2012-08-30 17:18:12.567 60679 kcrr.c
LGWR: Error 16143 disconnecting from destination LOG_ARCHIVE_DEST_2 standby host 'tianjin'
Ignoring krslvna() detach error 16143
Continuing...
Standby database verification failed:16072
ORA-16072: a minimum of one standby database destination is required
error 16072 detected in background process
ORA-16072: a minimum of one standby database destination is required
standby alert.log:
-- Connected User is Valid
RFS[3]: Assigned to RFS process 25836
RFS[3]: Identified database type as 'physical standby'
RFS[3]: No connections allowed during/after terminal recovery.
Fri Aug 31 15:07:51 2012
Errors in file /u01/oracle/admin/tianjin/udump/tianjin_rfs_25836.trc:
ORA-16143: RFS connections not allowed during or after terminal recovery
▼优质解答
答案和解析
你想让回答什么