Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES
443102May 21 2009 — edited May 21 2009Hello,
Problem: I cannot set IS_RECOVERY_DEST_FILE to YES for log files of an Oracle 10g 2 node RAC.
Description: I am setting a Flash Recovery Area (FRA) to be used for RMAN backup. I have database set to ArchiveLog and set flashback on database.
Don't know how to change IS_RECOVERY_DEST_FILE to YES for database log files.
SQL> select * from gv$logfile;
INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
1 1 2 ONLINE +DG1/orcl/onlinelog/group_2.262.670607427 NO
2 1 1 ONLINE +DG1/orcl/onlinelog/group_1.261.670607425 NO
3 1 3 ONLINE +DG1/orcl/onlinelog/group_3.265.670607465 NO
4 1 4 ONLINE +DG1/orcl/onlinelog/group_4.266.670607465 NO
I added another log with:
SQL> alter database add logfile size 100M;
As result two new file groups are added, don't know why?:
INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
1 1 2 ONLINE +DG1/orcl/onlinelog/group_2.262.670607427 NO
2 1 1 ONLINE +DG1/orcl/onlinelog/group_1.261.670607425 NO
3 1 3 ONLINE +DG1/orcl/onlinelog/group_3.265.670607465 NO
4 1 4 ONLINE +DG1/orcl/onlinelog/group_4.266.670607465 NO
+5 1 5 ONLINE DG1/orcl/onlinelog/group_5.298.687456821 NO
6 1 5 ONLINE +DG1/orcl/onlinelog/group_5.299.687456821 YES
How to fix this?