Quote:
Originally posted by OracleDoc
*tap tap is this thing on?
you could do what we did at my last gig.
simply take a hot backup of the standby. ftp the datafiles over to your dev. Rename the database, startup using an edited controlfile from prod. Rinse and repeat as neccessary.
We did this on a nightly basis, we had a Reporting database that users could run thier reports off of instead of having to use prod.
It's particularly sweet if you're in an unsecure environment and have rsh available to use. If not use the ssh, A couple of scripts and voila` you've got yourself a nightly refresh job.
\