Great video! Most video's on flashback misses all the great insight and practical application you shared. Question: If you're backing up your archivelogs, would you then have to first restore the archived redo logs around the time of your flashback objective before you initiate the flash command? If yes... Does flashback work with RMAN so that RMAN will automatically restore the archived redo logs needed to complete the flashback?
That's the amazing feature, thanks much for detailing it.
Great video! Most video's on flashback misses all the great insight and practical application you shared.
Question: If you're backing up your archivelogs, would you then have to first restore the archived redo logs around the time of your flashback objective before you initiate the flash command? If yes... Does flashback work with RMAN so that RMAN will automatically restore the archived redo logs needed to complete the flashback?
I think you need to go and get those logs yourself (but I can't be certain)
Flashback Schema would be a very very good thing in s shared / consolidated Environment.
Any clever idea how to create GRP via procedure, so DEVs can take control over this?
Create a proc as SYS (or similarly privileged user) and then grant that to users that are allowed to create a restore point.