- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.2K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
RMAN Database Clone Option to clone a DB using Incremental backup
Using RMAN if we can have an feature where in we can clone a Dev/test instance from say Production once a month and then on dev instance we have this option on database:
Alter database keep snapshot for clone; -- the command keeps the SCN and data to that point as reference. It prepares the DB for a possible flashback to this state in future ( like a checkpoint)
Post this instance is widely used as Dev instance.
Later say after n days we bring an Incremental Backup from Source and want to clone it.
Hence we would inform database to flashback or return to check point stated earlier and then once recovered to that point we use incremental backup to apply latest data to dev and restore it to new dev instance.
This option could heavily/widely reduce the time taken to clone Dev/Test databases where DB sizes are huge and data changes are also huge.