Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

logfile member shows in database but not on physical disk, not match

849425Jun 30 2012 — edited Jul 2 2012

I just created a standby db through rman duplicat active database from target, and it worked.

However when I issued a alter syste switch logfile, it not have anything going on on standby side.

I checked the alert log, when the standby db started, it has following error:

Errors in file /u01/app/oracle/diag/rdbms/prd/prdS1/trace/prdS1_ora_16397.trc:
ORA-00313: open failed for members of log group 13 of thread 2
ORA-00312: online log 13 thread 2: '+PRD_DAT/prd/onlinelog/group_13.390.786640667'
ORA-17503: ksfdopn:2 Failed to open file +PRD_DAT/prd/onlinelog/group_13.390.786640667
ORA-15173: entry 'group_13.390.786640667' does not exist in directory 'onlinelog'
Completed: alter database clear logfile group 13
alter database clear logfile group 14
Clearing online log 14 of thread 2 sequence number 0
Errors in file /u01/app/oracle/diag/rdbms/prd/prdS1/trace/prdS1_ora_16397.trc:
ORA-00313: open failed for members of log group 14 of thread 2
ORA-00312: online log 14 thread 2: '+PRD_DAT/prd/onlinelog/group_14.366.786640667'
ORA-17503: ksfdopn:2 Failed to open file +PRD_DAT/prd/onlinelog/group_14.366.786640667
ORA-15173: entry 'group_14.366.786640667' does not exist in directory 'onlinelog'
Errors in file /u01/app/oracle/diag/rdbms/prd/prdS1/trace/prdS1_ora_16397.trc:
ORA-00313: open failed for members of log group 14 of thread 2
ORA-00312: online log 14 thread 2: '+PRD_DAT/prd/onlinelog/group_14.366.786640667'
ORA-17503: ksfdopn:2 Failed to open file +PRD_DAT/prd/onlinelog/group_14.366.786640667
ORA-15173: entry 'group_14.366.786640667' does not exist in directory 'onlinelog'
Completed: alter database clear logfile group 14
RFS connections are allowed
Sat Jun 30 21:03:50 2012
alter database flashback on
Errors in file /u01/app/oracle/diag/rdbms/prd/prdS1/trace/prdS1_ora_18097.trc:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38788: More standby database recovery is needed
ORA-38706 signalled during: alter database flashback on...

Sql results of logfile members are this:

MEMBER
--------------------------------------------------------------------------------
+PRD_DAT/prds/onlinelog/group_2.262.787354885
+PRD_DAT/prds/onlinelog/group_1.290.787354885
+PRD_DAT/prds/onlinelog/group_5.260.787354889
+PRD_DAT/prds/onlinelog/group_3.261.787354887
+PRD_DAT/prds/onlinelog/group_4.264.787354887
+PRD_DAT/prds/onlinelog/group_6.279.787354889
+PRD_DAT/prds/onlinelog/group_7.277.787354889
+PRD_DAT/prds/onlinelog/group_8.280.787354891
+PRD_DAT/prds/onlinelog/group_9.281.787354891
+PRD_DAT/prds/onlinelog/group_10.282.787354893
+PRD_DAT/prds/onlinelog/group_11.287.787354893

MEMBER
--------------------------------------------------------------------------------
+PRD_DAT/prds/onlinelog/group_12.265.787354893
+PRD_DAT/prds/onlinelog/group_13.266.787354895
+PRD_DAT/prds/onlinelog/group_14.283.787354895
+PRD_FRA/prds/onlinelog/group_1.1285.787354885
+PRD_FRA/prds/onlinelog/group_2.1286.787354885
+PRD_FRA/prds/onlinelog/group_3.1287.787354887
+PRD_FRA/prds/onlinelog/group_4.1288.787354887
+PRD_FRA/prds/onlinelog/group_5.1289.787354889
+PRD_FRA/prds/onlinelog/group_6.1290.787354889
+PRD_FRA/prds/onlinelog/group_7.1291.787354891
+PRD_FRA/prds/onlinelog/group_8.1292.787354891

MEMBER
--------------------------------------------------------------------------------
+PRD_FRA/prds/onlinelog/group_9.1293.787354891
+PRD_FRA/prds/onlinelog/group_10.1294.787354893
+PRD_FRA/prds/onlinelog/group_11.1295.787354893
+PRD_FRA/prds/onlinelog/group_12.1296.787354895
+PRD_FRA/prds/onlinelog/group_13.1297.787354895
+PRD_FRA/prds/onlinelog/group_14.1298.787354895

28 rows selected.

asmcmd shows those log files:

Type Redund Striped Time Sys Name
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_1.290.787354885
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_10.282.787354893
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_11.287.787354893
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_12.265.787354893
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_13.266.787354895
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_14.283.787354895
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_2.262.787354885
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_3.261.787354887
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_4.264.787354887
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_5.260.787354889
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_6.279.787354889
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_7.277.787354889
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_8.280.787354891
ONLINELOG UNPROT COARSE JUN 30 21:00:00 Y group_9.281.787354891
ASMCMD> exit

How to fix this issue, the physical standby db seems not working.

Thanks in advance for help.

This post has been answered by mseberg on Jul 2 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2012

Added on Jun 30 2012

#data-guard, #performance-availability

31 comments

6,090 views