Skip to Main Content

Oracle Database Discussions

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!

Flash Recovery Area (FRA)

443104May 11 2009 — edited May 12 2009
Dear Experts,

OS: IBM - AIX 6.1
DB: Oracle 10g Release 2 (10.2.0.4)
Non-RAC database

We are in the process of implementing FRA in our mission critical database and I would like to take your suggestions in this regards.

Background
We have datafiles, logfiles, controlfiles, and archived redo files configured on cooked file system. Also, RMAN backup directly goes to tape.
We have data guard with physical standby database configured in MAXIMUM PERFORMANCE mode.

Reason for going with FRA
We would like to Flashback Database (primary db) in case we failover to the standby database. So, that we don't have to take a backup of new primary
and restore to original and make it standby database, later switchover to original primary.

When using Flashback database feature, we can simply go back in time and resync it as a standby database.

FRA Background
FRA may contain the following:
• Datafile copies
• Control file autobackups
• Archived redo log files
• Online redo log files
• Current control files
• RMAN files
• Flashback logs

Concerns
We don't want to Oracle to use FRA for:
• Datafile copies
• Archived redo log files
• Online redo log files
• RMAN files

What we need is to maintain only the Flashback logs. To use them in case we failover to the standby.

Could any one please help me, on how to direct Oracle to do this. I did read doc and also read much on FRA on the google. Probably, not hitting the right page or not reading the right page or not understanding the right contents.

Can you also share your experiences with FRA like bugs, performance, ....


Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2009
Added on May 11 2009
8 comments
1,384 views