不能归档的问题处理:
Sun May 04 09:20:40 2008
ARC0: Evaluating archive log 3 thread 1 sequence 41
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log 3 thread 1 sequence 41
Sun May 04 09:20:40 2008
Errors in file d:\oracle\auxdb\bdump\auxdb2_arc0_2364.trc:
ORA-16014: log 3 sequence# 41 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03_B.LOG'
Sun May 04 09:21:41 2008
ARC0: Evaluating archive log 3 thread 1 sequence 41
ARC0: Archiving not possible: No primary destinations
ARC0: Failed to archive log 3 thread 1 sequence 41
Sun May 04 09:21:41 2008
Errors in file d:\oracle\auxdb\bdump\auxdb2_arc0_2364.trc:
ORA-16014: log 3 sequence# 41 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03_B.LOG'
Dump file d:\oracle\auxdb\bdump\auxdb2_arc0_2364.trc
Sun May 04 09:19:55 2008
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: auxdb2
Redo thread mounted by this instance: 1
Oracle process number: 12
Windows thread id: 2364, image: ORACLE.EXE
*** SESSION ID:(9.1) 2008-05-04 09:19:55.000
ORA-16014: log 3 sequence# 41 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03_B.LOG'
ORA-16014: log 3 sequence# 41 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03.LOG'
ORA-00312: online log 3 thread 1: 'D:\ORACLE\AUXDB\DATA\REDO03_B.LOG'
处理过程:
SQL> show parameter log_arch
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
SERVICE=tstdb
log_archive_dest_3 string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string
enable
log_archive_dest_state_10 string
enable
log_archive_dest_state_2 string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
enable
log_archive_dest_state_3 string
enable
log_archive_dest_state_4 string
enable
log_archive_dest_state_5 string
enable
log_archive_dest_state_6 string
enable
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_state_7 string
enable
log_archive_dest_state_8 string
enable
log_archive_dest_state_9 string
enable
log_archive_duplex_dest string
log_archive_format string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
%s_%t.arc
log_archive_max_processes integer
2
log_archive_min_succeed_dest integer
1
log_archive_start boolean
TRUE
log_archive_trace integer
0
SQL> show parameter standby
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
standby_archive_dest string
D:\oracle\auxdb\standbyArch
standby_file_management string
auto
SQL> alter system set log_archive_dest_1='location=d:\oracle\auxdb
scope=both;
系统已更改。
SQL> show parameter log_archive_dest
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest string
log_archive_dest_1 string
location=d:\oracle\auxdb2\stan
dbyArch
log_archive_dest_10 string
log_archive_dest_2 string
SERVICE=tstdb
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string
enable
log_archive_dest_state_10 string
enable
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_state_2 string
enable
log_archive_dest_state_3 string
enable
log_archive_dest_state_4 string
enable
log_archive_dest_state_5 string
enable
log_archive_dest_state_6 string
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
enable
log_archive_dest_state_7 string
enable
log_archive_dest_state_8 string
enable
log_archive_dest_state_9 string
enable
SQL>
至此问题解决!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8102208/viewspace-258760/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8102208/viewspace-258760/