Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES

From: beri <berindei_at_gmail.com>
Date: Thu, 21 May 2009 07:47:32 -0700 (PDT)
Message-ID: <1f395471-0c3d-4e69-b5a7-495763914bc2_at_n4g2000vba.googlegroups.com>



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]

I added another log with:

[I][B]SQL> alter database add logfile size 100M;
[/B][/I]

As result two new file groups are added, don't know why?:
[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

[B]5 1 5 ONLINE +DG1/orcl/onlinelog/group_5.298.687456821 NO
6 1 5 ONLINE +DG1/orcl/onlinelog/group_5.299.687456821 YES[/B][/I]
Received on Thu May 21 2009 - 09:47:32 CDT

Original text of this message