ORA-00283: recovery session canceled due to errors ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/opt/oracle/oradata/demo/redo01.log' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory 数据库无法启动 关键是损坏了所有日志文件，并且在非archive状态 没有保存和备份的redo01.log文件 数据库无法drop掉当前的log文件 有无法切...
本文为模拟测试，主要步骤如下：
1.对测试数据库进行rman全备(nocatalog 模式)
2.删除oradata\orcl目录下所有文件
3.使用rman进行恢复。
详细步骤如下：
1.对测试数据库进行rman全备
- C:\Documents and Settings\xGss2000>rman nocatalog target /
-
- redo文件的功能描述
某个用户的数据库，启动数据库的时候alert.log里报如下错误:
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3096.trc:
ORA-00333: 重做日志读取块 155649 计数 2048 出错
ORA-00312: 联机日志 10 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\redo10.LOG'
ORA-27070: 异步读取/写入失败
OSD-04006: ReadFile() 失败, 无法读取文件
O/S-Error: (OS 23) 数据错误(循环冗余检...
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size &...
用户数据库不能打开，Alert log中报如下错误：
Fri Oct 3 20:02:27 2008
Errors in file /u01/oracle/admin/caq/bdump/caq_lgwr_2060404.trc:
ORA-00345: redo log write error block 152320 count 57
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/caq/redo03.log'
ORA-27063: skgfospo: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 110: Media surface erro...
