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. (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|