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-...

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 D...