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!

Setup the FRA

scottjhnJun 22 2014 — edited Jun 23 2014

On Oracle 11g r2 Linux OS.

Data files controlled by ASM (+DATA diskgroup)

Fast Recovery Area (cooked file system on a separate disk): /u01/oradata/fast_recovery_area

Archiving enabled

Automatic Archive (no other destination for archiving so that all the archived logs will go to /u01/oradata/fast_recovery_area

(This is what I did:

ALTER SYSTEM SET db_recovery_file_dest_size = 200G SCOPE = BOTH;

ALTER SYSTEM set DB_recovery_file_dest = '/u01/oradata/fast_recovery_area' scope=BOTH;

ALTER SYSTEM SET db_flashback_retention_target = 1440 SCOPE = BOTH;

commit;

)

Multiplex Redo Logs and Control Files: (1) /u01/oradata/fast_recovery_area     (2)   +DATA

(QuestionWhat script should I use to enable such multiplxing?)

The goal is to create a FRA on a separate disk (different location from the +DATA diskgroup)

Then the system automatically puts the following files on the FRA:

archived logs

multiplexed redo logs and control files

Finally use RMAN to shcedule the backup of the data files to the FRA (/u01/oradata/fast_recovery_area).

Please have a review of my setting and see if it would work, or some extra work I need to do.

Thanks

Scott

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2014
Added on Jun 22 2014
2 comments
1,687 views