I tried that and got the following error:

SQL> alter system set log_archive_dest_n='/u04/archive_log';
alter system set log_archive_dest_n='/u04/archive_log'
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


Raquel Sikyala


-----Original Message-----
From: Sultan Shiffa [mailto:Sultan.[Email address protected]
Sent: Thursday, November 30, 2006 12:09 PM
To: Sikyala, Raquel
Subject: RE: Setting Archive_log_dest parameter

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email, **and removed
any attachments, and kept your email address secret **from this person,
and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal **Anything below this line is the original email text


Use LOG_ARCHIVE_DEST_N.

log_archive_dest is no more applicable.

-----Original Message-----
From: Sikyala Raquel
[Email address protected]
Sent: 30 November 2006 17:52
To: LazyDBA Discussion
Subject: Setting Archive_log_dest parameter

I enabled archiving when I created a database. I verified this
configuration by typing archive log list at the sql prompt.

------------------

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

------------------------------------------------------------------------
-

I wanted to set the archive destination parameter. I don't know what
USE_DB_RECOVERY_FILE_DEST means. Is this another parameter? Does this
mean that it has already been set? I tried issuing the alter system
command to set the destination parameter and got the following error:

SQL> alter system set ='/u04/archive_log';
alter system set log_archive_dest='/u04/archive_log'
*
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

I don't know what this means. Could someone please help me to resolve
this issue?

Raquel Sikyala




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page