空间管理您的位置: ITPUB个人空间 » victor1010的个人空间 » 日志

不能归档问题的处理：

上一篇 / 下一篇 2008-05-04 10:05:02 / 个人分类：ARCH

不能归档的问题处理：

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>

至此问题解决！

导入论坛引用链接收藏分享给好友推荐到圈子管理举报

TAG:

查看全部评论