--创建控制文件 ！
C:Documents and SettingsAdministrator>rman target sys/sys@ora252 catalog rman/
rman@ora252 auxiliary /
恢复管理器: Release 11.1.0.6.0 - Production on 星期三 4月 29 09:54:41 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到目标数据库: ORCL (DBID=1213082043)
连接到恢复目录数据库
已连接到辅助数据库 (未启动)
启动 restore 于 29-4月 -09
分配的通道: ORA_AUX_DISK_1
通道 ORA_AUX_DISK_1: SID=150 设备类型=DISK
通道 ORA_AUX_DISK_1: 正在开始还原数据文件备份集
通道 ORA_AUX_DISK_1: 正在还原控制文件
通道 ORA_AUX_DISK_1: 正在读取备份片段 D:APPADMINISTRATORFLASH_RECOVERY_AREAO
RCLAUTOBACKUP2009_04_28O1_MF_S_685391660_4ZFPXMVT_.BKP
通道 ORA_AUX_DISK_1: 段句柄 = D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLAUTO
BACKUP2009_04_28O1_MF_S_685391660_4ZFPXMVT_.BKP 标记 = TAG20090428T183420
通道 ORA_AUX_DISK_1: 已还原备份片段 1
通道 ORA_AUX_DISK_1: 还原完成, 用时: 00:00:01
输出文件名=D:CONTROL01.CTL
完成 restore 于 29-4月 -09
RMAN> exit

--恢复关键的表空间
C:Documents and SettingsAdministrator>rman target / catalog rman/rman@ora252
恢复管理器: Release 11.1.0.6.0 - Production on 星期三 4月 29 09:55:13 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到目标数据库: ORCL (未装载)
连接到恢复目录数据库
RMAN> restore tablespace system;
启动 restore 于 29-4月 -09
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID=154 设备类型=DISK
通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00001 还原到 D:APPADMINISTRATORORADATAORCLSYSTE
M01.DBF
通道 ORA_DISK_1: 正在读取备份片段 E:DB_ORCL_46_1_685388997
通道 ORA_DISK_1: 段句柄 = E:DB_ORCL_46_1_685388997 标记 = TAG20090428T174956
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 正在读取备份片段 E:DB_ORCL_46_2_685388997
通道 ORA_DISK_1: 段句柄 = E:DB_ORCL_46_2_685388997 标记 = TAG20090428T174956
通道 ORA_DISK_1: 已还原备份片段 2
通道 ORA_DISK_1: 正在读取备份片段 E:DB_ORCL_46_3_685388997
通道 ORA_DISK_1: 段句柄 = E:DB_ORCL_46_3_685388997 标记 = TAG20090428T174956
通道 ORA_DISK_1: 已还原备份片段 3
通道 ORA_DISK_1: 还原完成, 用时: 00:00:37
完成 restore 于 29-4月 -09
RMAN> restore tablespace UNDOTBS1;
启动 restore 于 29-4月 -09
使用通道 ORA_DISK_1
通道 ORA_DISK_1: 正在开始还原数据文件备份集
通道 ORA_DISK_1: 正在指定从备份集还原的数据文件
通道 ORA_DISK_1: 将数据文件 00003 还原到 D:APPADMINISTRATORORADATAORCLUNDOT
BS01.DBF
通道 ORA_DISK_1: 正在读取备份片段 E:DB_ORCL_46_1_685388997
通道 ORA_DISK_1: 段句柄 = E:DB_ORCL_46_1_685388997 标记 = TAG20090428T174956
通道 ORA_DISK_1: 已还原备份片段 1
通道 ORA_DISK_1: 还原完成, 用时: 00:00:03
完成 restore 于 29-4月 -09
RMAN>exit;

--打开备库，执行相应的数据库不完全恢复
SQL> startup nomount
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 201327508 bytes
Database Buffers 327155712 bytes
Redo Buffers 5844992 bytes
SQL> alter database mount clone database;
Database altered.
SQL> alter database datafile 1 online;
Database altered.
SQL> alter database datafile 3 online;
Database altered.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1063367 generated at 04/28/2009 17:50:04 needed for thread 1
ORA-00289: suggestion :
D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_28O1_MF_1_28_
ZFNGLG5_.ARC
ORA-00280: change 1063367 for thread 1 is in sequence #28
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1063520 generated at 04/28/2009 17:52:18 needed for thread 1
ORA-00289: suggestion :
D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_28O1_MF_1_29_
ZFPWQN0_.ARC
ORA-00280: change 1063520 for thread 1 is in sequence #29
ORA-00278: log file
'D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_28O1_MF_1_28
4ZFNGLG5_.ARC' no longer needed for this recovery
ORA-00279: change 1065717 generated at 04/28/2009 18:33:59 needed for thread 1
ORA-00289: suggestion :
D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_28O1_MF_1_30_
ZG3M40Z_.ARC
ORA-00280: change 1065717 for thread 1 is in sequence #30
ORA-00278: log file
'D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_28O1_MF_1_29
4ZFPWQN0_.ARC' no longer needed for this recovery
ORA-00279: change 1089926 generated at 04/28/2009 22:10:43 needed for thread 1
ORA-00289: suggestion :
D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_29O1_MF_1_31_
U_.ARC
ORA-00280: change 1089926 for thread 1 is in sequence #31
ORA-00278: log file
'D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_28O1_MF_1_30
4ZG3M40Z_.ARC' no longer needed for this recovery
ORA-00308: cannot open archived log
'D:APPADMINISTRATORFLASH_RECOVERY_AREAORCLARCHIVELOG2009_04_29O1_MF_1_31
%U_.ARC'
ORA-27041: unable to open file
OSD-04002: 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 O/S-Error: (OS 2)
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
SQL> alter database open resetlogs;
Database altered.
SQL>
--表空间时间点恢复手工操作可以

[@more@]