Hi everybody,
I´m using Oracle flashback based on guaranteed restore points on my Oracle 12c Windows Server system. What I try to achieve using that is an uncomplicated way to restore database-snapshots for performance testing. I´ve created a couple of guaranteed restore points and want to drop them right now to get a clean database. Here´s what happens:
1. I connect using RMAN and get a list of all restore points using RMAN> list restore point all;
2. RMAN gives me one guaranteed restore point (I already deleted all the others and I´m ONLY using guaranteed restore points) named restore CLEAN_INSTALL_PRELOAD.
3. Now I try to drop this restore point using RMAN> DROP RESTORE POINT CLEAN_INSTALL_PRELOAD; and even though RMAN listed this point before and the flashback logs are all in the recovery area, the system tells me:
ORA-38780: Restore point 'CLEAN_INSTALL_PRELOAD' does not exist.
I´ve already tried switching flashback on / off, but it didn´t help. Does anyone have any ideas, because the guaranteed restore point stops me from working (can´t drop tablespaces and so on...).
Thanks in advance,
Patrick