Option 1. DB_FILE_NAME_CONVERT: Syntax: DB_FILE_NAME_CONVERT: = 'oldstring1', 'newstring1', 'oldstring2', 'newstring2', ... Specify the location of the primary database datafiles followed by the standby location of the datafiles. It will convert datafile name of primary database to datafile name of the standby datafile. If the primary and standby database are on the same system or if the directory structure of primary and standby database is different then this parameter is required. Option 2. Rename the database on the standby while it is in MOUNT mode. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of SHEEHAN, JEREMY Sent: Wednesday, February 04, 2009 11:56 AM To: Howard Latham Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: standby That's a good question.... I've never had to do that before. All my standby db's were in the same format as my prod. I did a quick check on google, but couldn't find anything relevant... Sorry! Jeremy P Consider the environment. Please don't print this e-mail unless you really need to. -----Original Message----- From: Howard Latham [mailto:howard.latham@xxxxxxxxx] Sent: Wednesday, February 04, 2009 11:52 AM To: SHEEHAN, JEREMY Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: standby Thanks - That only works if the files are in the same place on the primary database. What if the layout if different.? 2009/2/4 SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx>: > Google = Good > > http://www.tiplib.com/138/create-standby-controlfile > > Jeremy > P Consider the environment. Please don't print this e-mail unless you really > need to. > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Howard Latham > Sent: Wednesday, February 04, 2009 11:41 AM > To: oracle-l@xxxxxxxxxxxxx > 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 > -- > //www.freelists.org/webpage/oracle-l > > > > > -- Howard A. Latham m ?p l ? j ??i??0龙?zX?妒+??n??{?+i?^