Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
We need to restore a database but only the last three months of data.
We need to restore a database from a production rman level-0 backup to a test instance but for only the last three months of data.
Is it possible to restore only November-January?
Best Answer
-
You can refer below document:
https://blog.pythian.com/how-to-recover-a-subset-of-an-oracle-database/
Regards,
Adi
Answers
-
No. RMAN performs a block based, binary binary backup of data, and cannot purge or omit data that existed before a level 0 backup.
-
This is my understanding as well. I was hoping for verification one way or the other.
Thank you for your response.
-
Depends on how you have organized that data in the database. For example if you have partitioned tables with monthly partitioned data into separate tablespaces for each month you can restore a subset of the database to another server including only the tablespaces of interest (system, sysaux and undo must be included).
AJ
-
That is an excellent point. And yes, we do have the tables partitioned by date range. I'm certain that all partitions are monthly, but some table partitions may be in shared tablespaces.
Thank you for this insight!
-
You can refer below document:
https://blog.pythian.com/how-to-recover-a-subset-of-an-oracle-database/
Regards,
Adi
-
Nice doc reference. This is exactly what I was hoping for:)
-
What constitutes "last three months of data"? Only rows that have been inserted/updated in the last three months? How would you identify them? What about static look-up tables that rarely get updated but are critical to the operation of your application? Technique aside, it seems to me that you have not thought through the requirements very well.
-
First of all, they were not my requirements. I was simply attempting to come up with some ideas for something that was requested by management.
As it turns out, AJ and Adityanth had no problem understanding the gist of my query.
Thanks again to AJ and Adityanth for your insightful ideas and suggestions.
-
RMAN can restore tablespaces and also skip tablespaces, but cannot extract only the past 3 month of data. If you have monthly tablespaces that's a different question and retrofitting the scenario.
