Oracle DBA Tutorial 8 - How to resize db_recovery_file_dest_size in Oracle database
[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
Смотрите видео Oracle DBA Tutorial 8 - How to resize db_recovery_file_dest_size in Oracle database онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chirags Tutorial 05 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 446 раз и оно понравилось 6 людям.