RE: Duplicate online Database

Dangerous advice !

If the database IS already in ARCHIVELOG mode, why not use RMAN or put all the Tablespaces in BACKUP mode before copying the files [there would be very little cost associated with this if the database is "not heavy updateable"]

Hemant

At 03:54 AM 04-03-03 -0800, you wrote:
>Edouard hello,
>
>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
>
>
>regards
>Ofer Harel
>DBA team
>Barak ITC
>oharel_at_barak013.net.il
>
>-----Original Message-----
>From: Edouard Dormidontov [mailto:dg_at_servocomp.ru]
>Sent: Tuesday, March 04, 2003 12:39 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Duplicate online Database
>
>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??
>
>Thanks
>Edouard Dormidontov

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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