修改归档日志路径

一、查看当前归档日志路径

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

二、修改归档日志路径

SQL> alter system set log_archive_dest_1='location=/oracle/archive';

三、再次查看修改后归档日志路径

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/archive
Oldest online log sequence 2
Next log sequence to archive 4
Current log sequence 4

四、切换归档日志验证是否修改成功

SQL> alter system switch logfile;

System altered.

With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dgdb1 dbs]$ cd /oracle/archive/
[oracle@dgdb1 archive]$ ls
1_4_1024761634.dbf

可以看到切换日志之后，在/oracle/archive路径下有新的归档日志产生。