Solution : https://service.sap.com/sap/support/notes/966117 (SAP Service marketplace login required)
Summary :
This SAP Note dives into the operational dynamics and settings for Oracle Flashback Database within SAP systems, applicable primarily for Oracle versions 10.2 and 11.2. It highlights advancements in version 11.2, such as on-the-fly activation/deactivation of Flashback and the creation of guaranteed restore points without requiring a database restart. The note also underscores the necessity of a well-thought-out recovery strategy to ensure data consistency across system landscapes when leveraging Flashback, given its impactful nature on operations. Moreover, it discusses the architectural essentials of Flashback Database, including its logging mechanism and performance considerations. The importance of having the database in ARCHIVELOG mode and a properly configured Fast Recovery Area are stressed, alongside the integration with SAP BR*Tools for streamlined Flashback operations.
Key words :
terms db_flashback_retention_targetv$flashback_database_logv$flashback_database_statv$restore_pointv$databaseterminologyscn = system change numberpitr = point-, activate normal flashback loggingsql> shutdown immediatesql> startup mountsql> alter database flashback, rman target /rman> shutdown immediaterman> startup mount2, -timeflashback logging = writing flashback logsflashback window = time interval, sap upgrade database upgrade real application testing, sql> create restore point grp_before_upgr guarantee flashback database, flashback retention = 5 hourssql> alter system set db_flashback_retention_target=300, flashback time window/flashback database windowthe view, datafile shrink drop tablespace drop datafile, define flashback retentionthe parameter db_flashback_retention_target specifies
Related Notes :
| 1125923 | Support for Oracle database flashback in BR*Tools |
| 966073 | Oracle Flash Recovery Area/Fast Recovery Area |
| 937492 | FAQ: Oracle Flashback |
| 828268 | Oracle Database 10g: New functions |
| 434647 | Point-in-time recovery in an SAP system group |
| 434645 | Point-in-time recovery: What must I be aware of? |
| 105047 | Support for Oracle functions in the SAP environment |