Home » Server Options » Data Guard » ORA-00344: unable to re-create online log
ORA-00344: unable to re-create online log [message #323336] Wed, 28 May 2008 04:28 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

here i want to create logical standby database using cold backup

when i want to open my logical standby database beloved error come.


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/newdata/app/oracle/oradata/EASTLEG/redo03.log'
ORA-27086: skgfglk: unable to lock file - already in use
Linux Error: 11: Resource temporarily unavailable
Additional information: 8


here /newdata/app/oracle/oradata/EASTLEG/ is path for primary dataabse log file.
i want standby redo in /newdata/app/oracle/oradata/EASTLEG/ path.

tell me how to create logfile for standby database ESTLG_LS.
Re: ORA-00344: unable to re-create online log [message #323563 is a reply to message #323336] Wed, 28 May 2008 19:02 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you creating the standby on the same box?

Did you set LOG_FILE_NAME_CONVERT ?
Re: ORA-00344: unable to re-create online log [message #323620 is a reply to message #323563] Thu, 29 May 2008 00:50 Go to previous message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

yes
this is the error
this error is solved now.

but the new error which i get is i start my logical standby database and get archive in logical standby folder means
in /u02/app/oracle/admin/ESTLG_LS/arch/

get all archived log but in V$archived_log that archived_log not display why?
what is the problem over there.
Previous Topic: data guard with oracle apps
Next Topic: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Goto Forum:
  


Current Time: Thu Mar 28 04:54:11 CDT 2024