oracle中闪回数据库到还原点的操作
CREATE RESTORE POINT before_clean GUARANTEE FLASHBACK DATABASE;
==>必须保证闪回回复区flashback recovery area有足够的磁盘空间
在standby 上， 注意 操作之前要记得 关闭redo传输
alter database recover managed standby database finish force;
alter database open;
操作
shutdown immediate;
startup mount;
flashback database to RESTORE POINT before_clean;
Leave a Reply