Moving log_archive_dest_n to {null} location

One of the DB got so busy that it fills up the 100GB archivelog destination in two days.
So I have to move it to a bigger location which is the flash back recovery area (/fra 1.4TB)

I’ve successfully moved it while online using:
> alter system set log_archive_dest_10= ‘LOCATION=USE_DB_RECOVERY_FILE_DEST’;

Now i need to clear og_archive_dest_1 so it does’nt write anymore logs to that place, but how?

At one point i get this error:

ORA-32017: failure in updating SPFILE
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to “log_archive_dest_1” not allowed with SPFILE

Modifying log_archive_dest_n will return this error due to invalid syntax. This parameter is dynamic and can be updated using the ALTER SYSTEM statement.

Here is an example of an error raised when trying up modify the parameter log_archive_dest_1 to NULL.

SQL> alter system set log_archive_dest_1=NULL scope=both;
alter system set log_archive_dest_1=NULL
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to “log_archive_dest_1” not allowed with SPFILE

To update this parameter to NULL or to a valid location use the following syntax:
SQL> alter system set log_archive_dest_1=’LOCATION=NULL’ scope=both;

note:
nightly rman backup script issues ‘delete noprompt archivelog until time ‘sysdate -2’;

we don’t ‘delete input ‘ because there is another backup job to tape that runs periodically too.

Advertisements

About this entry