专注各种脚本编程
Baidu
加入收藏夹
本站内容有下面分类知识,欢迎您的到来^_^
shell相关:指令篇 基础篇 脚本欣赏 编程实例 shell问问 shell视频教程 技巧篇 水平测试 E文资料 vi编辑器 高级Bash脚本编程指南
其他:mysql perl c语言 oracle
当前位置:| 主页>oracle>

rman不能进,没有catalog,控制文件全部丢失,只保存RMAN备份的控制文件

百度收藏 QQ搜藏

问题:在进入oracle系统出现下面报错信息:
[oracle@c ~]$ uniread /u01/oracle/10/bin/rman target sys/password nocatalog
[uniread] Loaded history (80 lines)

Recovery Manager: Release 10.1.0.2.0 - Production
Copyright (c) 1995, 2004, Oracle.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06003: ORACLE error from target database:
ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/u01/oracle/oradata/POSTPPR/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
[uniread] Saved history (80 lines)

下面说下解决的方法:
1.登录到rman                   
  [oracle@c ~]$ uniread /u01/oracle/10/bin/rman target sys/password nocatalog

2.启动instance                 
  [oracle@c ~]$ startup force nomount;                   
                                       
3.恢复control_file             
  [oracle@c ~]$ restore controlfile from autob
                                       
4.最后一步了。                         
 [oracle@c ~]$ alter database mount;        
 [oracle@c ~]$ restore database;            
 [oracle@c ~]$ recover datafile;            
 [oracle@c ~]$ alter database open resetlogs;

上一篇:Telnet AIX机上oracle9i出现错误 下一篇:介绍oracle中的几个hash函数

power by soyo123 2007-2008