RE: Setting Archive_log_dest parameter

RE: Setting Archive_log_dest parameter

 

  

Hope this one will work for you...

alter system set log_archive_dest_1='location=/u04/archive_log'
scope=spfile;

Good luck.

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x3396326.[Email address protected]
Sent: Thursday, November 30, 2006 12:37 PM
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter


I just tried and got the following:

SQL> alter system set log_archive_dest_1='/u04/archive_log' scope=both;
alter system set log_archive_dest_1='/u04/archive_log' 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

Raquel Sikyala


-----Original Message-----
From: Graaff Eric de
[mailto:oracledba-ezmlmshield-x45158280.[Email address protected]
Sent: Thursday, November 30, 2006 12:36 PM
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter

Have you tried:

SQL> alter system set log_archive_dest_1='/u04/archive_log' scope=both;

Eric
-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x25860553.[Email address protected]
Sent: donderdag 30 november 2006 18:31
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter

I entered a number and got the following error:

SQL> alter system set log_archive_dest_1='/u04/archive_log'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with
SPFILE

I tried the following command:

SQL> show parameter db_file_recovery_dest;

There was no output.




Raquel Sikyala


-----Original Message-----
From: Walker Jed S
[mailto:oracledba-ezmlmshield-x36709750.[Email address protected]
Sent: Thursday, November 30, 2006 12:23 PM
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter

The n is for a number (e.g. log_archive_dest_1). You apparently have
db_recovery_file_dest set so you should be archiving to that location
(show parameter db_file_recovery_dest).

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x4172296.[Email address protected]
Sent: Thursday, November 30, 2006 10:15 AM
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter

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



---------------------------------------------------------------------
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




---------------------------------------------------------------------
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


---------------------------------------------------------------------
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



The information included in this message is personal and/or confidential
and intended exclusively for the addressees as stated. This message
and/or the accompanying documents may contain confidential information
and should be handled accordingly. If you are not the intended reader of
this message, we urgently request that you notify Centric immediately
and that you delete this e- mail and any copies of it from your system
and destroy any printouts immediately.
It is forbidden to distribute, reproduce, use or disclose the
information in this e-mail to third parties without obtaining prior
permission from Centric. We expressly point out that there are risks
associated with the use of e-mail. Centric and the companies within the
group shall not accept any liability whatsoever for damage resulting
from the use of e-mail. Legally binding obligations can only arise for
Centric by means of a written instrument, signed by an authorized
representative of Centric.



---------------------------------------------------------------------
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


---------------------------------------------------------------------
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