ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
来源:互联网 发布:巨人网络借壳对象 编辑:程序博客网 时间:2024/05/17 18:15
问题描述:
原数据库是11.2.0.1 版本,新数据库版本是11.2.0.4
今天准备把11.2.0.1 的数据库通过rman 恢复到11.2.0.4 数据库版本中去
在恢复完成之后,准备打开数据库的时候,报了如下错误:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 76308
Session ID: 149 Serial number: 3
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 76308
Session ID: 149 Serial number: 3
解决方法:
1.使用 startup upgrade 打开数据库
2.执行:$ORACLE_HOME/rdbms/admin/catupgrd.sql //修改数据字典即可
这个过程时间比较长
执行完上面操作执行,重新正常打开数据库即可
SQL> startup
ORACLE instance started.
ORACLE instance started.
Total System Global Area 1406128128 bytes
Fixed Size 1336484 bytes
Variable Size 1174408028 bytes
Database Buffers 218103808 bytes
Redo Buffers 12279808 bytes
Database mounted.
Database opened.
Fixed Size 1336484 bytes
Variable Size 1174408028 bytes
Database Buffers 218103808 bytes
Redo Buffers 12279808 bytes
Database mounted.
Database opened.
1 0
- ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700:DATABASE MUST BE OPENED WITH UPGRADE OPTION
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700:DATABASE MUST BE OPENED WITH UPGRADE OPTION
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700:database must be opened with UPGRADE option
- ORA-39700: database must be opened with UPGRADE option
- ORA-39700: database must be opened with UPGRADE option
- ORACLE11.2.0.4 版本升级ORA-39700: database must be opened with UPGRADE option问题解决记录
- ORA-00704: bootstrap process failure
- ORA-00704: bootstrap process failure 的处理
- ORA-16433: The database must be opened in read/write mode
- ORA-00704: bootstrap process failure 的处理(转载)
- ORA-01092: ORACLE 实例终止。强制断开连接 ORA-00704: bootstrap process failure 问题的处理
- Oracle数据恢复:解决ORA-00600:[4000] ORA-00704: bootstrap process failure错误一例
- Ora-26678 Streams capture process must be created first
- ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
- opengles之mipmap纹理
- 利用R(quantmod包实现均线)
- 基本查询语句及利用SQL语句完成数据的添加、删除、修改操作
- @Autowired注解、@Resource注解和@Service注解
- Problem D: 数组类(II)
- ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
- cocos-Lua 显示IP地址
- 继二分查找之后的有序数组的insert和delete操作
- 深入理解Python中的生成器
- iOS小技巧总结,绝对有你想要的
- OpenAI Gym学习
- 使用正则表达式获取指定的字符串的值
- c++实验6—项目六:字符串插入
- Problem E: 农夫果园