Re: Database Copy/Backup

Correction to my post.

Step 3 should be:

cp onefile /dir1 &; cp another /dir2 &; cp onemore /dir3 [optionally followed by &]

or if you like, run each cp command in a separate window.

Yong Huang
yong321_at_yahoo.com

In article <947uql$4q6$1_at_nnrp1.deja.com>,   yong321_at_yahoo.com wrote:
> 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

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 18 2001 - 22:59:18 CST