ORACLE 11g 修改Archive Log存放路徑

啟動archive mode後:

SQL> archive log list
Database log mode                  Archive Mode
Automatic archival                   Enabled
Archive destination                  USE_DB_RECOVERY_FILE_DEST     #預設值
Oldest online log sequence       12
Next log sequence to archive   14
Current log sequence               14

修改archive log存放路徑:
SQL> alter system set LOG_ARCHIVE_DEST_1='LOCATION=/路徑' SCOPE=SPFILE;
如: alter system set LOG_ARCHIVE_DEST_1='LOCATION=/archlog' SCOPE=SPFILE;
restart the database
SQL> archive log list
Database log mode                  Archive Mode
Automatic archival                   Enabled
Archive destination                  /archlog  
Oldest online log sequence       12
Next log sequence to archive   14
Current log sequence               14