Solution : https://service.sap.com/sap/support/notes/966073 (SAP Service marketplace login required)
Summary :
This SAP Note outlines the setup and management of the Fast Recovery Area (FRA) for databases utilizing the Flashback feature with SAP BR*Tools, applicable to Oracle versions 10.2 and 11.2. The note details configuration processes including parameter adjustments and space requirements for FRA, which is integral for optimal backup and recovery performances. It emphasizes replacing incompatible parameters like LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_1 and LOG_ARCHIVE_DEST_2. The use of FRA is recommended for storing Flashback logs only and ensures that during high load, archive logs are managed effectively, aligning with SAP's backup strategies facilitated through BR*Tools. Proper setting of FRA parameters can significantly enhance database recovery capabilities.
Key words :
current control file online logs/archived logs flashback logs control file autobackups/control file copies datafile copies/backup pieces, sql> archive log listdatabase log mode archive modeautomatic archival enabledarchive destination use_db_recovery_file_destoldest online log sequence 132next log sequence, delete log_archive_dest parameter sql> alter system reset log_archive_dest scope = spfile sid = ' ', archive log status/check parameter sql> archive log listsql> col, set log_archive_dest_1sql> alter system set log_archive_dest_1 = 'location=<path>' scope = spfile, fast recovery areasql> alter system reset db_recovery_file_dest scope=spfile sid=' ', sql> alter system reset log_archive_duplex_dest scope = spfile sid = ' ', set fra parametersql> alter system set db_recovery_file_dest_size = <db_recovery_file_dest_size>, fast recovery areasql> alter system set db_recovery_file_dest='<db_recovery_file_dest>', sql> alter system set db_recovery_file_dest = '<db_recovery_file_dest>'
Related Notes :
| 1125923 | Support for Oracle database flashback in BR*Tools |
| 966117 | Oracle Flashback Database technology |
| 828268 | Oracle Database 10g: New functions |