不能归档问题的处理：

不能归档的问题处理：

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/