| What is the best restore scenario [message #466097] |
Fri, 16 July 2010 19:36  |
divacvl
Messages: 4
Registered: July 2010
|
Junior Member |
|
|
Dear experts,
I am in charge for maintaining an application which utilize Oracle 10g database in background.
Full online backup of DB is scheduled every night 00:45. This is working OK and we have backups from last 7 days available.
Yesterday one user accidentally dropped one important table (with completely static content) at 10AM.
Database is productional only during working hours (9-17) and outside this period can be offline as long as it needs for maintainance (in this case restore) purposes.
What I would like to achieve is to restore dropped table content from backup, but also not to loose changes today from 10-17h (unfortunately there were some huge insertions today after 10).
My idea is to make full offline backup outside office hours, then perform incomplete restore (until 10AM yesterday, while the table was still there), then export that table (with exp tool), then perform restore from offline backup to restore current state and then import dropped table (with imp).
Is this conceptually OK? (I will search myself for the exact RMAN commands later)
Is there some better way to accomplish what I want?
Once again, downtime is not an issue.
Vladan
|
|
|
|
|
|
|
|
| Re: What is the best restore scenario [message #467080 is a reply to message #466117] |
Thu, 22 July 2010 04:09  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Michel & BS: I did not see the topic owner said about FlashBack in his database?
Sometime, in my Prod DB, I've got an accident like, however, I choose the way to restore all database in another server, of course, restore point-in-time. But, the other server is Auxiliary DB, so that, I've never wondered about the data in its. Drop, Truncate table, Import/Export Stats, Analyze, Rebuild DB in test case, ... About 2TB using ASM, it take 2 hours to restore/recovery in AuxDB. After Restore, I import the lost table from AuxDB into ProdDB, of course, check any-trigger afford to it. Still now, 5 accidents I solved by using this way. It's the good way?
Thank you!
|
|
|
|
|
|
|
|
|
|
| Re: What is the best restore scenario [message #467550 is a reply to message #467543] |
Sun, 25 July 2010 17:46 |
divacvl
Messages: 4
Registered: July 2010
|
Junior Member |
|
|
Hi,
Sorry for not having the time to post you the results.
I performed restore on 18th July with the scenario I initially described, and everything went fine, dropped content now available and after-drop changes preserved.
Unfortunately, it turned out that I could have done it much more elegantly, since RECYCLEBIN parameter was set to TRUE by default.
I wasn't aware of this FLASHBACK feature, and I overlooked BlackSwan entry, since I thought this is some advanced/optional feature, and I didn't have the time at the time to read more about it.
I tested it later with creating some dummy table, dropping it and restoring it with FLASHBACK, and it is working instantaneously like a charm.
I could have spent 4 hours of my life much better.
I also find this link useful discussing similar scenarios:
h**p://arjudba.blogspot.com/2008/05/recover-from-drop-or-delete-or-truncate.html
Problem solved. Thank you all.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
