Groovy DBA

select * from ps_maintenance_log where update_id='34892392';

 >mysql -uroot -p -h 10.40.22.51 -P 3306 --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem Permission of the certs: mysqladm-myhvrtstdb601.tmw.com::/usr/opt/app/mysql/home/certs>ls -lrt -rw-r--r-- 1 mysqladm dba 1678 Feb  6 14:29 client-key_srtproddb601.pem -rw-r--r-- 1 mysqladm dba 1305 Feb  6 14:29 client-cert_srtproddb601.pem -rw-r--r-- 1 mysqladm dba 1272 Feb  6 14:29 server-ca_srtproddb601.pem

H:\>systeminfo | find /i  "Boot Time" System Boot Time:          11/19/2022, 12:27:19 AM H:\>

 SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            /usr/opt/app/oracle/admin/hrcnv1/arch Oldest online log sequence     367 Next log sequence to archive   388 Current log sequence           388 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 4831835720 bytes Fixed Size                  8906312 bytes Variable Size            3976200192 bytes Database Buffers          838860800 bytes Redo Buffers                7868416 bytes Database mounted. SQL> alter database noarchivelog; Database alte...