Thanks it worked.
SQL> alter system set DB_RECOVERY_FILE_DEST='/u05/archive_log' scope=both;
System altered.
Raquel Sikyala
-----Original Message-----
From: Jean Carlos Omobono Zabala [mailto:oracledba-ezmlmshield-x6445344.[Email address protected]
Sent: Thursday, November 30, 2006 12:35 PM
To: LazyDBA Discussion
Subject: RE: Setting Archive_log_dest parameter
The parameter is DB_RECOVERY_FILE_DEST. This is new in 10g, since it use the Flash Recovery Area.
___________________________
TSU Jean Carlos Omobono Zabala
Administrador de Base de Datos
Gcia. Arquitectura y Seguridad
Banco Federal
Tlf. 212-9015199
-----Mensaje original-----
De: Sikyala Raquel [mailto:oracledba-ezmlmshield-x25860553.[Email address protected]
Enviado el: Jueves, 30 de Noviembre de 2006 01:31 p.m.
Para: LazyDBA Discussion
Asunto: 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
*************** BANCO FEDERAL´S INTERNET E-MAIL USE ********************
This message may contain information solely of the interest of BANCOFEDERAL or its businesses. Copying, distribution, disclosure or any use of the information contained in this transmission is permitted only to authorized parties. If you have received this e-mail by error, please destroy it and notify [Email address protected] or the sender by reply email.
****** USO DEL CORREO ELECTRONICO DE BANCO FEDERAL HACIA INTERNET ******
Esta nota puede contener información de interes solo para BANCO FEDERAL o sus negocios. Solo esta permitida su copia, distribución o uso a personas autorizadas. Si recibió esta nota por error, por favor destrúyala y notifique al remitente o al [Email address protected]
*************** BANCO FEDERAL´S INTERNET E-MAIL USE ********************
This message may contain information solely of the interest of BANCOFEDERAL or its businesses. Copying, distribution, disclosure or any use of the information contained in this transmission is permitted only to authorized parties. If you have received this e-mail by error, please destroy it and notify [Email address protected] or the sender by reply email.
****** USO DEL CORREO ELECTRONICO DE BANCO FEDERAL HACIA INTERNET ******
Esta nota puede contener información de interes solo para BANCO FEDERAL o sus negocios. Solo esta permitida su copia, distribución o uso a personas autorizadas. Si recibió esta nota por error, por favor destrúyala y notifique al remitente o al [Email address protected]
---------------------------------------------------------------------
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