运行rman,连接到本地数据库:C:\Documents and Settings\桌面>rman target /恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.连接到目标数据库: DB92N1 (DBID=2131595748)RMAN> exit 恢复管理器完成。运行rman,连接到远程数据库:C:\Documents and Settings\桌面>rman target /@db10gn1恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.连接到目标数据库: DB10GN1 (DBID=694436797)RMAN>
TO:drabit(square) 我的操作遇到如下问题,不知是什么原因? C:\Documents and Settings\rainbow>set oracle_sid=xscjC:\Documents and Settings\rainbow>rman target sys/manager@xscj恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed RMAN-03000: recovery manager compiler component initialization failed RMAN-06000: could not open recovery manager library file: d:\oracle\ora92\RDBMS\ ADMIN\RECOVER.BSQ LFI-00108: Open expect the file [RECOVER][BSQ] to exist.
RMAN-06000 could not open recovery manager library file: string Cause: The RECOVER.BSQ file could not be opened. Action: Check that the file was installed correctly and that the user running RMAN has authority to read the file. 意思是说,看一下那个recover.bsq文件在不在目录下,并且你执行rman的OS用户有访问那个文件的权限
TO:drabit(square)呵呵,厉害啊!我在服务器端执行rman没什么问题,到客户端就不行,原来客户端的 $\oracle\ora92\rdbms\admin目录下没有服务器端同目录下的RECOVER.BSQ文件,拷贝过来后问题就解决了,谢谢drabit(square),给分!C:\Documents and Settings\rainbow>rman target sys/manager@xscj恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.连接到目标数据库: XSCJ (DBID=585349649)RMAN>
恢复管理器完成。运行rman,连接到远程数据库:C:\Documents and Settings\桌面>rman target /@db10gn1恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.连接到目标数据库: DB10GN1 (DBID=694436797)RMAN>
我的操作遇到如下问题,不知是什么原因?
C:\Documents and Settings\rainbow>set oracle_sid=xscjC:\Documents and Settings\rainbow>rman target sys/manager@xscj恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-03000: recovery manager compiler component initialization failed
RMAN-06000: could not open recovery manager library file: d:\oracle\ora92\RDBMS\
ADMIN\RECOVER.BSQ
LFI-00108: Open expect the file [RECOVER][BSQ] to exist.
Cause: The RECOVER.BSQ file could not be opened.
Action: Check that the file was installed correctly and that the user running
RMAN has authority to read the file.
意思是说,看一下那个recover.bsq文件在不在目录下,并且你执行rman的OS用户有访问那个文件的权限
$\oracle\ora92\rdbms\admin目录下没有服务器端同目录下的RECOVER.BSQ文件,拷贝过来后问题就解决了,谢谢drabit(square),给分!C:\Documents and Settings\rainbow>rman target sys/manager@xscj恢复管理器: 版本9.2.0.1.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation. All rights reserved.连接到目标数据库: XSCJ (DBID=585349649)RMAN>