Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Dataguard - create standby control file on same host
All
Here is my situation - winxp pro, oracle 10.2,
Goal: set up dataguard on a laptop for demo purposes, Primary files are on C:\... standby are on E:\...
actual db name = RECO, unique_primary_name=primRECO unique_standby_name=stbyRECO
I create the init.ora file with filename / log name convert, set up different DB_UNIQUE names, create service for the standby,
create standby control file '\....\....'; shutdown primary, copy all database files to E:\...
startup the primary, a everything is ok
startup mount pfile=.... the standby mounts, i place in managed recovery mode - no errors, then go to the primary and do archive log list, and get "online redo is not consistent with #...."
so the problem seems the standby control file is pointing to C:\.... and by starting the standby in managed recovery its corrupting the online redo log on the primary.
the question is how to create a control file for a standby on the same host (sorry if this was too long winded)
thanks
bob
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 05 2006 - 20:54:14 CST
![]() |
![]() |