Originally posted by gopi
Julian...I need to purchase the Veritas MML Oracle extension in order to use rman to backup to tape (not enought disk) - my management has been warned many times. Once I have rman backups I can duplicate. thanx
You can use disk backups for cloning. No need for MML in order to run the duplicate command :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
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.
Oracle it's not just a database it's a lifestyle!
-------------- BTW....You need to get a girlfriend who's last name isn't .jpg