Home » Server Options » Data Guard » ORA-00305: log 2 of thread 1 inconsistent;
ORA-00305: log 2 of thread 1 inconsistent; [message #323902] Fri, 30 May 2008 00:15 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00305: log 2 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 2 thread 1:
'/newdata/app/oracle/oradata/EASTLEG/redo02.log'


EASTLEG is my primary databae and ESTLG_LS is my logical standby dataabse.

when i going to open my primary database it gives me above error.

and my logical standby database also open but not get redo.

can you please tell me how can i remove inconsistency for redo log in both database

Re: ORA-00305: log 2 of thread 1 inconsistent; [message #323923 is a reply to message #323902] Fri, 30 May 2008 01:12 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

if i have archive log only current log archive not.
and no backup
using controlfile how can i apply last all archive on database and open it.

recover database using controlfile until time '';

can you tell me how can i find time and what clause i used for that.
Re: ORA-00305: log 2 of thread 1 inconsistent; [message #323972 is a reply to message #323902] Fri, 30 May 2008 03:21 Go to previous message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
try v$archived_log view
Previous Topic: Dataguard implementation steps
Next Topic: rman 05507
Goto Forum:
  


Current Time: Thu Oct 30 07:35:31 CDT 2014

Total time taken to generate the page: 0.13179 seconds