日志文件损坏的恢复
日志文件损坏的恢复
今天打开我测试机的oracle数据库。发现数据库起步来了。具体步骤如下：
SYS>startup
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1220796 bytes
Variable Size 104861508 bytes
Database Buffers 490733568 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-16038: log 1 sequence# 56 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
SYS>alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 1 sequence# 56 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
SYS>shutdown abort
ORACLE instance shut down.
SYS>startup
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1220796 bytes
Variable Size 104861508 bytes
Database Buffers 490733568 bytes
Redo Buffers 7163904 bytes
Database mounted.
ORA-16038: log 1 sequence# 56 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
SYS>select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
3 STALE ONLINE +ORACLEASM/orcl/onlinelog/group_3.266.747324497 NO
2 ONLINE +ORACLEASM/orcl/onlinelog/group_2.267.747324547 NO
1 ONLINE /u01/app/oracle/oradata/orcl/redo01.log NO
原来闪回区空间满了。删除了一部分后就ok了。
alter database clear unarchived logfile group 1;
alter database open
ok 数据库起来了。。。。。呵呵
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24531354/viewspace-692182/ ，如需转载，请注明出处，否则将追究法律责任。
