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 [EMAIL PROTECTED]
-----Original Message----- From: Edouard Dormidontov [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
