ORA-01034: ORACLE not available
来源:互联网 发布:仓库管理系统网页源码 编辑:程序博客网 时间:2024/06/14 04:17
ALTER DATABASE ADD LOGFILE '/dbdata/oracle/logfile/redo01a.log' size 50M; //设置大小
alter database add logfile member '/dbdata/oracle/logfile/redo01a.log' to group 1;
SQL> startup
ORACLE instance started.
Total System Global Area 2471931904 bytes
Fixed Size 2255752 bytes
Variable Size 1040188536 bytes
Database Buffers 1409286144 bytes
Redo Buffers 20201472 bytes
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/data/oracle/datafile/sunecm01.dbf'
SQL> recover datafile '/data/oracle/datafile/sunecm01.dbf'
ORA-01034: ORACLE not available
Process ID: 23279
Session ID: 1705 Serial number: 5
----------------重启服务器、释放进行------
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2471931904 bytes
Fixed Size 2255752 bytes
Variable Size 1040188536 bytes
Database Buffers 1409286144 bytes
Redo Buffers 20201472 bytes
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/data/oracle/datafile/sunecm01.dbf'
SQL> recover datafile '/data/oracle/datafile/sunecm01.dbf'
Media recovery complete.
- ora-01034:oracle not available
- ora-01034 oracle not available
- ORA-01034:oracle not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ora-01034:oracle not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- ORA-01034: ORACLE not available
- [linux]vi命令高级玩法
- 暴风影音2018届校园招聘技术类笔试题目
- Redis数据类型
- generator
- python操作hbase 远程连接
- ORA-01034: ORACLE not available
- eclipse连接Oracle数据库和MySQL数据库
- Win10+GTX1050ti+cuda8.0+cuDNN5.1+Tensorflow-gpu1.2+Keras+Theano环境搭建
- Java创建线程的三种方式
- 解决运行yum的时候被lock
- myeclipse 配置
- 安装rabbitMQ
- 堆的应用
- [spark] spark推测式执行