RE: Duplicate online Database

Unfortunately I found one of my database need a recovery back on time without a legal backup. There where only the disks backup. So I tried, I had nothing to lose.
And it worked. Not documented, not recommended, but it worked. Of course, now this database is backup :)

Ofer

-----Original Message-----
Sent: Tuesday, March 04, 2003 2:34 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ofer Harel
  INET: oharel_at_barak013.net.il

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