The Flash recovery area(FRA) is an important location. It stores archivelog, flashback logs, backups etc. Here in this post, we will see how to check fra size in oracle, flash recovery area usage query, and how to increase fra size in oracle
how to check fra size in oracle
select * from v$recovery_file_dest;
flash recovery area usage query
set linesize 200 trim pool on
col name form a72
select * from v$flash_recovery_area_usage;
how to increase fra size in oracle
alter system set DB_RECOVERY_FILE_DEST_SIZE=<new size> scope=both;
How to check fra location in oracle
sqlplus / as sysdba
show parameter DB_RECOVERY_FILE_DEST
How to change FRA location in oracle
sqlplus / as sysdba show parameter DB_RECOVERY_FILE_DEST alter system set db_recovery_file_dest='<new location>' scope=both;
Now the database will start generating the files in the new location. If the flashback is set to ON, then flashback logs will keep generating at the old location. We can enable and disable flashback to generate the flashback logs on the new location
Hope you like this short and quick post on how to check fra size in oracle
Related Articles
oracle create tablespace: This article on how to create tablespace in oracle, various characteristics associated with it and different create tablespace statements
ORA-01652: ORA-01652 error usually because when the tablespace does not have free space in Permanent and Temporary tablespace in oracle database. Check out how to resolve it
shrink datafile in Oracle: Check out how to shrink the datafile and reclaim space on the filesystem. How to resolve ORA-03297
Oracle database administration tutorial: This lists all the Oracle DBA-related stuff. Very helpful for administration
how to change default tablespace in oracle: Default tablespace is the tablespace where the objects are created when no tablespace name is specified by users. Find out how to check default tablespace
How to check temp tablespace in Oracle: This article is about temp tablespace in Oracle, resize the tempfile, drop the temp file, find the temp usage by Session
alter tablespace add datafile: Check out this post on How to add a datafile to tablespace in Oracle, add tempfile to the temporary tablespace, how to add datafile in ASM
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup005.htm
Leave a Reply