数据文件、控制文件已做备份

SQL> select * from ttest;
 
        ID
----------
         4
         3
         2
         1
         5
 
SQL> drop tablespace crm001 including contents;
 
Tablespace dropped.
 
SQL> shutdown immediate;
 
Database closed.
Database dismounted.
ORACLE instance shut down.
 
SQL> ! tail -200 /opt/app/oracle/admin/orcl/bdump/alert_orcl.log
Wed Aug 29 23:13:39 2012
drop tablespace crm001 including contents
Wed Aug 29 23:13:39 2012
Completed: drop tablespace crm001 including contents
….
SQL> ho ho cp -f /home/oracle/backup/* /opt/app/oracle/oradata/orcl/ ;
/bin/bash: ho: command not found
 
SQL> ho cp -f /home/oracle/backup/* /opt/app/oracle/oradata/orcl/ ;
 
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> recover database until time '2012-08-29 23:13:39' using backup controlfile;
ORA-00279: change 1185118 generated at 08/29/2012 23:08:56 needed for thread 1
ORA-00289: suggestion :
/opt/app/oracle/flash_recovery_area/ORCL/archivelog/2012_08_29/o1_mf_1_1_%u_.arc
ORA-00280: change 1185118 for thread 1 is in sequence #1
 
 
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/opt/app/oracle/flash_recovery_area/ORCL/archivelog/2012_08_29/o1_mf_1_1_%u_.ar
c'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
 
 
ORA-00308: cannot open archived log
'/opt/app/oracle/flash_recovery_area/ORCL/archivelog/2012_08_29/o1_mf_1_1_%u_.ar
c'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
 
SQL> alter database open resetlogs;
 
Database altered.
 
SQL> select * from ttest;
 
        ID
----------
         4
         3
         2
         1
         5