flashback
-
编辑 删除
flashback和controlfile
If a data file has changed status between the current SCN and the target SCN of the flashback, then the FLASHBACK DATABASE command behaves differently depending on the nature of the status change.今天跟群里的人讨论flashback，发现flashback之后，如果想回到当前状态，那么用flashback会比recover更方便我...
-
编辑 删除
flashback恢复特定数据文件
今天看见群里讨论flashback，我在虚机上尝试了一下。先做了如下操作：点击(此处)折叠或打开SQL> create restore point p1;Restore point created.SQL> create tablespace flash datafile \'/u01/app/oracle/oradata/gg1/flash01.dbf\' size 8m;...
