Skip to main content
Question

Oracle RMAN Fast Recovery ?

  • September 9, 2025
  • 2 replies
  • 40 views

Forum|alt.badge.img+7

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-->

2 replies

maheshmuz
Hero (Partner)
Forum|alt.badge.img+9
  • Hero (Partner)
  • September 10, 2025

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.


Forum|alt.badge.img+17
  • Superhero (Partner)
  • September 10, 2025

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