Oracle Startup Issues ORA-16038


ORA-16038: log 1 sequence# 244 cannot be archived 
ORA-19809: limit exceeded for recovery files 
ORA-00312: online log 1 thread 1 

There is a possibility to encounter this issue in oracle database and when this happens you wont be able to open the database. you will be getting this once the db_recovery_file_dest_size value gets exceeded. 



However you can fix this one by increasing the db_recovery_file_dest_size  or by clearing the obsolete files. To increase the db_recovery_file_dest_size  size use the following steps. 



Comments

Post a Comment

Leave a message

Popular posts from this blog

Failed to open disk scsi0:0: Unsupported and/or invalid disk type 7" error when trying to power on a VM on ESXi

If you face this error message when powering on a Virtual host, try the below steps to get over it. Go to your disk file location. and type..   vmkfstools -i nagiosxi.vmdk -d zeroedthick nagiosxi1.vmdk and then delete the original .vmdk file (Mine : nagiosxi.vmdk) and rename the newly created file (Mine: nagiosxi1.vmdk) as the name of the original file (Mine : nagiosxi.vmdk) Good luck.....................
Read more

Installation of MySQL Enterprise Server Manager

Today I had to install mysql enterprise monitor with zero knowledge. So after hours of reading and testing found another great day at workplace. for this solution we need to follow the below steps. 1) Download and install a Service Manager. 2) Open the Enterprise Dashboard in your browser and go through the first-time setup screen that    appears. 3) Download and install an Agent on each machine to be monitor. 4) Configuration of the Agent to connect to the server monitor and to the database. Task 1 ===== So I started installation of the enterprise monitor system management server. Unzip to get the installation files. ======================== [root@test1 intallation]# unzip V32221-01.zip Archive:  V32221-01.zip   inflating: mysqlmonitor-2.3.10.2153-linux-x86_64-installer.bin    inflating: mysqlmonitor-2.3.10.2153-linux-x86_64-update-installer.bin    inflating: AdvisorScript-Platinum-2.3.10.2153.jar    infla...
Read more