修改ORACLE归档日志的路径

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /opt/oracle/product/9.2.0.4/dbs/arch
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7
SQL> alter system set log_archive_dest_1='location=/home/oracle/archive/archive_log';
System altered.
SQL> alter database open;
Database altered.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /home/oracle/archive/archive_log
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7
发现并没有日志产生
[oracle@shanghai ~]$ cd archive/
[oracle@shanghai archive]$ ls
[oracle@shanghai archive]$ ls -l
total 0
[oracle@shanghai archive]$
然后在切换日志
SQL> alter system switch logfile;
System altered.
再次去刚才在oracle家目录创建archive下查看是否生成归档日志