|
原帖由 orain 于 2009-2-3 16:18 发表
我看过了.没有3个.确实只成功了两个.
实验了一下,如果LOG_ARCHIVE_DEST_n参数不指定MANDATORY属性的话,这个参数在找不到归档路径的情况下,就提示错误
比如:
Tue Feb 03 16:34:25 2009
Errors in file d:\admin\ora10g\bdump\ora10g_arc1_5464.trc:
ORA-09291: sksachk: 为归档目标指定的设备无效
OSD-04018: 无法访问指定的目录或设备。
O/SError: (OS 3) 系统找不到指定的路径。
同时,通过select * from v$archive_dest;
可以看到不存在的log_archive_dest_n对应的status是error.
如果指定了LOG_ARCHIVE_DEST_n的属性为MANDATORY,那么连续切换几次后hang住了(道理你也明白)
Tue Feb 03 16:34:25 2009
Cannot translate archive destination string 'LOG_ARCHIVE_DEST_3'
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Feb 03 16:34:25 2009
Errors in file d:\admin\ora10g\bdump\ora10g_arc1_5464.trc:
ORA-16038: 日志 3 sequence# 114 无法归档
ORA-09291: sksachk: 为归档目标指定的设备无效
ORA-00312: 联机日志 3 线程 1: 'D:\ORACLE10G\ORADATA\ORA10G\REDO03.LOG'
Tue Feb 03 16:34:40 2009
Thread 1 cannot allocate new log, sequence 116
Checkpoint not complete
Current log# 1 seq# 115 mem# 0: D:\ORACLE10G\ORADATA\ORA10G\REDO01.LOG
Tue Feb 03 16:34:42 2009
Thread 1 advanced to log sequence 116 (LGWR switch)
Current log# 2 seq# 116 mem# 0: D:\ORACLE10G\ORADATA\ORA10G\REDO02.LOG
Tue Feb 03 16:34:43 2009
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Feb 03 16:34:43 2009
Errors in file d:\admin\ora10g\bdump\ora10g_arc0_2136.trc:
ORA-16014: 日志 3 sequence# 114 未归档, 没有可用的目的地
ORA-00312: 联机日志 3 线程 1: 'D:\ORACLE10G\ORADATA\ORA10G\REDO03.LOG'
Tue Feb 03 16:34:51 2009
Thread 1 cannot allocate new log, sequence 117
Checkpoint not complete
Current log# 2 seq# 116 mem# 0: D:\ORACLE10G\ORADATA\ORA10G\REDO02.LOG
Thread 1 cannot allocate new log, sequence 117
All online logs needed archiving
Current log# 2 seq# 116 mem# 0: D:\ORACLE10G\ORADATA\ORA10G\REDO02.LOG
...
注:log_archive_dest_n参数默认的属性是OPTIONAL.
你试着这么测试一下看看:
alter system set log_archive_dest_3='location=G:\temp MANDATORY' scope=both;
然后再把这个U盘拔掉看看 |
|