原机器上有目标数据库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>
解决方案 »
- Oracle 数据导出导入问题
- 如何写一个PL/SQL 程序块以提升两个资格最老的"职员"为 "高级职员"
- 在客户端执行一个很长时间的存储过程可以成功,用JDBC时失败了
- 请问一下怎样通过java程序或通过shell 将数据库里面某张表的数据导出来?
- OCI编程问题——如何从表中取出一条记录,将其更新,然后在取下一条,在更新,....
- Oracle 远程客服端用什么工具好
- 请问以下关于注册表的问题?
- 请教一个问题,我的程序中的select后的列名是根据不同情况变化的,但是我希望他们都能够按照列的顺序排序,oracle中有没有象informix中的
- Oracle 9i JDeveloper如何安装?
- odbc中的varchar2(2000)问题。
- 无法打开Enterprise Manager Console
- 执行存储过程权限不足
rman 需要先连接到恢复目录数据库(rman target / catalog catman@catadb),再还原控制文件(restore controlfile),安装数据库(alter database mount),还原 level0 备份(restore database),level1 备份(recover database)。