Re: standby

From: David Ballester <>
Date: Wed, 04 Feb 2009 19:31:10 +0100
Message-Id: <1233772270.30190.13.camel_at_nebuchaddnezzar>

El mié, 04-02-2009 a las 16:51 +0000, Howard Latham escribió:
> Thanks - That only works if the files are in the same place on the
> primary database. What if the layout if different.?



alter database create standby controlfile as '/path/stb.ctl'; scp /path/stb.ctl to standby host

standby host

be sure to have the file name convert,log name convert and control_file parameters in your database parameter file, pointing to the new locations

sql>startup nomount
rman>restore controlfile from stb.ctl
sql>alter database mount standby database; sql>alter database recover managed standby database disconnect from session;

coffee while data guard synchronizes


Received on Wed Feb 04 2009 - 12:31:10 CST

Original text of this message