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,
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 NOReceived on Thu May 21 2009 - 09:47:32 CDT
[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]