ORA-01034: ORACLE not available

最新推荐文章于 2025-03-11 16:18:35 发布

原创最新推荐文章于 2025-03-11 16:18:35 发布 · 3.3k 阅读

1 ·

CC 4.0 BY-SA版权

Database 专栏收录该内容

4 篇文章

订阅专栏

本文记录了一次Oracle数据库实例启动过程中遇到文件需要介质恢复的问题，并详细展示了如何通过SQL命令完成介质恢复的过程。

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.

SQL> recover datafile '/data/oracle/datafile/sunecm01.dbf'
Media recovery complete.