Oracle11gORA-03113 fault, rebuilding Control File

In Windows, Oracle 11g cannot be started normally after a shutdown and cannot be started to the mount state:

ORA-03113: end-of-file on communication channel

Process ID: 4276

Session ID: 1286 Serial number: 2

Find the trc file of the corresponding number in the D: \ app \ Administrator \ diag \ rdbms \ wind \ trace directory and find the following prompt:

Error: kccpb_sanity_check_2

Control filesequence number mismatch!

Fhcsq: 168754 bhcsq: 168757 cfn 0

Therefore, it is confirmed that the control file issue is caused.

First, exit SQLPLUS and back up the entire directory where the library file is located.

Then try the restore control file:

C: \> rman target/

RMAN> shutdownimmediate

RMAN> startupnomount

RMAN> restorecontrolfile from 'd: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ CONTROL03_WIND.CTL ';

After completing the preceding operations, go back to SQLPLUS and start the database.

You can confirm that all the control files are faulty. Because the library files exist, you have decided to recreate the control file:

C: \> sqlplus/nolog

SQL> conn/as sysdba

SQL> shutdown immediate

SQL> startup nomount

SQL> CREATE CONTROLFILE REUSE DATABASE "WIND" NORESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXDATAFILES 100

MAXINSTANCES 2

# MAXLOGHISTORY 453

LOGFILE

GROUP 1 'd: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDREDO01.LOG 'size 50 M,

GROUP 2 'd: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDREDO02.LOG 'size 50 M,

GROUP 3 'd: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDREDO03.LOG 'size 50 M

DATAFILE

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDBLOBS01.DBF ',

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDINDEX01.DBF ',

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDSYSAUX01.DBF ',

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDSYSTEM01.DBF ',

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDUNDOTBS01.DBF ',

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDUSERS01.DBF ',

'D: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDWCAUDIT01.DBF'

Character set ZHS16GBK;

SQL> RECOVER DATABASE;

SQL> alter database open;

SQL> alter tablespace temp

Add tmpfile 'd: \ ptc \ Windchill_10.0 \ ocu \ oradata \ wind \ WINDTEMP01.DBF'

SIZE 200 m reuse autoextend on maxsize 5G;

After completing the preceding steps, restart the database.