数据文件已备份。
基于SCN的恢复
原创
©著作权归作者所有:来自51CTO博客作者jsj_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
SQL> select * from ttest;
ID
----------
4
3
2
1
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
1183565
SQL> drop table ttest;
Table dropped.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1241513984 bytes
Fixed Size 1219136 bytes
Variable Size 318768576 bytes
Database Buffers 905969664 bytes
Redo Buffers 15556608 bytes
Database mounted.
SQL> ho cp -f /home/oracle/backup/* /opt/app/oracle/oradata/orcl/ ;
SQL> select file#,change# from v$recover_file;
FILE# CHANGE#
---------- ----------
1 1183451
2 1183451
3 1183451
4 1183451
5 1183451
6 1183451
6 rows selected.
SQL> recover database until change 1183565;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select * from ttest;
ID
----------
4
3
2
1
SQL>
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章