oracle 00314,ORA-00313报错解决方法

报错：

Errors in file /u01/oracle/admin/erp/bdump/erp_mrp0_25824.trc:

ORA-00313: open failed for members of log group 4 of thread 1

ORA-00312: online log 4 thread 1: '+DATA/erp/onlinelog/redo04.log'

ORA-17503: ksfdopn:2 Failed to open file +DATA/erp/onlinelog/redo04.log

ORA-15173: entry 'redo04.log' does not exist in directory 'onlinelog'

Fri Dec 27 09:11:42 CST 2013

Errors in file /u01/oracle/admin/erp/bdump/erp_mrp0_25824.trc:

ORA-00313: open failed for members of log group 4 of thread 1

ORA-00312: online log 4 thread 1: '+DATA/erp/onlinelog/redo04.log'

ORA-17503: ksfdopn:2 Failed to open file +DATA/erp/onlinelog/redo04.log

ORA-15173: entry 'redo04.log' does not exist in directory 'onlinelog'

Clearing online redo logfile 4 +DATA/erp/onlinelog/redo04.log

Fri Dec 27 09:11:42 CST 2013

Completed: alter database recover managed standby database disconnect

Fri Dec 27 09:11:42 CST 2013

Clearing online log 4 of thread 1 sequence number 61445

Fri Dec 27 09:11:42 CST 2013

解决方法：

SQL> alter database rename file '+DATA/erp/onlinelog/redo04.log' to '+DATA/erp/redo04.log';

Database altered.

SQL> alter database clear logfile group 4;

Database altered.

SQL> alter database drop standby logfile group 4;

Database altered.

SQL> alter database add logfile group 4 '+DATA/erp/onlinelog/redo04.log' size 100m;

查询standby备库，结果很多日志无法应用，出现断序号，只能手工添加，并且主库日志无法传递给备库，查看主库日志提示密码不对无法连接

备库，从主库拷贝密码文件至备库，关闭备库，重启。

1.这段日志是断的，没有应用过来的，那么你可以从主库拷贝日志，然后手动执行如下语句

alter database register physical logfile  '/archive/1_61447_805748820.dbf';

2. scp orapwerp 192.168.0.47:/u01/oracle/product/10.2.0/db_1/dbs/

3.关闭备库：shutdown immediate;

4.启动备库