Не стартует база Ora-00227 и др. : Oracle

Восстановил из своей копии.
Запуск с 02.ctl
Fri Oct 02 11:55:25 2009
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
Fri Oct 02 11:55:26 2009
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Oct 02 11:55:26 2009
ARC0: Archival started
Fri Oct 02 11:55:26 2009
alter database mount exclusive
Fri Oct 02 11:55:30 2009
Successful mount of redo thread 1, with mount id 3021922162.
Fri Oct 02 11:55:30 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 02 11:55:30 2009
alter database open
Fri Oct 02 11:55:30 2009
Rolling back half complete log switch of thread 1
***
Corrupt block relative dba: 0x0000005f file=0. blocknum=95.
Bad header found during controlfile block read
Data in bad block - type:255. format:255. rdba:0xffffffff
last change scn:0xffff.ffffffff seq:0xff flg:0xff
consistancy value in tail 0xffffffff
check value in block header: 0xffff, calculated check value: 0x0
spare1:0xff, spare2:0xff, spare2:0xffff
LGWR: terminating instance due to error 227

Запуск с 03.ctl
Fri Oct 02 11:59:02 2009
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
Fri Oct 02 11:59:02 2009
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Oct 02 11:59:02 2009
ARC0: Archival started
Fri Oct 02 11:59:02 2009
alter database mount exclusive
Fri Oct 02 11:59:06 2009
Successful mount of redo thread 1, with mount id 3021889354.
Fri Oct 02 11:59:06 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 02 11:59:06 2009
alter database open
Fri Oct 02 11:59:06 2009
Errors in file d:\Oracle\admin\DBELENA\bdump\dbelenaLGWR.TRC:
ORA-00338: log 4 of thread 1 is more recent than controlfile
ORA-00312: online log 4 thread 1: 'D:\ORACLE\ORADATA\DBELENA\REDO04.ORA'

Fri Oct 02 11:59:06 2009
Errors in file d:\Oracle\admin\DBELENA\bdump\dbelenaLGWR.TRC:
ORA-00338: log 4 of thread 1 is more recent than controlfile
ORA-00312: online log 4 thread 1: 'D:\ORACLE\ORADATA\DBELENA\REDO04.ORA'

ORA-338 signalled during: alter database open...

Запуск с 01.ctl
Fri Oct 02 12:01:09 2009
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=11
Fri Oct 02 12:01:10 2009
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Oct 02 12:01:10 2009
ARC0: Archival started
Fri Oct 02 12:01:10 2009
alter database mount exclusive
Fri Oct 02 12:01:14 2009
Successful mount of redo thread 1, with mount id 3021891786.
Fri Oct 02 12:01:14 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 02 12:01:14 2009
alter database open
Fri Oct 02 12:01:14 2009
Errors in file d:\Oracle\admin\DBELENA\bdump\dbelenaLGWR.TRC:
ORA-00338: log 4 of thread 1 is more recent than controlfile
ORA-00312: online log 4 thread 1: 'D:\ORACLE\ORADATA\DBELENA\REDO04.ORA'

Fri Oct 02 12:01:14 2009
Errors in file d:\Oracle\admin\DBELENA\bdump\dbelenaLGWR.TRC:
ORA-00338: log 4 of thread 1 is more recent than controlfile
ORA-00312: online log 4 thread 1: 'D:\ORACLE\ORADATA\DBELENA\REDO04.ORA'

ORA-338 signalled during: alter database open...

Шикарно... :( Ну тогда пробуем пересоздать контрольник.

Сам радуюсь. :( Но пока мне, к сожалению, мне такого короткого совета недостаточно... А какой командой его пересоздать? Как здесь https://olegon.ru/smoracle.php?

у тебя есть трэйс. и в нем готовый скрипт для создания контрольника.

берем из него и сохраняем в отдельный файл (к примеру, c:\cf.sql) кусок
в sqlplus делаем
shutdown immediate;
@c:\cf;

смотрим, что сказал

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> @c:\cf
ORACLE instance started.

Total System Global Area 718390236 bytes
Fixed Size 70620 bytes
Variable Size 171282432 bytes
Database Buffers 536870912 bytes
Redo Buffers 10166272 bytes
Input truncated to 26 characters
25 /

Control file created.

SQL>
Размер control03.ctl увеличился с 3 661 824 до 8 577 024

alrt.log

Fri Oct 02 12:52:42 2009
CREATE CONTROLFILE REUSE DATABASE "DBELENA" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 4084
LOGFILE
GROUP 4 'D:\ORACLE\ORADATA\DBELENA\REDO04.ORA' SIZE 50M,
GROUP 5 'D:\ORACLE\ORADATA\DBELENA\REDO05.ORA' SIZE 50M,
GROUP 6 'D:\ORACLE\ORADATA\DBELENA\REDO06.ORA' SIZE 50M
DATAFILE
'D:\ORACLE\ORADATA\DBELENA\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\DBELENA\RBS01.DBF',
'D:\ORACLE\ORADATA\DBELENA\USERS01.DBF',
'D:\ORACLE\ORADATA\DBELENA\TEMP01.DBF',
'D:\ORACLE\ORADATA\DBELENA\TOOLS01.DBF',
'D:\ORACLE\ORADATA\DBELENA\INDX01.DBF',
'D:\ORACLE\ORADATA\DBELENA\USERS02.DBF',
'D:\ORACLE\ORADATA\DBELENA\INDX02.DBF',
'D:\ORACLE\ORADATA\DBELENA\TEMP02.DBF',
'D:\ORACLE\ORADATA\DBELENA\TEMP03.DBF',
'D:\ORACLE\ORADATA\DBELENA\USERS03.DBF',
'D:\ORACLE\ORADATA\DBELENA\INDX03.DBF'
CHARACTER SET CL8MSWIN1251

Fri Oct 02 12:52:43 2009
Successful mount of redo thread 1, with mount id 2849297433.
Fri Oct 02 12:52:43 2009
Completed: CREATE CONTROLFILE REUSE DATABASE "DBELENA" NORESE

ALTER DATABASE OPEN;

alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DBELENA\SYSTEM01.DBF'

RECOVER DATABASE;

Recover database или RECOVER DATAFILE 1

попробуй сначала database