Re: Database Copy/Backup

From: <yong321_at_yahoo.com>
Date: Thu, 18 Jan 2001 23:39:01 GMT
Message-ID: <947uql$4q6$1@nnrp1.deja.com>

You don't want to export and import. Just clone it. But if you want a shorter downtime, you can try:

0. Consider alter database datafile resize to shrink some "fat" out, even just for the purpose of this cloning 1. Shutdown normal
2. Copy all files to another location on the SAME server, assuming you have enough disk space
3. In doing so, make sure you run several copy processes (cp onefile /dir1; cp another /dir2; cp onemore /dir3 and these files and dirs have to be on different disks)
4. Start your production database

These are all the tips I can think of.

Yong Huang
yong321_at_yahoo.com

In article <947trd$3sa$1_at_nnrp1.deja.com>, erwinrm_at_geocities.com wrote:
> What's the quickest way to make a copy an Oracle 8.1.6 database that's
> about 65GB? The database is running on Solaris 2.6 in a Sun
Enterprise
> server. The copy is to be a development database in another Sun box.
>
> Ftp'ing the files takes about 1GB/minute, which makes downtime over an
> hour. Exp/imp runs up to 12 hours. Any other ways to go about this?
> tools?
>
> Tia,
> Erwin

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 18 2001 - 17:39:01 CST