总结了一下10g修改归档路径的方法，跟自己想像中的还是有点差别的，凡事都要测试一遍才能保证是正确的。

[@more@]

修改归档日志的路径有两种方法：
1.用LOG_ARCHIVE_DEST 和LOG_ARCHIVE_DUPLEX_DEST参数。
2.用LOG_ARCHIVE_DEST_n 参数在10g中，LOG_ARCHIVE_FORMAT比以前多个了%r参数，记录resetlogs的ID，以便可以容易的恢复过去的incarnation.如不指定此参数，默认为%t_%s_%r.dbf。

下面试试这两种方法的异同

1.先看看b_recovery_file_dest和log_archive_dest并存会有什么问题。

log_archive_dest='/u01/app/oracle/admin/orcl/archive'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648

用此参数文件启动后

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 13
Next log sequence to archive 15
Current log sequence 15

归档目录依然显示USE_DB_RECOVERY_FILE_DEST

SQL> alter system switch logfile;

System altered.

SQL> SELECT RECID, NAME,to_char(first_time,'yyyy-mm-dd:hh24:mi:ss') from V$ARCHIVED_LOG;

RECID NAME TO_CHAR

(FIRST_TIME,
---------- ------------------------------------------------------------------------------------------ --------

-----------
1 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_12_4pqm516c_.arc 2009-01-

13:07:02:23
2 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_13_4pqm5185_.arc 2009-01-

13:07:03:04
3 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_14_4pqm54v0_.arc 2009-01-

13:07:03:15
4 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_8_4pqk8lmn_.arc 2009-01-

13:06:32:31
5 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_12_4pqm18gj_.arc 2009-01-

13:07:02:23
6 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_8_4pqkt8d6_.arc 2009-01-

13:06:32:31
7 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_10_4pqktcw0_.arc 2009-01-

13:06:33:22
8 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_11_4pqlzz7c_.arc 2009-01-

13:06:42:19
9 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_9_4pqk9l4t_.arc 2009-01-

13:06:32:50
10 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_13_4pqm1mpq_.arc 2009-01-

13:07:03:04
11 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_7_4pqk7z7q_.arc 2009-01-

12:13:26:22

RECID NAME TO_CHAR

(FIRST_TIME,
---------- ------------------------------------------------------------------------------------------ --------

-----------
12 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_9_4pqkt8g7_.arc 2009-01-

13:06:32:50
13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_12/o1_mf_1_6_4poo3yk0_.arc 2009-01-

12:03:00:11
14 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_12/o1_mf_1_7_4pok10bf_.arc 2009-01-

12:11:50:54
15 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_12/o1_mf_1_5_4poo2hrt_.arc 2009-01-

10:19:18:34
16 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_12/o1_mf_1_6_4pohjz08_.arc 2009-01-

12:03:00:11
17 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_12/o1_mf_1_4_4poo2f69_.arc 2009-01-

09:22:05:28
18 /u01/app/oracle/admin/orcl/archive/1_15_675592897.dbf 2009-01-

13:07:05:08
19 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2009_01_13/o1_mf_1_15_4pqob6s1_.arc 2009-01-

13:07:05:08

19 rows selected.

switch一次发现，log_archive_dest和DB_RECOVERY_FILE_DEST目录都产生的归档。