FreeLists / oracle-l / RE: standby controlfile

["Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>]

Hmm....just from a common sense point of view, I'm thinking the answer
is no, cause you want a standby controlfile that's specific to a
particular (primary) database.  What good would it do to explicitly
create a standby controlfile arbitrarily, that doesn't have any tie to a
primary database?  (Can you even call it a standby control file if it's
not specifically tied to a primary database?  I'm thinking no.)
 
So, I have to ask, why do you want to do this?
 
-Mark
 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest/CSA 

"There are 10 types of people in the world:  Those who understand
binary, and those who don't." 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of sol beach
Sent: Friday, March 02, 2007 1:23 PM
To: Oracle-L Freelists
Subject: standby controlfile


I know I can create a standby controlfile by the following:
ALTER DATABASE CREATE STANDBY CONTROLFILE;
Is there any way to use
CREATE CONTROLFILE ......
command to create a STANDBY CONTROLFILE?
I have been unable to find the necessary syntax in the Fine SQL
Reference Manual 

TIA!

BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD