Home » Server Options » Data Guard » Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover
Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover [message #155210] Thu, 12 January 2006 17:06 Go to next message
npriya
Messages: 2
Registered: January 2006
Junior Member
Hi,
Following the 9i documentation, I was able to setup a logical standby database. The changes in primary get applied to standby without any issue. Both database are configured as logical standby databases in maximum performance mode.
After this, when I do a Switchover, switchover completes without any issue. Archived redo log files get transmitted to the old primary from the new primary. The only issue is, the redo logs do not get applied on the new standby(old primary). The status of coordinator is 'INITIALIZING' for several hours in the standby datbase. Did anyone run into this?

Have upgraded the database to 9.2.0.7. Any help will be really appreciated.

If anyone has sucessfully implemented switchover between logical standby datbases, please please post your initora file of both primary and standby. Also the steps if any different from the documentation.

Thanks for your help.
Priya

Re: Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover [message #155369 is a reply to message #155210] Sun, 15 January 2006 04:38 Go to previous messageGo to next message
waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia
Junior Member
Hi,


Did you put your database in the recovery mode. At standby database redo logs will be applied in the the recovery mode.

I did not understand what do you mean by the statement "The status of coordinator is 'INITIALIZING' for several hours in the standby datbase" ?

Re: Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover [message #155629 is a reply to message #155369] Tue, 17 January 2006 13:08 Go to previous messageGo to next message
npriya
Messages: 2
Registered: January 2006
Junior Member
This is a switchover between logical standby databases. I think you are talking about physical standby.

The status of logical standby database can be obtained from V$LOGSTDBY view. In my case, the coordinator process shows a status of 'INITIALIZING' indefinitely.

SQL> COLUMN STATUS FORMAT A50
SQL> COLUMN TYPE FORMAT A12
SQL> SELECT TYPE, HIGH_SCN, STATUS FROM V$LOGSTDBY;
TYPE HIGH_SCN STATUS
------------ ---------- --------------------------------------------------
COORDINATOR ORA-16117: processing
READER ORA-16127: stalled waiting for additional transact
ions to be applied

BUILDER 191896 ORA-16116: no work available
PREPARER 191902 ORA-16117: processing
ANALYZER 191820 ORA-16120: dependencies being computed for transac
tion at SCN 0x0000.0002ed4e

APPLIER 191209 ORA-16124: transaction 1 16 1598 is waiting on ano
ther transaction

APPLIER 191205 ORA-16116: no work available
APPLIER 191206 ORA-16124: transaction 1 5 1603 is waiting on anot
her transaction

APPLIER 191213 ORA-16117: processing
APPLIER 191212 ORA-16124: transaction 1 20 1601 is waiting on ano
ther transaction

APPLIER 191216 ORA-16124: transaction 1 4 1602 is waiting on anot
her transaction

Re: Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover [message #156807 is a reply to message #155210] Fri, 27 January 2006 23:43 Go to previous message
waseem_aijaz
Messages: 16
Registered: December 2005
Location: Kingdom of Saudi Arabia
Junior Member
For how much time it is in the state of "INITIALIZING" ?
Previous Topic: Problem in create tablespace statement ( logical standby database) 9i version 2
Next Topic: SWITCHOVER_STATUS value SESSIONS ACTIVE
Goto Forum:
  


Current Time: Thu Oct 22 17:59:30 CDT 2020