select * from v$log
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
在oracle操作的时候,遇到这个问题,尝试了很多办法,都没办法解决。最后通过介质恢复,恢复到过去某个正常的时间点,解决了问题。
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------------- ------------- --------- ------------ ---------
1 1 106 52428800 512 1 NO
CURRENT 2482101 19-FEB-18 2.8147E+14
3 1 105 52428800 512 1 NO
INACTIVE 2453249 19-FEB-18 2482101 19-FEB-18
2 1 104 52428800 512 1 NO
INACTIVE 2441409 19-FEB-18 2453249 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 Size 2214056 bytes
Variable Size 1140852568 bytes
Database Buffers 570425344 bytes
Redo Buffers 6836224 bytes
Database mounted.
Database opened.