Skip to Content
0
Former Member
May 01, 2014 at 10:27 AM

DB shutdown

115 Views

Hi Gurus,

While doing some house keeping, accidentally /oracle/SID/saparch/cntrl/cntrlSID.dbf got moved / deleted.

We were not aware of this until after 3 days we were informed by the backoffice team regarding the failed backups.

Upon investigation we found out that the said control file was missing and thus the backups were failing

So we copied the control file from ORIGLOG and kept it in SAPARCH !!

After copying this file, there was an usual system checkpoint and then the DB was shutdown

Now the alert file has no details of the instance shutdown but one of the trace file mentions that after the checkpoint, Oracle found out that the SAPARCH control file's version was different than ORIGLOG's control and thus it terminated the instance

Alert log mentions : Apr 30 11:00:49 2014 opiodr aborting process unknown ospid (15521) as a result of ORA-1092

TRC file mentions :

Error: kccchb_6

Control file sequence number mismatch!

fhgcsq: 890352 high_i: 0

SGA csq: 890361 lseqno: 890352 low_i: 0 hseqno: 890352

*** 2014-04-30 11:00:49.420

USER (ospid: 22482): terminating the instance

My question over here is, does Oracle shutdown the DB if it notices mismatched control file in checkpoint

OR something else has caused the shutdown

R..../-