Oracle RMAN 11g Backup and Recovery- P3: Oracle, yet another edition of our RMAN backup and recovery book has hit the shelves! Oracle Database 11g has proven to be quite the release to be sure. RMAN has new functionality and whizbang new features that improve an already awesome product. RMAN has certainly evolved over the years, as anyone who started working with it in Oracle version 8 can attest to. | 68 Part II Setup Principles and Practices the database coming to a complete halt. In this case we used the alter system command to increase the amount of space allocated to the FRA. SQL select reason from dba outstanding alerts REASON db recovery file dest size of 524288000 bytes is used and has 0 remaining bytes available. SQL alter system set db recovery file dest size 800m The V RECOVERY_FILE_DEST View The V RECOVERY_FILE_DEST view provides an overview of the FRA that is defined in your database. It provides the size that the FRA is configured for the amount of space used how much space can be reclaimed and the number of files in the FRA. In the following example we can see that the increase in space to the FRA to 800MB has been recorded SPACE_LIMIT . However we still have used too much space SPACE_ USED and the FRA is still full. SQL select from v recovery file dest NAME SPACE LIMIT SPACE USED SPACE RECLAIMABLE NUMBER OF FILES c oracle product flash recovery area 838 860 800 1 057 116 672 338 081 280 11 One nice thing about Oracle is that it manages the FRA space for us as much as it can and if there is reclaimable space available it will free it as required. Note that in the previous query Oracle indicated we were out of FRA space. Did you notice the SPACE_RECLAIMABLE column though This column indicates that there is reclaimable space available. This is space that is taken up by archived redo logs or backup set pieces that are no longer needed by virtue of whatever retention criteria we have selected we will discuss retention criteria and setting those criteria later in this chapter . When Oracle needs space in the FRA say for example we force a log switch it will remove any files that are reclaimable and free up space. In the next query we can see that this has occurred. After we ran the previous query that indicated we were out of FRA space we forced a log switch. This caused Oracle to reclaim space from the FRA for reuse and it then was able .
