Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRA, IS_RECOVERY_DEST_FILE and RMAN Backups

SherrieKNov 7 2013 — edited Nov 18 2013

Oracle 11.1.0.7

RMAN full and incremental databases

I have an FRA configured, thinikng these are the important init.ora parameters:

log_archive_dest_1 LOCATION=+ASM_DATA/

log_archive_dest_10 LOCATION=USE_DB_RECOVERY_FILE_DEST

db_create_online_log_dest_1 +ASM_FRA

db_create_online_log_dest_2 +ASM_DATA

db_recovery_file_dest +ASM_FRA

No logfiles have IS_RECOVERY_DEST_FILE as YES

GROUP# THREAD# Size (MB) MEMBERS MEMBER IS_RECOVERY_DEST_FILE

------ ------- --------- --------------- ---------------------------------------------------------------------- ---------------------

1 1 50 2 +ASM_FRA/tstdd/onlinelog/group_1.17013.827665199 NO

1 1 50 2 +ASM_DATA/tstdd/onlinelog/group_1.2791.830683141 NO

2 1 50 1 +ASM_FRA/tstdd/onlinelog/group_2.17014.827665201 NO

3 2 50 1 +ASM_FRA/tstdd/onlinelog/group_3.9655.827667155 NO

4 2 50 1 +ASM_FRA/tstdd/onlinelog/group_4.8880.827667155 NO

5 3 50 1 +ASM_FRA/tstdd/onlinelog/group_5.17015.827667153 NO

6 3 50 1 +ASM_FRA/tstdd/onlinelog/group_6.17018.827667155 NO

7 1 50 2 +ASM_FRA/tstdd/onlinelog/group_7.8821.830687993 NO

7 1 50 2 +ASM_DATA/tstdd/onlinelog/group_7.2425.830687997 NO

8 1 50 2 +ASM_DATA/tstdd/onlinelog/group_8.2072.830690847 NO

8 1 50 2 +ASM_FRA/tstdd/onlinelog/group_8.8810.830690845 NO

Add a logfile with FRA configured and name not specified, IS_RECOVERY_DEST_FILE still NO.

alter database add logfile group 9 size 52428800;

GROUP# THREAD# Size (MB) MEMBERS MEMBER IS_RECOVERY_DEST_FILE

------ ------- --------- --------------- ---------------------------------------------------------------------- ----------------------

1 1 50 2 +ASM_FRA/tstdd/onlinelog/group_1.17013.827665199 NO

1 1 50 2 +ASM_DATA/tstdd/onlinelog/group_1.2791.830683141 NO

2 1 50 1 +ASM_FRA/tstdd/onlinelog/group_2.17014.827665201 NO

3 2 50 1 +ASM_FRA/tstdd/onlinelog/group_3.9655.827667155 NO

4 2 50 1 +ASM_FRA/tstdd/onlinelog/group_4.8880.827667155 NO

5 3 50 1 +ASM_FRA/tstdd/onlinelog/group_5.17015.827667153 NO

6 3 50 1 +ASM_FRA/tstdd/onlinelog/group_6.17018.827667155 NO

7 1 50 2 +ASM_DATA/tstdd/onlinelog/group_7.2425.830687997 NO

7 1 50 2 +ASM_FRA/tstdd/onlinelog/group_7.8821.830687993 NO

8 1 50 2 +ASM_FRA/tstdd/onlinelog/group_8.8810.830690845 NO

8 1 50 2 +ASM_DATA/tstdd/onlinelog/group_8.2072.830690847 NO

9 1 50 2 +ASM_FRA/tstdd/onlinelog/group_9.7697.830855971 NO

9 1 50 2 +ASM_DATA/tstdd/onlinelog/group_9.2623.830855971 NO

Perhaps this is not a problem, however I'm trying to understand why this would be so.

Also, what are the impacts of this value as NO? Such as BACKUP RECOVERY AREA, used space calculation of FRA.

I'm sure there are things I'm missing.

Any insights are appreciated.

Sherrie

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2013

Added on Nov 7 2013

#performance-availability, #recovery-manager-rman, #rman

4 comments

1,881 views