从另外一台机COPY过来的控制文件，数据文件，日志文件恢复到本机上并在本机恢复.

SQL> STARTUP NOMOUNT

SQL> CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS  NOARCHIVELOG
--  SET STANDBY TO MAXIMIZE PERFORMANCE
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 113
LOGFILE
  GROUP 1 'D:\oracle\oradata\orcl\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\oracle\oradata\orcl\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\oracle\oradata\orcl\REDO03.LOG'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  'D:\oracle\oradata\orcl\SYSTEM01.DBF',
  'D:\oracle\oradata\orcl\UNDOTBS01.DBF',
  'D:\oracle\oradata\orcl\EXAMPLE01.DBF',
  'D:\oracle\oradata\orcl\INDX01.DBF',
  'D:\oracle\oradata\orcl\USERS01.DBF',
--  'D:\oracle\oradata\orcl\TEMP01.DBF',
  'D:\oracle\oradata\orcl\SRMS.DBF',
  'D:\oracle\oradata\orcl\APMS.DBF',
  'D:\oracle\oradata\orcl\RMAN_TS.DBF',
  'D:\oracle\oradata\orcl\TOOLS01.DBF',
  'D:\oracle\oradata\orcl\DRSYS01.DBF',
  'D:\oracle\oradata\orcl\CWMLITE01.DBF'
CHARACTER SET ZHS16GBK;

SQL> ALTER SYSTEM SET DB_BLOCK_SIZE=8192  --可选

SQL>   SHUTDOWN ABORT;  

SQL>   STARTUP

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\oradata\orcl\REDO01.LOG 回车(重新指定日志文件)

SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL>

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oracle\oradata\orcl\temp01.dbf' size 10M;