归档路径丢失后，归档日志写进了哪里

今天偶然间发现一台服务器crontab里运行的备份数据库的脚本不见了，这台主机几天前升级过磁阵，里面的东西都有丢失，备份脚本应该是那时候弄丢的。

而且又发现归档路径也丢失了，但是数据库运行得好好，那么这几天来的归档日志放到哪里去了呢

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /enip/bmpbackup/ora_arch   --此为归档路径
Oldest online log sequence     73
Next log sequence to archive   78
Current log sequence           78
SQL> ho ls /enip/bmpbackup/ora_arch     --列表归档路径，报错说不存在
ls: 0653-341 The file /enip/bmpbackup/ora_arch does not exist.

SQL> select name from v$archived_log where name is not null;  --于是查看归档日志存放在哪里，都放在上一级目录了，但是日志格式有问题

NAME
--------------------------------------------------
/enip/bmpbackup/ora_arch1_42_763816741.dbf
/enip/bmpbackup/ora_arch1_43_763816741.dbf
/enip/bmpbackup/ora_arch1_44_763816741.dbf
/enip/bmpbackup/ora_arch1_45_763816741.dbf
/enip/bmpbackup/ora_arch1_46_763816741.dbf
/enip/bmpbackup/ora_arch1_47_763816741.dbf
/enip/bmpbackup/ora_arch1_48_763816741.dbf
/enip/bmpbackup/ora_arch1_49_763816741.dbf
/enip/bmpbackup/ora_arch1_50_763816741.dbf
/enip/bmpbackup/ora_arch1_51_763816741.dbf
/enip/bmpbackup/ora_arch1_52_763816741.dbf

NAME
--------------------------------------------------
/enip/bmpbackup/ora_arch1_53_763816741.dbf
/enip/bmpbackup/ora_arch1_54_763816741.dbf
/enip/bmpbackup/ora_arch1_55_763816741.dbf
/enip/bmpbackup/ora_arch1_56_763816741.dbf
/enip/bmpbackup/ora_arch1_57_763816741.dbf
/enip/bmpbackup/ora_arch1_58_763816741.dbf
/enip/bmpbackup/ora_arch1_59_763816741.dbf
/enip/bmpbackup/ora_arch1_60_763816741.dbf
/enip/bmpbackup/ora_arch1_61_763816741.dbf
/enip/bmpbackup/ora_arch1_62_763816741.dbf
/enip/bmpbackup/ora_arch1_63_763816741.dbf

NAME
--------------------------------------------------
/enip/bmpbackup/ora_arch1_64_763816741.dbf
/enip/bmpbackup/ora_arch1_65_763816741.dbf
/enip/bmpbackup/ora_arch1_66_763816741.dbf
/enip/bmpbackup/ora_arch1_67_763816741.dbf
/enip/bmpbackup/ora_arch1_68_763816741.dbf
/enip/bmpbackup/ora_arch1_69_763816741.dbf
/enip/bmpbackup/ora_arch1_70_763816741.dbf
/enip/bmpbackup/ora_arch1_71_763816741.dbf
/enip/bmpbackup/ora_arch1_72_763816741.dbf
/enip/bmpbackup/ora_arch1_73_763816741.dbf
/enip/bmpbackup/ora_arch1_74_763816741.dbf

NAME
--------------------------------------------------
/enip/bmpbackup/ora_arch1_75_763816741.dbf
/enip/bmpbackup/ora_arch1_76_763816741.dbf
/enip/bmpbackup/ora_arch1_77_763816741.dbf

36 rows selected.

SQL> show parameter log_archive_format

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      %t_%s_%r.dbf   --归档日志的日志格式是这种

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
% mkdir /enip/bmpbackup/ora_arch   --重新创建归档路径
% sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Mon Oct 17 19:36:11 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> alter system switch logfile;   --切换日志
 
System altered.

SQL> ho ls -l /enip/bmpbackup/ora_arch   --列表归档路径，这时归档日志在这个路径产生了，格式也正确了
total 17824
-rw-r-----    1 oracle   oinstall    9120256 Oct 17 19:36 1_78_763816741.dbf

总结：归档路径为/enip/bmpbackup/ora_arch ，归档日志格式为%t_%s_%r.dbf ，当归档路径丢失，会在上一级目录产生格式为  ora_arch%t_%s_%r.dbf 的归档日志。