Hello,
Im database administrator.
An Oracle OC database and ACX replica were installed. I created the spfile and configured the parameters.
When I changed the parameters, I got an error:
SQL> alter system set log_archive_dest_1='location=+FRA valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=DEOE' scope=both;
ERROR en l▒nea 1:
ORA-02097: no se puede modificar el par▒metro porque el valor especificado no es v▒lido
ORA-16019: no se puede utilizar LOG_ARCHIVE_DEST_1 con LOG_ARCHIVE_DEST ni con LOG_ARCHIVE_DUPLEX_DEST
Investigating, I found a solution and applied it.
alter system set log_archive_dest=' ';
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=482725405859723&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2027991.1&_afrWindowMode=0&_adf.ctrl-state=sjvlyz1qx_4
But when I get into the rman and send the run
run {
duplicate target database for standby from active database
spfile
.
.
I have the error:
conectado a la base de datos auxiliar (no iniciado)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando Duplicate Db en 08/16/2024 14:40:23
RMAN-05501: abortando duplicado de la base de datos destino
RMAN-03015: se ha producido un error en el script Memory Script almacenado
RMAN-04014: fallo al iniciar: ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_
Someone knows about a solution?