ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

[fayevalentine]

Hello

Trying to restore an Oracle 11g database in linux I get this message: ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified


These are the steps I do:

SQL> STARTUP NOMOUNT PFILE='/oracle/product/11.2.0/dbhome_1/dbs/pfileEMR.ora';
ORACLE instance started.

Total System Global Area 6.8413E+10 bytes
Fixed Size 2243608 bytes
Variable Size 1.5838E+10 bytes
Database Buffers 5.2479E+10 bytes
Redo Buffers 93614080 bytes

SQL> alter database mount;

Database altered.

SQL> show parameter LOG_ARCHIVE_DUPLEX_DEST;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string /oracle/log_archive/des
t0
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

I set the variable LOG_ARCHIVE_DUPLEX_DEST inside file pfileBDSID.ora like this:

BDSID.LOG_ARCHIVE_DUPLEX_DEST= '/oracle/log_archive/dest0'
BDSID.LOG_ARCHIVE_DEST= '/test_log'
BDSID.LOG_ARCHIVE_MIN_SUCCEED_DEST= 1

but the error ORA-01052 persists.
Can anyone give me an idea, a different aproach?

Thanks in advance.

 

[Beilstwh]

does the folder /oracle/log_archive/dest0 exist on the database server and is it owned by the oracle user and oracle group (typically oracle:dba)

Bill
Lead Application Developer
New York State, USA

 

[fayevalentine]

Hello Beilstwh

Thank you very much these were the folder permissions:


[oracle@machinedb dbs]$ ls -la /oracle/log_archive/
total 136
drwxr-xr-x. 34 oracle oinstall 4096 Nov 25 12:53 .
drwxr-xr-x. 8 oracle oinstall 4096 Nov 26 13:18 ..
drwxr-xr-x. 2 oracle oinstall 4096 Nov 25 12:52 dest0

cause the path is inside oracle installation folder, I changed them to group dba owner and gave it write permissions:

[oracle@machinedb log_archive]$ ls -la
total 136
drwxr-xr-x. 34 oracle oinstall 4096 Nov 25 12:53 .
drwxr-xr-x. 8 oracle oinstall 4096 Nov 26 13:18 ..
drwxrwxr-x. 2 oracle dba 4096 Nov 25 12:52 dest0


but the error persists:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

Any other advice?
Thanks in advance.

 

[fayevalentine]

Also I tried with new path outside of oracle install home:

BDSID.LOG_ARCHIVE_DUPLEX_DEST= '/app/archive_log/dest0'

with permissions:

drwxr-xr-x. 3 oracle dba 4096 Nov 27 14:22 app

SQL> STARTUP NOMOUNT PFILE='/oracle/product/11.2.0/dbhome_2/dbs/pfileBDSID.ora';
ORACLE instance started.

Total System Global Area 6.8413E+10 bytes
Fixed Size 2243608 bytes
Variable Size 1.5838E+10 bytes
Database Buffers 5.2479E+10 bytes
Redo Buffers 93614080 bytes
SQL> show parameter LOG_ARCHIVE_DUPLEX_DEST;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_duplex_dest string /app/archive_log/dest0
SQL> alter database mount;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01052: required destination LOG_ARCHIVE_DUPLEX_DEST is not specified

Regards.