Dataguard - create standby control file on same host
- From: orcl <orcl@xxxxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 05 Feb 2006 21:54:14 -0500
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
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)
Other related posts: