Skip to main content

Hello,

 

We are in a IFS Cloud Remote environnement and we want to secure the IFS database in Oracle .
Oracle has a tool called RMAN, and can restore a database using a FLASHBACK
!--scriptorstartfragment-->

RUN {

  SET UNTIL TIME "TO_DATE('2025-09-09 14:00:00', 'YYYY-MM-DD HH24:MI:SS')";

  FLASHBACK DATABASE TO TIME "TO_DATE('2025-09-09 14:00:00', 'YYYY-MM-DD HH24:MI:SS')";

  ...

}

To be able to do this: the option (FRA – Flash Recovery Area).should be activated. But IFS official install documentation does not recommend to use FRA

https://docs.ifs.com/techdocs/24R1/070_remote_deploy/010_installing_fresh_system/010_planning_installation/010_storage_tier_considerations/010_oracle_db_19c/#flash_recovery_area

!--scriptorendfragment-->

In my experience if the FRA is properly configured and monitored it should not cause issues in production environments. With the right sizing and housekeeping it can be a reliable option.

All the time we configure this and I haven’t seen any issues related to FRA.

Terms & ConditionsCookie settings