Oracle 11g ORA-00314、ORA-00312 redo日志与控制文件sequence不

发布时间：2020-12-12 14:57:31 所属栏目：百科来源：网络整理

导读：机器迁移机房，没有关闭数据库，直接断电。 ORA-00314: ?? 4 (???? 1) ??? sequence# 32993 ? 32998 ??? ORA-00312: ???? 4 ?? 1: 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO04.LOG' 1.先备份控制文件，还建议在操作系统层面上备份一次 alter database ba

机器迁移机房，没有关闭数据库，直接断电。

ORA-00314: ?? 4 (???? 1) ??? sequence# 32993 ? 32998 ???

ORA-00312: ???? 4 ?? 1: 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO04.LOG'

1.先备份控制文件，还建议在操作系统层面上备份一次

alter database backup controlfile to trace;
shutdown immediate;
在E:oracleproduct10.2.0adminorcludump中找到controlfile的trace文件。

2.重建控制文件

startup nomount;
CREATE CONTROLFILE REUSE DATABASE "orcl" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 5840
LOGFILE
GROUP 1 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO01.LOG' SIZE 50M,
GROUP 2 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO02.LOG' SIZE 50M,
GROUP 3 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO03.LOG' SIZE 50M,
GROUP 4 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO04.LOG' SIZE 50M,
GROUP 5 'E:ORACLEPRODUCT10.2.0ORADATAorclREDO05.LOG' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'E:ORACLEPRODUCT10.2.0ORADATAorclSYSTEM01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSYSAUX01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclUSERS01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclorcl.ORA',
'E:ORACLEPRODUCT10.2.0ORADATAorclSL01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSL101.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclDMHNEX01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclDMHNEX02.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclDMHNEX03.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclDMHNEX04.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclDIS24SZ_DATA01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclDIS24SZ_ACC01.DBF',
'F:ORACLEORADATAYTHGIS.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclorcl02.ORA',
'E:ORACLEPRODUCT10.2.0ORADATAorclorcl03.ORA',
'E:ORACLEPRODUCT10.2.0ORADATAorclorcl04.ORA',
'E:ORACLEPRODUCT10.2.0ORADATAorclSL02.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSL03.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSL04.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSZTS01.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSZTS02.DBF',
'E:ORACLEPRODUCT10.2.0ORADATAorclSL05.DBF',
'F:ORACLEORADATA2017.DBF',
'F:ORACLEORADATAUNDOTBS3.DBF'
CHARACTER SET ZHS16GBK
;
3.清理redo日志 recover database until cancel using backup controlfile; 指定日志: {=suggested | filename | AUTO | CANCEL} cancel 介质恢复已取消。 alter database open resetlogs;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!