![]() ![]() What if FRA is Full?įirstly if you are aspiring to become a DBA then you must learn that the capacity planning must always be performed before backup and recovery planning. Be it on a NAS drive or on a TAPE Cartridge. You should never loose the contents of this directory, so make sure to place it at the safest position in your production environment. If your production environment has a dedicated backup server then you must consider creating this directory there. Ideally you should be creating your Oracle FRA on a separate storage device. Since all the backups are stored in a centralized location thus database server doesn’t have to waste time in finding them which makes the recovery much faster.īest Location For The Fast Recovery Area?.Since FRA gives you a centralized location for all your backups thus it’s easier to manage them.Fast Recovery Area gives you the ability to Flashback the database.There are multiple advantages of Configuring Fast Recovery Area, such as – This is because Fast Recovery area is an Oracle Managed centralized storage location for backup and recovery files. ![]() Once you have configured the FRA then Oracle Server takes care of it. Who Takes Care of Fast Recovery Area (FRA)? In short you will find the backups of almost all the files and directories in the Fast Recovery Area. RMAN Backup Set – logical entities produced by the RMAN BACKUP command.Image Copies – Exact byte-for-byte copies of all the files of the target database.Here is the list of all the contents that get saved in Fast Recovery Area by Oracle Recovery Manager (RMAN) – You can see all these files in the FRA after you perform the first backup of your database. What does Fast Recovery Area Contain?įast recovery area contains all the necessary files that needs to be backed up for the smooth running of your database. But this happens only if FRA is correctly configured. When you run RMAN BACKUP command without specifying a backup destination, RMAN saves the backup in the Fast recovery area. It also makes things a lot easier to handle for Oracle server as well as for a DBA. Having a dedicated location for all the backups keep things organized. This location is managed by Oracle Database server. What is Oracle Fast Recovery Area?įRA is nothing but a location somewhere on your disk where RMAN creates the copy of all the files of your database during backup. But you can call it either fast or flash, whatever you feel comfortable with. Therefore, now a days its more commonly known as fast recovery area. But after that Oracle decided to change it from ‘flash’ to ‘fast recovery area’. )Īctually, until Oracle 11gR1 Oracle FRA was known as Flash recovery area. ![]() (I won’t blame them because sometimes I too use these terms interchangeably. Some books refer to Oracle FRA as fast recovery area whereas some refer to it as flash recovery area which creates confusion. What does FRA stands for? Is it Fast recovery area or is it Flash recovery area? Fast Recovery Area or Flash Recovery Area?īefore I tell you what Oracle FRA is let me first clear the confusion about its name. ALTER SYSTEM DB RECOVERY FILE DEST SIZE HOW TOHow to configure Oracle Fast Recovery Area by Manish Sharma(YouTube Video) Suggested Readingīefore you start learning about FRA I would suggest you to check out the previous blog which is a quick introduction to Oracle RMAN. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |