| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: STANDBY DB
Richard,
Okay, with more information, comes questions:
can you isolate the data you need in one or two tablespaces? I'm thinking that rather than clone the entire standby database (which is painful as you will be changing the database name)... maybe you could use transportable tablespaces to move the data you want from production to the second server (a new, 3rd database) and report on it there, then drop them when done.
This would give you a read/write database, and move the data from production more easily.
Hope this is more useful
Rachel
--- Richard Huntley <rhuntley_at_mindleaders.com> wrote:
> Hey Joe...this would need to happen on a recurring basis...maybe even
> nightly in order to offload some reporting. The thought is to get it
> done
> by scripting it and not having to suffer
> through transferring the files across the network every night after
> the hot
> backup runs on the primary DB. Otherwise, I'd definitely just clone
> it from
> the primary. If the reporting was doing only reads, I'd just try to
> talk
> Bob into allowing the standby to be open in read-only mode, but the
> reports
> actually do writes as well...
>
> -----Original Message-----
> Sent: Wednesday, October 03, 2001 5:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
>
>
> >>> rhuntley_at_mindleaders.com 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
> <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).
>
>
-- 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).Received on Wed Oct 03 2001 - 19:09:21 CDT
 |
 |