Oracle DBA Tutorial 8 - How to resize db_recovery_file_dest_size in Oracle database

Published: 05 June 2022
on channel: Chirags Tutorial

446

[email protected] Chirag's Oracle DBA Tutorial https://www.chirags.in
*****************************************************************************************
* 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:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :
https://www.chirags.in/tutorials/orac...

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

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags

Watch video Oracle DBA Tutorial 8 - How to resize db_recovery_file_dest_size in Oracle database online without registration, duration hours minute second in high quality. This video was added by user Chirags Tutorial 05 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 446 once and liked it 6 people.

4,106

141