当DB引擎启动失败时，从oracle 12c中损坏的重做文件中恢复

Question

我在Windows 7开发机器上安装了Oracle 12.0.1.2.0 (企业包)。在发生意外的电源故障后，Oracle引擎无法启动：

因此，我无法与SQLplus连接来执行任何命令，因此，我在网上找到的清除重做文件的指南都不适合我。

ORA-01033: ORACLE initialization or shutdown in progress
01033. 00000 -  "ORACLE initialization or shutdown in progress"
*Cause:    An attempt was made to log on while Oracle is being started up or shutdown.
*Action:   Wait a few minutes. Then retry the operation.
Vendor code 1033

这是启动日志：

...
Mon Jun 19 10:56:47 2017
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Mon Jun 19 10:56:47 2017
Started redo scan
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc (incident=43430):
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00334: archived log: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident details in:     C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43430\orcl_ora_4864_i43430.trc
Sweep [inc][43430]: completed
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc  (incident=43431):
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00334: archived log: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident details in:     C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43431\orcl_ora_4864_i43431.trc
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_m000_4680.trc  (incident=43462):
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident details in:     C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43462\orcl_m000_4680_i43462.trc
Mon Jun 19 10:57:06 2017
Dumping diagnostic data in directory=[cdmp_20170619105706], requested by (instance=1, osid=4864), summary=[incident=43430].
Mon Jun 19 10:57:07 2017
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc:
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017     18:09:53
ORA-00334: archived log: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_m000_4680.trc  (incident=43463):
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident details in:     C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43463\orcl_m000_4680_i43463.trc
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc  (incident=43432):
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident details in:     C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43432\orcl_ora_4864_i43432.trc
Mon Jun 19 10:57:07 2017
Dumping diagnostic data in directory=[cdmp_20170619105707], requested by (instance=1, osid=4864), summary=[incident=43431].
Mon Jun 19 10:57:08 2017
Dumping diagnostic data in directory=[cdmp_20170619105708], requested by (instance=1, osid=4680 (M000)), summary=[incident=43463].
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc  (incident=43433):
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident details in:     C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43433\orcl_ora_4864_i43433.trc
Mon Jun 19 10:57:09 2017
Slave encountered ORA-10388 exception during crash recovery
Mon Jun 19 10:57:09 2017
Slave encountered ORA-10388 exception during crash recovery
Mon Jun 19 10:57:09 2017
Dumping diagnostic data in directory=[cdmp_20170619105709], requested by (instance=1, osid=4864), summary=[incident=43433].
Mon Jun 19 10:57:09 2017
Slave encountered ORA-10388 exception during crash recovery
Mon Jun 19 10:57:10 2017
Aborting crash recovery due to error 355
Mon Jun 19 10:57:10 2017
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc:
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Mon Jun 19 10:57:10 2017
Errors in file C:\APP\SONORA\diag\rdbms\orcl\orcl\trace\orcl_ora_4864.trc:
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017     18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
ORA-355 signalled during: alter database open...

下面是跟踪转储文件(orcl_ora_4864.trc)：

DDE: Problem Key 'ORA 312' was flood controlled (0x1) (no incident)
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
Incident 43432 created, dump file:    C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43432\orcl_ora_4864_i43432.trc
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'

Incident 43433 created, dump file:    C:\APP\SONORA\diag\rdbms\orcl\orcl\incident\incdir_43433\orcl_ora_4864_i43433.trc
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'


*** 2017-06-19 10:57:10.590
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'
ORA-00355: change numbers out of order
ORA-00353: log corruption near block 37327 change 3289952 time 06/14/2017 18:09:53
ORA-00312: online log 1 thread 1: 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG'

现在我的问题是:有什么方法可以解决这个问题而不重新安装Oracle？我不关心数据丢失，因为它不是生产数据，我只是希望避免再次建立我的本地数据库，因为我在时钟。任何帮助都是非常感谢的。

Answer 1

组中有其他日志文件吗？如果不是..。

安装数据库：

STARTUP MOUNT;

清除日志文件：

ALTER DATABASE CLEAR UNARCHIVED LOGFILE 'C:\APP\SONORA\ORADATA\ORCL\REDO01.LOG';
ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;

重置日志&打开数据库：

ALTER DATABASE OPEN RESETLOGS;

如果您在此过程中获得了一个ORA-01624，那么需要一个不同的解决方案。

您可能必须设置隐藏参数_allow_resetlogs_corruption= true和/或重新创建控制文件以从中恢复。