Re: Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 21 May 2009 17:41:46 +0200
Message-ID: <4a15763a$0$23747$426a74cc_at_news.free.fr>


"beri" <berindei_at_gmail.com> a écrit dans le message de news: 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]

http://www.orafaq.com/forum/t/145444/102589/ Received on Thu May 21 2009 - 10:41:46 CDT

Original text of this message