1 1：数据库启动报错ORA-00333SQL> select status from v$instance;STATUS---MOUNTEDSQL> alter database open;alter database open*ERROR at line 1:ORA-00333: redo log read error block 8194 count 8192SQL> select group#,sequence#,archived,status from v$log; GROUP# SEQUENCE# ARC STATUS--- --- ...
1.对于非当前REDO或者当前REDO但是无活动事务使用以下CLEAR命令: 用CLEAR命令重建该日志文件SQL>alter database clear logfile group 3; 如果是该日志组还没有归档,则需要用SQL>alter database clear unarchived logfile group 3; 因为是当前实例恢复需要用的REDO,且未归档,使用是CLEAR命令不行的。 2.没备份,有备份...
1.对于非当前REDO或者当前REDO可是无活动事务使用下面CLEAR命令: 用CLEAR命令重建该日志文件SQL>alter database clear logfile group 3。 假设是该日志组还没有归档,则须要用SQL>alter database clear unarchived logfile group 3; 由于是当前实例恢复须要用的REDO,且未归档。使用是CLEAR命令不行的。 2.没备份,有备...
00333, 00000, "redo log read error block %s count %s" // *Cause: An IO error occurred while reading the log described in the // accompanying error. // *Action: Restore accessibility to file, or get another copy of the file. [oracle@oslatm ~]$ 由于没有备份,建议当前对数据库进行shutd...
ORA-00333: redo log read error blocknumcountnum Cause:An error occurred while reading the redo log file. Other messages will accompany this message and will give the name of the file. Action:Restore access to the file or get another copy of the file. ...
Oracle数据库REDO损坏ora-00333修复手札 1.事情起因 接到电话,周日意外断电,数据库起不了,报REDO CRASH,ora-00333错误。 相关环境如下:RAC oracle_11.2.0.3,无备份,开归档。 2处理 一到现场,既然对方没有备份,那就做一个冷备份咯;oracle 11g嘛,把asm里datafile,logfile,controlfile(如果有必要spfile.ora)copy...
Oracle数据库REDO损坏ora-00333修复手札 1.事情起因 接到电话,周日意外断电,数据库起不了,报REDO CRASH,ora-00333错误。 相关环境如下:RAC oracle_11.2.0.3,无备份,开归档。 2处理 一到现场,既然对方没有备份,那就做一个冷备份咯;oracle 11g嘛,把asm里datafile,logfile,controlfile(如果有必要spfile.ora)copy...
ORA-00333: redo log read error block string count string Cause: An IO error occurred while reading the log described in the accompanying error. Action: Restore accessibility to file, or get another copy of the file. ORA-00334: archived log: 'string' Cause: Reporting filename for det...
ORA-00333: redo log read error block string count string Cause: An IO error occurred while reading the log described in the accompanying error. Action: Restore accessibility to file, or get another copy of the file. ORA-00334: archived log: 'string' Cause: Reporting filename for details...
ORA-10068: force redo log checksum errors - file number ORA-10069: Trusted Oracle test event ORA-10070: force datafile checksum errors - block number ORA-10071: force datafile checksum errors - file number ORA-10072: protect latch recovery memory ...