Month: May 2020

Oracle startup failure with ORA-00704 ORA-00604

Yesterday I was asked by a colleague to look into a test system. There was data deleted through the application. He tried to restore it with from a database backup 2 days ago with no luck. He seemed to be struggling with recover -- either getting "ORA-16433: The database or pluggable database must be opened … Continue reading Oracle startup failure with ORA-00704 ORA-00604

Large size of trace files from MMON

While I was doing housekeeping working to prepare ODA upgrade, I noticed some large trace files for ASM and MGMTDB databases as showed below: [grid@joeoda001 trace]$ du -sh *gen* *mmon* 1.6G +ASM1_gen0_20481.trc 250M +ASM1_gen0_20481.trm 1.5G +ASM1_mmon_20571.trc 243M +ASM1_mmon_20571.trm [grid@joeoda001 grid]$ du -sh diag/rdbms/_mgmtdb/-MGMTDB/trace/*|grep -v K 22M diag/rdbms/_mgmtdb/-MGMTDB/trace/alert_-MGMTDB.log 161M diag/rdbms/_mgmtdb/-MGMTDB/trace/-MGMTDB_dbrm_23332.trc 16M diag/rdbms/_mgmtdb/-MGMTDB/trace/-MGMTDB_dbrm_23332.trm 1.7G diag/rdbms/_mgmtdb/-MGMTDB/trace/-MGMTDB_gen0_23224.trc 240M diag/rdbms/_mgmtdb/-MGMTDB/trace/-MGMTDB_gen0_23224.trm … Continue reading Large size of trace files from MMON

A small trick to handle files prefixed with a specify character in BASH

From time to time, we might see some files on Linux which have strange leading characters. For example, a leading "-" dash or a leading "+" plus sign. Depending on which operations (which commands) you take, you may have different ways to handle those files -- putting file name in a single or double quotes, … Continue reading A small trick to handle files prefixed with a specify character in BASH