RE: standby
Date: Wed, 4 Feb 2009 11:52:24 -0500
Message-ID: <D00A9309AEEDEC4387F2751F859B210104AFF2F029_at_us194mx002.tycoelectronics.net>
Build a new standby controlfile from the production database.
From production.
alter database create standby controlfile as 'xxxx';
I use standby.ctl for xxxx.
Shutdown your standby database.
Copy standby.ctl from production to appropriate control file locations on your standby.
Restart your standby database.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham
Sent: Wednesday, February 04, 2009 11:41 AM
To: oracle-l_at_freelists.org
Subject: standby
Oracle 11g
Redhat Linux,
We lost the controlfile from a standby its not THAT important but whats the simplest way to rebuild it?
We can backup the primary control file to trace;
--
Howard A. Latham
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 04 2009 - 10:52:24 CST