Re: standby
From: David Ballester <ballester.david_at_gmail.com>
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.?
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.?
?
primary:
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
HTH D.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2009 - 12:31:10 CST