Home » Server Options » Data Guard » ORA-00312 - ORA-00314 (Database Disconnect From Session)
icon5.gif  ORA-00312 - ORA-00314 (Database Disconnect From Session) [message #221630] Tue, 27 February 2007 17:05 Go to next message
alertmax
Messages: 4
Registered: February 2007
Junior Member
please...
look this problem...

I configure 2 databases in my machine.....

and...its working if i execute this command in the db standby.
Alter Database Recover Managed Standby Database ;


but if i execute this command other command
Alter Database Recover Managed Standby Database Disconnect From Session;

i have this error in the primary database
:

======================================================
SQL> /
alter system switch logfile
*
ERRO na linha 1:
ORA-00314: log do thread ; seqüência# esperada não corresponde a


SQL> startup
Instância ORACLE iniciada.

Total System Global Area 142606336 bytes
Fixed Size 1247756 bytes
Variable Size 104859124 bytes
Database Buffers 33554432 bytes
Redo Buffers 2945024 bytes
Banco de dados montado.
ORA-00314: log 1 do thread 1; seqüência# esperada 11 não corresponde a 0
ORA-00312: thread 1 do log 1 on-line: 'C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\REDO01.LOG'

Anyone knows what is it?

Thanks

[Updated on: Tue, 27 February 2007 17:38]

Report message to a moderator

Re: ORA-00312 - ORA-00314 (Database Disconnect From Session) [message #221792 is a reply to message #221630] Wed, 28 February 2007 07:58 Go to previous message
alertmax
Messages: 4
Registered: February 2007
Junior Member
i think my standby database is writing in my online redo logs...

Previous Topic: Dataguard - Primary died automatically and redo log out of sequece
Next Topic: Replication using clustered servers and SAN partitioning - with Standard Edition
Goto Forum:
  


Current Time: Fri Mar 29 02:52:02 CDT 2024