Re: STANDBY DB

[JOE TESTA]

yeppers, you'll need to do the name conversion since you want to have a 2nd db on the same server.  Now if the purpose here is to open the database and not really use it as a standby database, then why go thru the standby shuffle.  move it to the other server(the cold backup), take a dump of the control file to trace(from the original) and then edit that trace file for where you want the new files to be located, run it and open it as a "clone" of production, since my impression is thats really what you're doing anyways.  If you go thru the shuffle of a standby database creation and open it for read-write, it becomes useless anyways for the "real" primary.   you can't switch and forth until 9i between primary and standby.   Rich, you know how to get ahold of me ;)   joe >>> [EMAIL PROTECTED] 10/03/01 04:40PM >>> Any info. would be appreciated! What I'm trying to do is, I have a primary DB on server1, a standby DB on server2 and I want to create a 3rd DB on server2 from a consistent (cold) backup of the standby DB and then activate the 3rd DB. So, I'd end up with on server1 the primary DB and on server2 the standby DB "mounted" along with the 3rd DB that I'd activate and open for use.  Just trying to see if this will work.  Has anyone tried this and if so would the following init parameters help at all: DB_FILE_NAME_CONVERT, LOG_FILE_NAME_CONVERT and LOCK_NAME_SPACE??? TIA, Rich   -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley   INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).