Re: Refreshing data in a TEST instance.

Hello,

You can restore all LIVE's backup files to TEST's directories, including controlfiles,
rename datafiles/logfiles in the controlfile, rename the database, and run the rollforward if you did a hot backup of LIVE. Then open the database, you will need to reset the redo logs (RESETLOGS).

You may also consider import/export or replication, if appropriate.

Regards,
Karen

Nick wrote:

> Hello all.
>
> Currently we have two instances - LIVE and TEST (Oracle 7.3.4 / NT 4.0).
>
> Could anyone tell me how to refresh the data in the TEST environment (which
> is 3 months old) with the LIVE data?
>
> We back up to tapes and .dmp file every night.
>
> Many thanks and regards to anyone who can help,
>
> Nick.
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Wed Jul 12 2000 - 00:00:00 CDT