Re: Database Copy/Backup

From: Dan <no_at_home.com>
Date: Fri, 19 Jan 2001 05:07:49 GMT
Message-ID: <FYP96.171$t5.36631@news1.frmt1.sfba.home.com>

If downtime is an issue, you can copy the datafiles over to the development box while your production database is up and running. I assume you're database is in archivelog mode since it is a production database. Follow steps similar to this.

0. Perform archive log list to determine current archive
1. Place the tablespace in backup mode (alter tablespace begin backup)
2. ftp the datafile you that you have placed in backup mode over to the

development box
3. Take the tablespace out of backup mode. (alter tablespace end backup) 4. Repeat steps 1-3 until you have copied all the datafiles over to the development box

5. Take a backup of the controlfile and ftp it over to the development box.
6. perform archive log list to determine current archive
7. FTP the archive logs that was generated during the cloning process
8. Recover your database using backup controlfile until cancel.

It would be ideal to perform this when transaction volume is minimal.

Dan
<erwinrm_at_geocities.com> wrote in message news:947trd$3sa$1_at_nnrp1.deja.com...
> 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 - 23:07:49 CST