How to Increase, Decrease or Resize FRA(Flash Recovery Area) in Oracle Database?

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Above two links will help you to configure and check the usage of the Flash Recovery Area (FRA) in Oracle. Now here is the method to resize the FRA in oracle database.
You can use below mentioned commands to see the already allocated space for the FRA.

1.     Connect to SQL*Plus as sysdba
SQL> show parmeter DB_RECOVERY_FILE_DEST_SIZE
You can use following SQL to resize the FRA size
2.     Connect to SQL*Plus as sysdba
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 250G SCOPE=BOTH SID='*';
Where 250G is the size of the flash recovery area size, SCOPE to BOTH will make the change to both memory and server parameter file, SID=’*’ has no effect in the single instance database where as in RAC database it causes the change to take effect across all instance.

_____________________________________________________________________________________________________________________

A visitor from Barcelona viewed 'Data Pump IMPDP TABLE_EXISTS_ACTION = APPEND, REPL' 2 mins ago
A visitor from Navi mumbai viewed 'Commands to Delete Old Aged Oracle Trace Files(.tr' 9 mins ago
A visitor from Belovo viewed 'How to disable all constraints on a table or schem' 30 mins ago
A visitor from Pune viewed 'SQL Query to Find Out the Locked Objects and Type ' 2 hrs 52 mins ago
A visitor from Wyoming viewed 'ORA-00059: maximum number of DB_FILES exceeded - F' 3 hrs 46 mins ago

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-25 All Rights Reserved | Site Map | Contact | Disclaimer