RE: STANDBY DB

From: Kevin Lange <kgel_at_ppoone.com>
Date: Wed, 03 Oct 2001 13:48:27 -0700
Message-ID: <F001.003A1148.20011003132540@fatcity.com>

We often copy our Production DBs to either make Test Dbs or to rebuild Standbys by simply copying the files from our production (we use Netapp so we can copy them from the snapshot while production is still running) , bring the DB up unmounted, recreate the control file using a different name for the db, make sure the init file has the correct DB_NAME, then open up the database while resetting the logs.

I don't think you should have too much trouble.

-----Original Message-----
Sent: Wednesday, October 03, 2001 3:58 PM To: Multiple recipients of list ORACLE-L

what version of Oracle? in 8 you can open the standby read-only and turn it back into a standby when you are done.

• Richard Huntley <rhuntley_at_mindleaders.com> wrote:
  > 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: rhuntley_at_mindleaders.com
  >
  > 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: ListGuru_at_fatcity.com (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).
  

  ---

Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

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: ListGuru_at_fatcity.com (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: kgel_at_ppoone.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Oct 03 2001 - 15:48:27 CDT