Hi all,
I'm here again with a little problem with Oracle Dataguard.
After the duplicate, all online redo log files and standby log files
were equal in primary and standby databases.
But now, in the standby database, some online redologs are missing.
So, I've created the online log files on standby database.
But the status are invalid:
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------------------------------------- ---
1 INVALID ONLINE +DATA/PROJ_STD/onlinelog/group_1.392.123263579 NO
1 ONLINE +FRA/PROJ_STD/onlinelog/group_1.948.123234493 YES
2 ONLINE +FRA/PROJ_STD/onlinelog/group_2.852.123234495 YES
2 INVALID ONLINE +DATA/PROJ_STD/onlinelog/group_2.393.123263607 NO
3 ONLINE +FRA/PROJ_STD/onlinelog/group_3.946.123234495 YES
3 INVALID ONLINE +DATA/PROJ_STD/onlinelog/group_3.394.123263613 NO
4 INVALID ONLINE +DATA/PROJ_STD/onlinelog/group_4.395.123263615 NO
4 ONLINE +FRA/PROJ_STD/onlinelog/group_4.933.123234497 YES
5 STANDBY +FRA/PROJ_STD/onlinelog/group_5.989.123262059 NO
5 STANDBY +DATA/PROJ_STD/onlinelog/group_5.387.123262055 NO
6 STANDBY +FRA/PROJ_STD/onlinelog/group_6.990.123262075 NO
6 STANDBY +DATA/PROJ_STD/onlinelog/group_6.388.123262073 NO
7 STANDBY +DATA/PROJ_STD/onlinelog/group_7.389.123262081 NO
7 STANDBY +FRA/PROJ_STD/onlinelog/group_7.991.123262085 NO
8 STANDBY +DATA/PROJ_STD/onlinelog/group_8.390.123262091 NO
8 STANDBY +FRA/PROJ_STD/onlinelog/group_8.992.123262093 NO
9 STANDBY +DATA/PROJ_STD/onlinelog/group_9.391.123262103 NO
9 STANDBY +FRA/PROJ_STD/onlinelog/group_9.993.123262105 NO
the alert log:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00313: open failed for members of log group 4 of thread 1
Is this correct? What's wrong? What can I do to solve this and all online redo logs in both databases are equals?
Thank you very much!!!!