Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES
Hello,
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.
[I][B]SQL> select * from gv$logfile;
[/B][/I]
[I] 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]
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.
[I][B]SQL> select * from gv$logfile;
[/B][/I]
[I] 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]
0