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
(Question: What 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