Database Backup and Recovery (MOSC)

MOSC Banner

Oracle 10g RAC - Cannot set IS_RECOVERY_DEST_FILE to YES

edited May 28, 2009 4:28AM in Database Backup and Recovery (MOSC) 1 commentAnswered
 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]

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center