Java研发|Oracle修复记录
SQL> select * from v$log;
select * from v$log
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
【Java研发|Oracle修复记录】Session ID: 0 Serial number: 0
在oracle操作的时候,遇到这个问题,尝试了很多办法,都没办法解决。最后通过介质恢复,恢复到过去某个正常的时间点,解决了问题。
SQL> select * from v$log;
GROUP#THREAD#SEQUENCE#BYTESBLOCKSIZEMEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUSFIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------------- ------------- --------- ------------ ---------
1110652428800512 1 NO
CURRENT2482101 19-FEB-182.8147E+14
3110552428800512 1 NO
INACTIVE2453249 19-FEB-182482101 19-FEB-18
2110452428800512 1 NO
INACTIVE2441409 19-FEB-182453249 19-FEB-18
SQL>recover database until time '2018-02-18 12:12:12';
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size2214056 bytes
Variable Size1140852568 bytes
Database Buffers570425344 bytes
Redo Buffers6836224 bytes
Database mounted.
Database opened.
参考链接:http://blog.csdn.net/zzhiyun/article/details/62039320
推荐阅读
- JAVA(抽象类与接口的区别&重载与重写&内存泄漏)
- 事件代理
- Java|Java OpenCV图像处理之SIFT角点检测详解
- java中如何实现重建二叉树
- 数组常用方法一
- 【Hadoop踩雷】Mac下安装Hadoop3以及Java版本问题
- Java|Java基础——数组
- RxJava|RxJava 在Android项目中的使用(一)
- java之static、static|java之static、static final、final的区别与应用
- Java基础-高级特性-枚举实现状态机