flashback恢复特定数据文件

今天看见群里讨论flashback，我在虚机上尝试了一下。
先做了如下操作：

点击(此处)折叠或打开

1. SQL> create restore point p1;
3. Restore point created.
5. SQL> create tablespace flash datafile \'/u01/app/oracle/oradata/gg1/flash01.dbf\' size 8m;
7. Tablespace created.
9. SQL> grant connect,resource to flash identified by flash;
11. Grant succeeded.
13. SQL> create table flash.emp as select * from scott.emp;
15. Table created.
17. SQL> create restore point p2;
19. Restore point created.
21. SQL> truncate table flash.emp;
23. Table truncated.
25. SQL> create restore point p3;
27. Restore point created.

之后在操作系统上删除/u01/app/oracle/oradata/gg1/flash01.dbf这个新增的文件

然后开始闪回

点击(此处)折叠或打开

1. SQL> shutdown immediate
2. Database closed.
3. Database dismounted.
4. ORACLE instance shut down.
5. SQL> startup mount
6. ORACLE instance started.
8. Total System Global Area 661209088 bytes
9. Fixed Size 1338560 bytes
10. Variable Size 423625536 bytes
11. Database Buffers 230686720 bytes
12. Redo Buffers 5558272 bytes
14. Database mounted.
15. SQL>
17. SQL> flashback database to restore point p3;
19. Flashback complete.

在告警日志中发现如下信息：

点击(此处)折叠或打开

1. Mon Mar 09 21:41:08 2015
2. flashback database to restore point p3
3. Mon Mar 09 21:41:08 2015
4. Errors in file /u01/app/oracle/diag/rdbms/gg1/gg1/trace/gg1_dbw0_7668.trc:
5. ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
6. ORA-01110: data file 7: \'/u01/app/oracle/oradata/gg1/flash01.dbf\'
7. ORA-27037: unable to obtain file status
8. Linux Error: 2: No such file or directory
9. Additional information: 3
10. Flashback Restore Start
11. Deleted file /u01/app/oracle/oradata/gg1/flash01.dbf
12. Flashback: deleted datafile #7 in tablespace #7 from control file.
13. Flashback: dropped tablespace #7: \'FLASH\' from the control file.
14. Flashback Restore Complete
15. Flashback Media Recovery Start
16. Serial Media Recovery started

可见flashback，自动的帮助我们restore了datafile，真是意想不到啊。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30202921/viewspace-1684288/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30202921/viewspace-1684288/