Oracle-L: RE: Duplicate online Database

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Tue, 04 Mar 2003 04:34:07 -0800
Message-ID: <F001.0055F575.20030304043407@fatcity.com>

Ofer,

Are you suggesting that it is OK to copy an open database without using hot backup mode, as long as there isn't a log switch during copy?

Do you use this method at your place of employment?

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Tue, 4 Mar 2003, Ofer Harel wrote:



> if the database is not heavy updateable, i.e., the switching of redo log is

> rare, and the database is not too large, you can try this scenario:

> 1. copy (operation system) all the datafiles, redo log, etc..

>     you need to copied the hall database without a redo log switch in the

> middle.

> 2. Act with those files as its a hot backup

> 3. Recover the database using a 'backup controlfile to trace'

> 4. It work to me

>  

> if you need more, email

> 

> -----Original Message-----

> I need to duplicate online database Oracle 8.1.7.

> It is not possible to shutdown the primary database.

> Can I do online backup this primary database by RMAN,

> and + using archivelogs create duplicate database?

> Inconsistent backups of RMAN + archivelogs = duplicate database??


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Tue Mar 04 2003 - 06:34:07 CST