How to resize db_recovery_file_dest_size in Oracle database #oracle #oracledbaonlinetraining #oradba

*****************************************************************************************
* How to resize db_recovery_file_dest_size in Oracle database *
*****************************************************************************************

DB_RECOVERY_FILE_DEST_SIZE specifies (in bytes) the hard limit on the total space to be used by target database recovery files created in the flash recovery area.

Steps: ---
1. Login to your Oracle Database. (sqlplus / as sysdba) from command line.
2. run the below commands.

#Check Recovery File Dest Size
SQL⇒ set lines 100
SQL⇒ col name format a60

SQL⇒ select name, floor(space_limit / 1024 / 1024/1024) "Size GB", ceil(space_used / 1024 / 1024/1024) "Used GB" from v$recovery_file_dest order by name;

NAME Size GB Used GB
------------------------------------------------------------ ----------
D:\app\Chirag\flash_recovery_area
3 1
Here size is 3 GB and Used size is 1GB.

## Now Resize the DB_RECOVERY_FILE_DEST_SIZE
SQL⇒ ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 4G SCOPE=BOTH SID='*';

System altered.

### Again let me check the recover_file_dest_size;
SQL⇒ select name, floor(space_limit / 1024 / 1024/1024) "Size GB", ceil(space_used / 1024 / 1024/1024) "Used GB" from v$recovery_file_dest order by name;

NAME
Size GB Used GB
------------------------------------------------------------ ---------- ----------
D:\app\Chirag\flash_recovery_area
4 1

##now new size is 4 GB.

If your are writing scope=Both then no need to restart the server.

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags
#ChiragTutorial
#ChiragsTutorial
#Chirags
#Chirag
#ChittRanjanMahto
#ChiragMahto
#OracleDatabase
#OracleDBA
#OracleBackup
#OracleRecovery
#OracleRMAN
#OracleTutorial
#OracleTraining
#OracleAdministration
#OracleStorage
#OraclePerformance
#OracleOptimization
#OracleDatabaseSize
#OracleDBRecovery
#OracleDBBackup
#OracleDBManagement
#OracleDBAExpert
#OracleDBATips
#OracleDBATutorials
#OracleDBATraining
#OracleDBACommunity
#OracleDBAResources
#OracleDBAInsights
#OracleDBAHelp
#OracleDBAForum
#OracleDBAGroup
#OracleDBAExperts
#OracleDBAAdvice
#OracleDBAGuide
#OracleDBATechniques
#OracleDBAStrategies
#OracleDBABestPractices
#OracleDBATools
#OracleDBAUtilities
#OracleDBAScripts
#OracleDBACommands
#OracleDBAQueries
#OracleDBAFunctions
#OracleDBAProcedures
#OracleDBAPackages
#OracleDBATrigger
#OracleDBAViews
#OracleDBAIndexes
#OracleDBAConstraints
#OracleDBAKeys
#OracleDBASequences
#OracleDBASynonyms
#OracleDBALinks
#OracleDBAClusters
#OracleDBAPartitions
#OracleDBADatafiles
#OracleDBATablespaces
#OracleDBAControlFiles
#OracleDBALogFiles
#OracleDBAArchivelogs
#OracleDBAFlashback
#OracleDBAUndo
#OracleDBARedo
#OracleDBADataGuard
#OracleDBAStandby
#OracleDBAReplication
#OracleDBACloning
#OracleDBAPatching
#OracleDBAUpgrades
#OracleDBAMigration
#OracleDBAInstallation
#OracleDBAConfiguration
#OracleDBAMonitoring
#OracleDBATroubleshooting
#OracleDBADiagnostics
#OracleDBAAlerts
#OracleDBAJobs
#OracleDBAScheduler
#OracleDBAResourceManager
#OracleDBAASM
#OracleDBARAC
#OracleDBAExadata
#OracleDBACloud
#OracleDBAAWS
#OracleDBAAzure
#OracleDBAGCP
#OracleDB