1.

What All You Can Store In Flash Recovery Area(fra)? Can One Fra Directory Be Used For More Than One Database?

Answer»

Oracle can STORE different kind of files under FRA:

  • backupset: for RMAN regular backups.
  • datafile: for RMAN image copies.
  • autobackup: for control file autobackups.
  • flashback: If your database runs in flashback mode, you will see flashback LOGS in this subdirectory.
  • archivelog: for Archived REDO logs
  • controlfile: The control file, if configured to go to the flash recovery area.
  • onlinelog: ONLINE redo logs can also be MADE to go to the flash recovery area

You can use the same flash recovery area for as many databases as you want. The RMAN backup process will create a subdirectory called <SID_NAME>, the same name as the database you are backing up.

Oracle can store different kind of files under FRA:

You can use the same flash recovery area for as many databases as you want. The RMAN backup process will create a subdirectory called <SID_NAME>, the same name as the database you are backing up.


Discussion

No Comment Found

Related InterviewSolutions