checkpoint is 11029786628
last deallocation scn is 11029437543
Wed Apr 01 05:10:33 2015
Full restore complete of datafile 1 todatafile copy /home/oradata/powerdes/system01.dbf. Elapsed time: 0:09:27
checkpoint is 11029786628
last deallocation scn is 10910611499
Undo Optimization current scn is 11029779851
Wed Apr 01 05:13:39 2015
Full restore complete of datafile 2 todatafile copy /home/oradata/powerdes/sysaux01.dbf. Elapsed time: 0:13:29
checkpoint is 11029786628
last deallocation scn is 11028968586
Wed Apr 01 05:14:44 2015
Full restore complete of datafile 6 todatafile copy /home/oradata/powerdes/plas01.dbf. Elapsed time: 0:14:37
checkpoint is 11029786628
last deallocation scn is 11028348038
Wed Apr 01 05:39:30 2015
Full restore complete of datafile 5 todatafile copy /home/oradata/powerdes/powerdesk01.dbf. Elapsed time: 0:39:12
checkpoint is 11029786628
last deallocation scn is 11029438448
?
?
2.2 数据抽取成功后，要创新创建控制文件
如果不知道如何创建controlfile的命令，可以在线上生成trace文件
一般默认的控制文件是二进制的，打开来是乱码的 ，备份一个trace出来 可以打开看到语句了,$ORACLE_BASE/admin/$ORACLE_SID/udump目录下，生成的新的 trace 文件里，trace文件有生成控制文件的脚本，使用如下命令alter database backup controlfile to trace as'/oracle/app/oracle/admin/powerdes/pfile/control.sql';可以得到创建控制文件的sql命令。
?
整理出来创建控制文件命令如下：
CREATE CONTROLFILE REUSE SET DATABASE"POWERDES" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 2920 DATAFILE '/home/oradata/powerdes/system01.dbf', '/home/oradata/powerdes/sysaux01.dbf', '/home/oradata/powerdes/undotbs01.dbf', '/home/oradata/powerdes/users01.dbf', '/home/oradata/powerdes/powerdesk01.dbf', '/home/oradata/powerdes/plas01.dbf', '/home/oradata/powerdes/pl01.dbf', '/home/oradata/powerdes/help01.dbf', '/home/oradata/powerdes/adobelc01.dbf', '/home/oradata/powerdes/sms01.dbf', '/home/oradata/powerdes/plcrm01.dbf' LOGFILE GROUP 1 '/home/oradata/powerdes/redo01.log' SIZE 50M BLOCKSIZE 512, GROUP 2 '/home/oradata/powerdes/redo02.log' SIZE 50M BLOCKSIZE 512, GROUP 3 '/home/oradata/powerdes/redo03.log' SIZE 50M BLOCKSIZE 512 CHARACTER SET ZHS16GBK;
2.3 恢复数据并且打开数据库
RMAN> recover database; Starting recover at 02-APR-15 using target database control file insteadof recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=767 devicetype=DISK starting media recovery unable to find archived log archived log thread=1 sequence=31023 RMAN-00571:=========================================================== RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS =============== RMAN-00571:=========================================================== RMAN-03002: failure of recover command at04/02/2015 13:35:40 RMAN-06054: media recovery requestingunknown archived log for thread 1 with sequence 31023 and starting SCN of11029786628 RMAN> RMAN> restore database from'/pddata2/oracle/backup/data/2015-03-30/full_POWERDES_20150330_3395.bak'; Starting restore at 02-APR-15 using channel ORA_DISK_1 RMAN-00571:=========================================================== RMAN-00569: