Oracle - SQL - MySQL DBA - Life Long Learning Experience

Today Morning I thought i should do something different than usual :) . Few Basic Steps required to install and configure MySQL . Please follow the steps as outlined. 1)  Install RPM's [root@kphqdbrm02ord bundle]# rpm -Uvh mysql-community-common-5.7.19-1.el7.x86_64.rpm mysql-community-server-5.7.19-1.el7.x86_64.rpm warning: mysql-community-common-5.7.19-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing...                          ################################# [100%] Updating / installing...    1:mysql-community-common-5.7.19-1.e################################# [ 25%]    2:mysql-community-server-5.7.19-1.e################################# [ 50%] Cleaning up / removing...    3:mysql-community-server-5.7.16-1.e################################# [ 75%]    4:mysql-community-common-5.7.16-1.e################################# [100%] [root@kphqdbrm02ord bundle]# rpm -Uvh mysql-community-client-5.7.19-1.el7.x86_64.rpm warning: mysql-commu

Today Morning one of my Test database (VM) was playing up . This came to light when the esxi Host was down due to power issue bringing all the guest down .  After the Host Server  was sorted and we started bringing individual  guest servers up but one of Test VM was struggling . On diagnosing it appeared that the  flash recovery area was filled 99.99% and there was no room for online log to archive . Error Encountered during the start of the instance : SQL> startup ORACLE instance started. Total System Global Area 1837244416 bytes Fixed Size                  2851720 bytes Variable Size             553651320 bytes Database Buffers         1275068416 bytes Redo Buffers                5672960 bytes Database mounted. ORA-03113: end-of-file on communication channel Process ID: 4471 Session ID: 1 Serial number: 5 Error as shown from Log file : ARC1: Error 19809 Creating archive log file to '/backup/fast_recovery_area/TEST12C1/archivelog/2018_06_19/o1_mf_1_210_%u_.ar