原机器上有目标数据库tb5pcc+恢复目录数据,做了0级和1级备份,DBCA删除2个数据库.
现在想用0级和1级备份做恢复,但提示RMAN-06023: no backup or copy of datafile 1 found to restoreC:\>oradim -NEW -SID tb5pccC:\>set oracle_sid=tb5pccC:\>rman target /恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.已连接到目标数据库 (未启动)RMAN> set dbid 182764613;正在执行命令: SET DBIDRMAN> startup nomount;启动失败: ORA-01078: failure in processing system parameters
LRM-00109: N^7(4r?*2NJ}ND<~ 'D:\ORACLE\ORA92\DATABASE\INITTB5PCC.ORA'正在尝试在没有参数文件的情况下启动 Oracle 例程...
Oracle 例程已启动系统全局区域总计 97589952 字节Fixed Size 453312 字节
Variable Size 46137344 字节
Database Buffers 50331648 字节
Redo Buffers 667648 字节RMAN> restore spfile to pfile 'D:\INIT.ORA' from 'e:\backup\C-182764613-20110114-01';启动 restore 于 17-1月 -11正在使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=9 devtype=DISK
通道 ORA_DISK_1: 已找到的自动备份: e:\backup\C-182764613-20110114-01
通道 ORA_DISK_1: 从自动备份复原 SPFILE 已完成
完成 restore 于 17-1月 -11RMAN> startup force nomount pfile='D:\INIT.ORA';Oracle 例程已启动系统全局区域总计 135338868 字节Fixed Size 453492 字节
Variable Size 109051904 字节
Database Buffers 25165824 字节
Redo Buffers 667648 字节RMAN> restore controlfile from 'e:\backup\C-182764613-20110114-01';启动 restore 于 17-1月 -11分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=13 devtype=DISK
通道 ORA_DISK_1: 正在恢复控制文件
通道 ORA_DISK_1: 恢复完成
正在复制控制文件
输出文件名=D:\ORACLE\ORADATA\TB5PCC\CONTROL01.CTL
输出文件名=D:\ORACLE\ORADATA\TB5PCC\CONTROL02.CTL
输出文件名=D:\ORACLE\ORADATA\TB5PCC\CONTROL03.CTL
完成 restore 于 17-1月 -11RMAN> alter database mount;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/17/2011 15:07:03
ORA-01990: 打开口令文件'D:\oracle\ora92\DATABASE\PWDtb5pcc.ORA'时出错
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。RMAN> alter database mount;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/17/2011 15:07:06
ORA-01100: 数据库已安装RMAN> restore database;启动 restore 于 17-1月 -11使用通道 ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/17/2011 15:08:07
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restoreRMAN>
现在想用0级和1级备份做恢复,但提示RMAN-06023: no backup or copy of datafile 1 found to restoreC:\>oradim -NEW -SID tb5pccC:\>set oracle_sid=tb5pccC:\>rman target /恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.已连接到目标数据库 (未启动)RMAN> set dbid 182764613;正在执行命令: SET DBIDRMAN> startup nomount;启动失败: ORA-01078: failure in processing system parameters
LRM-00109: N^7(4r?*2NJ}ND<~ 'D:\ORACLE\ORA92\DATABASE\INITTB5PCC.ORA'正在尝试在没有参数文件的情况下启动 Oracle 例程...
Oracle 例程已启动系统全局区域总计 97589952 字节Fixed Size 453312 字节
Variable Size 46137344 字节
Database Buffers 50331648 字节
Redo Buffers 667648 字节RMAN> restore spfile to pfile 'D:\INIT.ORA' from 'e:\backup\C-182764613-20110114-01';启动 restore 于 17-1月 -11正在使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=9 devtype=DISK
通道 ORA_DISK_1: 已找到的自动备份: e:\backup\C-182764613-20110114-01
通道 ORA_DISK_1: 从自动备份复原 SPFILE 已完成
完成 restore 于 17-1月 -11RMAN> startup force nomount pfile='D:\INIT.ORA';Oracle 例程已启动系统全局区域总计 135338868 字节Fixed Size 453492 字节
Variable Size 109051904 字节
Database Buffers 25165824 字节
Redo Buffers 667648 字节RMAN> restore controlfile from 'e:\backup\C-182764613-20110114-01';启动 restore 于 17-1月 -11分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=13 devtype=DISK
通道 ORA_DISK_1: 正在恢复控制文件
通道 ORA_DISK_1: 恢复完成
正在复制控制文件
输出文件名=D:\ORACLE\ORADATA\TB5PCC\CONTROL01.CTL
输出文件名=D:\ORACLE\ORADATA\TB5PCC\CONTROL02.CTL
输出文件名=D:\ORACLE\ORADATA\TB5PCC\CONTROL03.CTL
完成 restore 于 17-1月 -11RMAN> alter database mount;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/17/2011 15:07:03
ORA-01990: 打开口令文件'D:\oracle\ora92\DATABASE\PWDtb5pcc.ORA'时出错
ORA-27041: 无法打开文件
OSD-04002: 无法打开文件
O/S-Error: (OS 2) 系统找不到指定的文件。RMAN> alter database mount;RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 01/17/2011 15:07:06
ORA-01100: 数据库已安装RMAN> restore database;启动 restore 于 17-1月 -11使用通道 ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/17/2011 15:08:07
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restoreRMAN>
rman 需要先连接到恢复目录数据库（rman target / catalog catman@catadb），再还原控制文件（restore controlfile），安装数据库（alter database mount），还原 level0 备份（restore database），level1 备份（recover database）。