1、打开数据库,会遇到一个类似的错误 ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ‘D:\ORACLE\ORADATA\TEST\REDO01.LOG’ ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) 系统找不到指定的文件 2、...
1、启动数据库,遇到ORA-00312 or ORA-00313错误,如: ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 3 thread 1: '/opt/oracle/db04/oradata/ORCL/redo03.log' 从这里我们知道日志组1的数据文件损坏或丢失了 从报警文件可以看到更详细的信息 2、查看V$log视图:...
1、打开数据库,会遇到一个类似的错误 ORA-00313:open failed for members of log group 1 of thread 1 ORA-00312:online log 1 thread 1:'D:ORACLEORADATATESTREDO01.LOG' ORA-27041:unable to open file OSD-04002:unable to open file O/S-Error:(OS 2)系统找不到指定的文件 2、查看V$log,发现是...
ORA-00313: 无法打开日志组 1 (线程 1) 的成员 ORA-00312: 联机日志 1 线程 1: 'D:ORACLEORADATAGOCOMREDO01.LOG' SQL> connect / as sysdba; 已连接。 SQL> shutdown immediate; ORA-01109: 数据库未打开 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> startup; ORACLE 例程已经启动。 Total System ...
ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:\ORACLE\ORADATA\TEST\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2)系统找不到指定的文件 2、查看V$log,发现是当前日志 SQL>; select...
ORA-00312: 联机日志 1 线程 1: 'D:\ORACLE\ORADATA\GOCOM\REDO01.LOG' SQL> connect / as sysdba; 已连接。 SQL> shutdown immediate; ORA-01109: 数据库未打开 已经卸载数据库。 ORACLE 例程已经关闭。 SQL> startup; ORACLE 例程已经启动。
ORA-00313: open failed for members of log group 4 of thread 1 ORA-00312: online log 3 thread 1: '/opt/oracle/db04/oradata/ORCL/redo03.log' 日志组3异常. 2.2、查v$log SQL> select group#,sequence#,archived,status from v$log;
左右10g DG中间ORA-19527和ORA-00312错误解决演示示例 这些天大厦10g DG Windows 2008 R2测试环境,主要明天去给客户端,再建一个生产资源库DG,其中一些发现的问题。特此记录下来 因为将要部署到生产环境。所以考虑在线搭建DG的方案,即不停库的情况下。而问题主要就是出在不停库时,用RAMN创建STANDBY的时候...
ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:ORACLEORADATATESTREDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2)系统找不到指定的文件 ...
今天有台Oracle9i无法启动,出现如下错误: ora-00322:log 1of thread 1 is not current copy ora-00312:online log 1thread 1:'opt\oracle\oradata\oradb\REDO02.LOG' 解决办法如下: 1. shutdown immediate; 2. startup mount; 3 ...