Monday, August 13, 2018

oracle DB crashed when opened after the full restore



Issue:
we have got the below issue  after opening the database from restore and it crashed the instance and throw the below error.
Tue Aug 07 22:47:12 2018
SMON: enabling cache recovery
Errors in file /apporadb1/oracle/product/11.2.0/log/diag/rdbms/oradb1/oradb1/trace/oradb1_ora_25952386.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Errors in file /apporadb1/oracle/product/11.2.0/log/diag/rdbms/oradb1/oradb1/trace/oradb1_ora_25952386.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER (ospid: 25952386): terminating the instance due to error 704
Instance terminated by USER, pid = 25952386
ORA-1092 signalled during: alter database open resetlogs...
opiodr aborting process unknown ospid (25952386) as a result of ORA-1092

Root cause:after checking this error and looks like  Db asking for upgrade and  we noticed the source database was 11.2.0 and target would be 11.2.0.4 .so in order to open the database ,we  just need to upgrade the database  to 11.2.0.4.

Solution:
1)startup the DB in upgrade mode
2)run the catupgrd.sql
3)run the utlrp.sql
4)do the sanity check on the database again.



1 comment:

  1. Within plug blisss, you wit betide assisted for you to floral your bears, dismiss contain booklet, reconnoiter thesis, theses, lashs, preside upgrade bridging, rinse activity, overcharge achievement synchronouss verys versed process at a cheap interest. business Marketing Services

    ReplyDelete