| Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover [message #155210] |
Thu, 12 January 2006 17:06  |
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 #155629 is a reply to message #155369] |
Tue, 17 January 2006 13:08  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
