| Flashback database question [message #448463] |
Tue, 23 March 2010 10:28  |
finkus55
Messages: 3
Registered: March 2010
|
Junior Member |
|
|
Hi All,
I am new to the forum and had a general question about the FLASHBACK DATABASE feature. When you use the FLASHBACK DATABASE command, does it generate redo?
For example, lets say you do the following:
1) Take a backup of tablespace TEST
2) Update some data in the tablespace TEST
3) FLASHBACK DATABASE to some point before step #2
4) Instance failure
At this point I want complete recovery, so I restore the original backup in step 1 and begin recovery rolling forward using my archived and online redo logs. I am assuming that within these logs something is written about the blocks that were changed in the FLASHBACK DATABASE? Hopefully this was a clear example....
Thanks for helping me understand this point!
Chris
|
|
|
|
|
|
| Re: Flashback database question [message #448489 is a reply to message #448463] |
Tue, 23 March 2010 12:34  |
finkus55
Messages: 3
Registered: March 2010
|
Junior Member |
|
|
Hi Michel,
Thank you for the reply. I am still a bit confused and maybe it was because my scenario was a little bit off. Let's try this....
1) Take a backup of tablespace HR
2) Update some data in the EMPLOYEES table
3) FLASHBACK DATABASE to some point before step #2.
4) Update some data in the SALARY table
5) Datafile corruption for tablespace HR, need to perform restore/recovery.
So after step 5 I restore the backup from Step 1 and perform recovery. How does Oracle know to not apply the redo generated by step 2 and only apply the redo from step 4, it would have to somehow know that a flashback database occurred and the redo from step 2 is no longer valid, no?
Chris
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
