Skip to main content
Solved

Oracle RMAN Fast Recovery ?

  • Sep 9, 2025 2:41 PM UTC
  • 2 replies
  • 92 views

Forum|alt.badge.img+8

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

Best answer by knepiosko

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

View original

2 replies

maheshmuz
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • Sep 10, 2025 12:44 PM UTC

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)
  • Answer
  • Sep 10, 2025 1:20 PM UTC

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