Home » RDBMS Server » Backup & Recovery » Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES (Solaris AMD64 with Oracle RAC 10g Enterprise Edition Release 10.2.0.3.0)
Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES [message #404372] Thu, 21 May 2009 09:41 Go to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
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.

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

[Updated on: Thu, 21 May 2009 10:22] by Moderator

Report message to a moderator

Re: Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES [message #404380 is a reply to message #404372] Thu, 21 May 2009 10:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you do the recommended settings as said here?
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/omf.htm#sthref1619

Also,
Please do not use bold , italic tags to format the post.
Just use CODE tag.
I tried to fix your above post, but just made it worse.
Re: Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES [message #404392 is a reply to message #404372] Thu, 21 May 2009 11:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In addition to what Mahesh suggested, have you tried to catalog the FRA?

RMAN> catalog recovery area;


Re: Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES [message #404395 is a reply to message #404380] Thu, 21 May 2009 11:18 Go to previous messageGo to next message
alexberi
Messages: 16
Registered: May 2009
Junior Member
Hello,
RAC is configured to use an ASM area named +DG1.

I set next parameters:
alter system set db_recovery_file_dest='+DG1' scope=both;
alter system set db_recovery_file_dest_size=150G scope=both;
alter system set log_archive_dest_10='location=use_db_recovery_file_dest';

SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;
SQL> alter database enable block change tracking using file '+DG1';
SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=2880;  --2days
SQL> ALTER DATABASE FLASHBACK ON;


When I issue
SQL> alter database add logfile size 100M;
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;

When adding the new log with alter database add logfile size 100M; the new redo log group 5 with two new members is added:
SQL> select * from gv$logfile;
INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
5 1 5 ONLINE +DG1/orcl/onlinelog/group_5.298.687456821 NO
6 1 5 ONLINE +DG1/orcl/onlinelog/group_5.299.687456821 YES

I do not understand why two group members are created for the new logfile group and why one have IS_RECOVERY_DEST_FILE="NO" and the other have IS_RECOVERY_DEST_FILE="NO".

I suppose this have to do with redo logs multiplexation, but I don't know how to create only logfiles with IS_RECOVERY_DEST_FILE="YES".

I need the IS_RECOVERY_DEST_FILE="YES" because I want to use RMAN with flashback area for incremental hotbackups:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Re: Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES [message #561737 is a reply to message #404372] Wed, 25 July 2012 01:35 Go to previous message
shansvt
Messages: 1
Registered: July 2012
Location: India
Junior Member
Same issue for me, in my case am using db_create_online_log_dest_1 & 2 parameters also in my database.

Even though am using db_recovery_file_dest, am not able to set IS_RECOVERY_DEST_FILE=YES, after trying the below solution....

So finally am set null values in db_create_online_log_dest_1 & 2 parameters.

Now am able to find the IS_RECOVERY_DEST_FILE=YES in select GROUP#,MEMBER,IS_RECOVERY_DEST_FILE from v$logfile;

while creating the new logfile===> alter database add logfile size 100M;

Thanks,

[Updated on: Wed, 25 July 2012 01:37]

Report message to a moderator

Previous Topic: how can i create empaty database in oracle 10g
Next Topic: RMAN backup strategy for active-active deployments using streams
Goto Forum:
  


Current Time: Thu Mar 28 15:30:06 CDT 2024