DB clone question
Hi All - I have a small dilemma that I'm not sure how to address...
I have a request to clone a db from prod to dev - easy enough with rman duplicate db... These are on separate hosts as well...
But, our daily rman incremental backups run at 3am and the developers need a copy of prod as of 9am the next day. And they want the dev instance to be available as close to 9am as possible...
So - I can clone a db no problem anytime up to the backup, but how do I get the additional transactions from the ensuing 6 hours into the dev instance?
Thanks... I've been looking into this for the last couple days and the additional transactions after the rman backup seems to be the problem.
you apply the archive logs from production
There is NOTHING I can think of that justifies the developers have daily updated data, unless this clone is actually a "reporting" database and not a Dev/Qa database.
Originally Posted by newdbasarah
1) Instead of cloning from a physical backup, you could clone using DUPLICATE over a network link.
2) Or create logical standby.
3) Or Create zero-data reporting database.
Originally Posted by LKBrwn_DBA
This full refresh of the "development" database will kill all possible changes on backend code, new database objects as well as any changes to database objects. I do not think development team is re-applying all changes in a daily basis.