RE: standby

From: Klonicki, Stephen A <>
Date: Wed, 4 Feb 2009 11:52:24 -0500
Message-ID: <>

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: [] On Behalf Of Howard Latham Sent: Wednesday, February 04, 2009 11:41 AM To:
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

-- Received on Wed Feb 04 2009 - 10:52:24 CST

Original text of this message