Setting Archive Log parameters in Oracle 10G

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 log_archive_dest='/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?
sikyalaSenior Database AdministratorAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DarthModConnect With a Mentor Commented:
Per the comments posted at http://www.experts-exchange.com/Q_22078111.html, this question has been submitted to PAQ (500 points refunded).

DarthMod
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.