Re: Question regarding Oracle backup

Tony wrote:
> All this works fine if the
> production database is down when I recreate the test databases' control
> file. If however the production database is up at the time I get an
> error saying that a datafile is in use.
>
> Does anybody know why this happens and if so whats a good work around ?
> Does anybody know of a quick way to take a backup of one database and
> restore it into another database

Well, you didn't specify if you were also changing the SID of the database when you recreate the control file. Check you environment variables as you could be trying to attach to the other SGA/control file. I've never had a problem when my environment is setup correctly.

For copying a database from one location to another you can use the 'dd' command on UNIX and there are other commands depending on what platform you're on to copy the datafiles parallel to the new location. However, you must put the tablespace containing the datafiles in backup mode prior to the copy. You can evern change the SID and apply archive logs from another DB to restore the hot backed/copied database.

Hope this helps,
Marc

-- 
||----------------------------------------------------------------------||
|| Marc Marchioli
|| The DataBase Group, Inc.                       voice:  214-528-9459
|| 4011 Travis St.                                fax:    214-528-9459
|| Dallas, TX 75204-7512
|| marcm_at_computek.net                         @
|| (Challenging ORACLE and UNIX every day)    |-}ORACLE,UNIX
||                                            /\-------------->