| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: efficient way to duplicate db on another unix host?
Assuming a reasonable network pipe between the 2 machines, a redirected backup (hot or cold) would be faster. Here the datafiles are written directly to the target system instead of local disk or tape.
In Dan's example the recovery & resetlogs would not be necessary (unless you're also changing the SID). And if the mount points are identical, no renaming files.
Mike Hand
Polaroid Corp.
-----Original Message-----
Sent: Friday, July 26, 2002 11:03 AM
To: Multiple recipients of list ORACLE-L
Perform a cold backup, copy all the files to the new host, startup mount, rename the files, recover db, open resetlogs. This can also be done with a hot backup and the archived redo logs. The advantage of this method is that you are testing your backup method.
I have some instructions (a little old, but still usable) on my website at
www.optimaldba.com
Dan Fink
-----Original Message-----
Sent: Friday, July 26, 2002 7:19 AM
To: Multiple recipients of list ORACLE-L
Hi Oracle gurus:
What is, in your opinion, the fastest way to duplicate a database on a another unix host?
Thanks,
Carmen Rusu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Carmen Rusu
INET: carmen.rusu_at_rrc.state.tx.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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 Fri Jul 26 2002 - 10:48:23 CDT
 |
 |