RE: Transportable tablespace

What is referred to in that paper as being unsupported is because, as I recall (and I haven't read it in a while), they are using SRDF as well.

But for what you want to do, the second way I talked about (the standby that you open read-only) will work best for you -- you get to have a real backup server and have a reason for it so that management doesn't balk at the cost of having a machine "sit idle"

>From: Martin Kendall <Martin.Kendall_at_Rubus.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Transportable tablespace
>Date: Fri, 19 Jan 2001 01:40:37 -0800
>
>Hi Rachel,
>
>What do you mean by "the planned failover to a standby database is actually
>sanctioned by Oracle". I would like to use Lawrence's Graceful Failover
>method but
>the paper contains warnings about the method being unsupported.
>
>If you know of a new angle on this then do please let me know.
>
>-----Original Message-----
>Sent: 18 January 2001 19:29
>To: Multiple recipients of list ORACLE-L
>
>
>one last note... the planned failover to a standby database is actually
>sanctioned by Oracle -- there is a published paper by Lawrence To of the
>Center for Expertise called "Graceful Failover" or words to that effect
>that
>
>basically outlines this process.
>
>Read ANY paper you can find by Lawrence To. I was hoping to meet him at OOW
>(he's a friend of a friend) but he wasn't there... what he doesn't know
>about standby databases and backup/recovery is probably not worth knowing.
>
>
> >From: "Rachel Carmichael" <carmichr_at_hotmail.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Re: Transportable tablespace
> >Date: Thu, 18 Jan 2001 08:07:43 -0800
> >
> >Hot backup.... copy the backed up database files over, copy all the
> >archived log files over, apply the archived log files... just before you
> >want the sync point, do an "alter system archive log current" on the
> >production database. Copy any unapplied archived logs, as well as that
>one
> >you just created to the reporting db server. Apply those logs (recover
> >database using backup controlfile until cancel), once that last one is
> >applied, cancel the recovery and open database resetlogs.
> >
> >You can do the backup of the database and the copy whenever you want, and
> >just keep applying logs -- manual version of a standby database.
> >
> >
> >Actually -- you can do this using standby since you are on 8.1.6 --
>create
> >your standby database (the reporting one)... continue to apply archived
>log
>
> >files throughout the month. Again, just before you want to sync the
> >databases, do the alter system archive log current. Copy and apply that
> >one. Then open your standby database in read-only mode (your temporary
> >tablespace will have to be a locally managed tablespace because you can't
> >write to the temp tablespace in a read-only standby db since that updates
> >the data dictionary).
> >
> >Once you are done with the reporting, return the db to standby and
>continue
>
> >to apply archived logs throughout the next month.
> >
> >This means you only have to do the full db backup once (you can add new
> >datafiles to your standby when you add them to production). Added
>benefit,
> >you have a fairly up to date copy of production should your production
> >server fail.
> >
> >Two things at once.
> >
> >Woo hoo! I do love backup and recovery and the cool stuff you can do with
> >it!
> >
> >Rachel
> >
> >
> >>From: "DEMANCHE Luc (Cetelem)" <luc.demanche_at_cetelem.fr>
> >>Reply-To: ORACLE-L_at_fatcity.com
> >>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >>Subject: Transportable tablespace
> >>Date: Thu, 18 Jan 2001 02:52:24 -0800
> >>
> >>Hi DBAs,
> >>
> >>Oracle 8.1.6.2
> >>Sun solaris 2.6
> >>
> >>Every month (generally on the 15th) we have to duplicate our production
> >>DB on a production-reporting DB. It's not a replication case, it's a
> >>copy of one DB to another on a specific date. We did it using "insert
> >>as select" through a database link. We have to synchronize all changes
> >>(add new datafiles, create new tablespace, and so on) on the production
> >>DB to the production-reporting DB before the load. This requires a lot
> >>of time. And the load takes about 48 hours.
> >>
> >>I would like to use transportable tablespaces. I will transfer all my
> >>tablespaces (56 tablespaces) on my production-reporting DB.
> >>
> >>Does someone have a other ideas? Or a bad history about transportable
> >>tablespaces.
> >>I could do a cold backup, transfer the backup to a production-reporting
> >>disk and recreate the control file to change the DB name.
> >>
> >>What is the better solution?
> >>
> >>TIA
> >>
> >>
> >>-----------------
> >>Luc Demanche
> >>CETELEM
> >>Tél.: 01-46-39-14-49
> >>Fax : 01-46-39-59-88
> >>
> >
> >_________________________________________________________________
> >Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Rachel Carmichael
> > INET: carmichr_at_hotmail.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).
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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: Martin Kendall
> INET: Martin.Kendall_at_Rubus.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 Fri Jan 19 2001 - 10:07:34 CST