Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Dataguard - create standby control file on same host

Dataguard - create standby control file on same host

From: orcl <orcl_at_comcast.net>
Date: Sun, 05 Feb 2006 21:54:14 -0500
Message-ID: <43E6BA56.4070808@comcast.net>


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-l
Received on Sun Feb 05 2006 - 20:54:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US