oracle归档问题

Question

LOG_ARCHIVE_DEST_nThis parameter is valid only if you have installed the Oracle Enterprise Edition. You may continue to use LOG_ARCHIVE_DEST if you have installed the Oracle Enterprise Edition, however you cannot use both LOG_ARCHIVE_DEST_n and LOG_ARCHIVE_DEST as they are not compatible

Answer 1

你可以用 LOG_ARCHIVE_DUPLEX_DEST

Answer 2

log_archive_start = true
log_archive_dest_1 = "location=E:\oracle\oradata\sid\archive1"
log_archive_dest_2 = "location=E:\oracle\oradata\sid\archive2"
log_archive_dest_3 = "location=E:\oracle\oradata\sid\archive3"
...
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
去掉＃

Answer 3

log_archive_dest与log_archive_dest_n能否共用?

Answer 4

简单解释一下：
在oracle8i中这个参数可以指定5个位置，9i中增加至10个.
Log_archive_dest_n的语法格式是：
LOG_ARCHIVE_DEST_n = “” |
((SERVICE = <tnsnames_name> |
LOCATION = ‘<directory_name>’)
[MANDATORY | OPTIONAL]
[REOPEN [= <integer>]])
举个例子你就明白了：
1、LOG_ARCHIVE_DEST_1 = ((LOCATION=’/archive/MYDB01’) MANDATORY REOPEN = 60)
 mandatory指出的是一定要成功，reopen指出的是如未成功，再间隔多少秒重试，其缺省值为300秒
2、LOG_ARCHIVE_DEST_2 = (SERVICE=STDBY01) OPTIONAL REOPEN;
 的在远程的一个standby机器开一个归档位置,STDBY01是通过net8来配置的。
相关的参数有：
 LOG_ARCHIVE_MIN_SUCCEED_DEST指出的最少成功的归档们置

Answer 5

log_archive_dest与log_archive_dest_n不能共用

Answer 6

to lianhg:
  改完之后,启动数据库时,提示:
"ora-00439: feature not enabled:Managed standby"
请指教,如何处理?我只设
log_archive_dest ="D:\..."时是没问题的!

Answer 7

d: 建立：
"ｄ:\oracle\oradata\sid\archive1"
"ｄ:\oracle\oradata\sid\archive2"
"ｄ:\oracle\oradata\sid\archive3"

Answer 8

to lianhg:
  那当然是已经建立了!

Answer 9

1)select * from v$parameter; 有如下：
182 log_archive_start                                                         1 FALSE                    
185 log_archive_dest                                                          2                          
186 log_archive_duplex_dest                                                   2                          
187 log_archive_dest_1                                                        2                          
188 log_archive_dest_2                                                        2                          
NUM NAME                                                                   TYPE VALUE                    
--- ---------------------------------------------------------------- ---------- -------------
189 log_archive_dest_3                                                        2                          
190 log_archive_dest_4                                                        2                          
191 log_archive_dest_5                                                        2                          
192 log_archive_dest_state_1                                                  2 enable                   
193 log_archive_dest_state_2                                                  2 enable                   
194 log_archive_dest_state_3                                                  2 enable                   
195 log_archive_dest_state_4                                                  2 enable                   
196 log_archive_dest_state_5                                                  2 enable                   
197 log_archive_max_processes                                                 3 1                        
198 log_archive_min_succeed_dest                                              3 1                        
199 standby_archive_dest                                                      2 %ORACLE_HOME%\RDBMS      
　　　那么，你的版本支持log_archive_dest_n，否则不支持该参数！！！只能　“可以用 LOG_ARCHIVE_DUPLEX_DEST”