DB_RECOVERY_FILE_DEST_SIZE automatically decrease size after shutdown

by Ramiz Tariq   Last Updated July 12, 2019 05:06 AM

I am using oracle database 11gR2.

I increased db_recovery_file_dest size with alter command

alter system set db_recovery_file_dest_size=60G scope=both;

When I shutdown database and again open database then db_recovery_file_dest_size automatically changed to default size 10G.

Now I am getting error

the database is not available due to the following conditions stuck archiver

How to solve this error



Related Questions


Updated February 05, 2018 08:06 AM

Updated July 03, 2016 08:02 AM

Updated February 24, 2017 12:06 PM

Updated August 28, 2017 14:06 PM

Updated August 02, 2018 06:06 AM