Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

change the use of log_archive_dest to log_archive_dest_n

479048Dec 3 2007 — edited Dec 3 2007

Hi,

I have a database running in archivelog mode using log_archive_dest parameter. I am trying to switch to use log_archive_dest_n. using the following sql command I get the following results:

SQL> alter system set log_archive_dest='<directory>';
alter system set log_archive_dest='<directory>'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
DB_RECOVERY_FILE_DEST

Could I know how else could I turn off log_archive_dest and switch to log_archive_dest_n?

Thanks!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2007

Added on Dec 3 2007

#general-database-discussions

6 comments

910 views