Unable to change the log archive location

[matthew00]

Hi all,

can someone please tell me why the location of the archive log is not changing after I already pointed to the new location?

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 536
Next log sequence to archive 538
Current log sequence 538
SQL> alter system archive log start to '/oracle/archlogs/TEST/archTEST';

System altered.

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



Thanks all,

[LKBrwn_DBA]

Try:

Alter System Set Log_Archive_Dest_1='LOCATION=/oracle/..etc..' scope=both;

[matthew00]

Alter System Set Log_Archive_Dest_1='/oracle/archlogs/TEST' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE

[ebrian]

Re-read LKBrwn_DBA's syntax closely.

[matthew00]

thx