RE: Transportable Tablespaces

Michelle:

   I think that the Hot backup idea won't work, because putting a tablespace in hot backup mode does not prevent DBW0 from writting to the datafiles blocks (I think that that's what you need).

   During a Hot backup, DBW0 continues modifing the datafile blocks and these modifications (with some more block images) are logged in the redo log files and archived later.

   That's why the archiving files generated during a Hot backup are so important . They're needed to reconstruct split reads (or inconsistent blocks) that were read by the OS utility during the backup stage.

HTH
Diego Cutrone

• Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 07, 2002 3:28 PM

> Hi all,
>
> I would like to use transportable tablespaces to refresh a selected
tablespaces from a production environment. The problem is that I cannot put the production tablespaces into read-only mode. Has anyone tried putting the tablespaces in hot backup mode then exporting, copying datafiles?
>
> One schema is currently being refreshed from the production environment
using exp/imp method but it is taking too long. I am also considering a clone from a hot backup and dropping the tablespaces not needed for refresh.
>
> Any other ideas/suggestions are appreciated.
>
> TIA,
> Michele Armstrong
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Marmdba_at_aol.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: Diego Cutrone
  INET: dcutrone_at_afip.gov.ar

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).