Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Duplicate online Database

RE: Duplicate online Database

From: Ofer Harel <oharel_at_barak013.net.il>
Date: Tue, 04 Mar 2003 04:58:51 -0800
Message-ID: <F001.0055F5C4.20030304045851@fatcity.com>


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).
Received on Tue Mar 04 2003 - 06:58:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US