Re: Copy data from live database to test database

From: <cmohan_at_iname.com>
Date: 1998/06/01
Message-ID: <6kv09u$pdp$1_at_nnrp1.dejanews.com>#1/1


This may sound like an overkill, but it is a good option. Run the live database in archivelog mode. Restore the backup files of the live database to create the test database. Then keep applying the archived redo logs at your own pace. (Something like a hot standby!).

HTH,
CM

In article <6kq5ng$88q$1_at_tor-nn1.netcom.ca>,   "Dave S" <DS_at_nospam.com> wrote:
>
> Hi,
>
> This may not be the most eligent method but, I create a script that:
>
> 1) drops the test instance (and files)
> 2) rebuilds the instance (and tablespaces)
> 3) imports the most current export of the live.
>
> If the database is large, this might take a while but if it's not so big,
> this and option.
>
> Dave S.
>
> >>We have wo databases, one for LIVE transactions and the other for
> >>testing/training, hence called TEST.
> >>
> >>I would like produce a script for updating the TEST database with all the
> >>transactions currently in the LIVE database.
>
> <<<< SNIP>>>>
>
> >Thanks
> >
> >Umesh Jagannatha
> >umesh_at_esystem.com
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 01 1998 - 00:00:00 CEST

Original text of this message