Oracle启动提示下面问题，请高人指点

2009-03-17 02:11:18 258 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

hcj2002 墨衍会员 · AI 创作全网分发关注 + 加入社区

GD32_ADC采样+DMA多通道扫描传输所使用的MCU 片上集成了 12 位逐次逼近式模数转换器模块（ADC），可以采样来自于 16 个外部通道和 2 个内部通道上的模拟信号。这 18 个 ADC 采样通道都支持多种运行模式，采样转换后，转换结果可以按照最低有效位对齐或最高有效位对齐的方式保存在相应的数据寄存器中。我们主要介绍其多通道扫描转换和DMA传输功能，在多个通道轮询采集ad数据，并使用DMA分别保存各个数据值，其能大大提高ADC的工作效率。以下为ADC 模块框图：阅读详情

SQL> startup
ORACLE instance started.

Total System Global Area 795127808 bytes
Fixed Size 1302848 bytes
Variable Size 494931648 bytes
Database Buffers 293601280 bytes
Redo Buffers 5292032 bytes
Database mounted.
ORA-01122: database file 11 failed verification check
ORA-01110: data file 11: '/opt/XXX/dump/MEPACKTBS.dbf'
ORA-01251: Unknown File Header Version read for file number 11

...全文

unity 腾讯地图sdk移动和缩放代码 unity 腾讯地图sdk 实现移动端缩放和移动阅读详情

hcj2002

Oracle 17,133 成员 55,258 内容

+ 关注 + 加入社区

切换为时间正序

rockywu 2009-05-12

打赏
举报

UP...
记住，按2楼操作前还得备份一下...

liulongjin2008 2009-05-11

打赏
举报

顶2楼的

East271536394 2009-05-01

打赏
举报

数据文件出错了

CathySun118 2009-04-17

打赏
举报

应是数据文件被破坏了
解决的办法参考楼上的

Tomac 2009-04-16

打赏
举报

一个分析和操作的例子给你参考。

Symptoms
Corruption reported while reading datafile header.
Alert log shows messages like:
ORA-01171: datafile 8 going offline due to error advancing checkpoint
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: '/oracle/test_lob12.dbf'
ORA-01251: Unknown File Header Version read for file number 8

Cause
Corrupted file header.
This could be caused due to missed read or write or hardware problem or process external to oracle
overwriting the information in file header.

Solution
To Solve the problem :-
1. The database needs to be in Archive log mode.
2. You need to have all the Archive log file from the time the datafile was created .

Steps to be followed
====================
Step1 :-
Take the problematic datafile offline.
SQL> Alter database datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf' offline;
Database altered.

SQL> alter database open;
Database altered.

Step 2:-
Issue the following command to re-create the file :

SQL> Alter database create datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf';
Database altered.

Step 3:-
Start applying the archive log file to recreate datafile.

SQL> Recover datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf';
ORA-00279: change 931981365 generated at 11/05/2008 11:16:04 needed for thread 1
ORA-00289: suggestion : /archivelogpath/1_1156_667734786.dbf
ORA-00280: change 931981365 for thread 1 is in sequence #1156

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 931981489 generated at 11/05/2008 11:16:10 needed for thread 1
ORA-00289: suggestion : /archivelogpath/1_1157_667734786.dbf
ORA-00280: change 931981489 for thread 1 is in sequence #1157
ORA-00278: log file '/archivelogpath/1_1156_667734786.dbf' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 931981564 generated at 11/05/2008 11:16:22 needed for thread 1
ORA-00289: suggestion : /archivelogpath/1_1158_667734786.dbf
ORA-00280: change 931981564 for thread 1 is in sequence #1158
ORA-00278: log file '/archivelogpath/1_1157_667734786.dbf' no longer needed for this recovery

Log applied.
Media recovery complete.

Step 4:-
When the recovery is finished, bring the datafile online.

SQL> Alter database datafile '/opt/oracle/oradata/STAPLES/datafile/block01.dbf' online;
Database altered.

SQL> select count(*) from daimin.test;
COUNT(*)
----------
14936

hongqi162 2009-03-17

打赏
举报

据说和磁盘阵列有关系，你是不是做了这方面的改动

Oracle启动提示下面问题，请高人指点

相关推荐