数据文件已备份。

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>