ORA-01122 database file string failed verification checkCause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.Action: Make certain that the database files and control files are the correct files for this database.
解决方案 »
- 新手求救 Qracle登录的那个帐户被锁定怎么办
- java传递oracle数组:Non supported character set: oracle-character-set-867
- 关于备份的一个问题。急。。。
- 请教 Oracle Proc*c 编程内存泄漏的问题
- kill掉Session后,怎么手动回滚这个Session用过的回滚空间
- oracle 监听器自动关闭
- 新建database出错.请各位不吝赐教.在线等
- access 导入oracle ??
- to:bzszp(SongZip),再求一sql语句,谢谢!
- orcl解析xml获取节点属性的值
- 关于oracle客户端的安装!总是提示“加载数据库错误”
- 我想统计一下,2004-1-1 到 2004-2-3 每天的人数,sql语句怎么写??
写一个重建控制文件的语句;
把数据库 startup nomount ,执行 script
SQL> CREATE CONTROLFILE REUSE DATABASE "DONNYDB2" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 64
3 MAXLOGMEMBERS 2
4 MAXDATAFILES 254
5 MAXINSTANCES 32
6 MAXLOGHISTORY 226
7 LOGFILE
8 GROUP 1 'D:\ORACLE\ORADATA\DONNYDB2\REDO01.LOG' SIZE 100M,
9 GROUP 2 'D:\ORACLE\ORADATA\DONNYDB2\REDO02.LOG' SIZE 100M,
10 GROUP 3 'D:\ORACLE\ORADATA\DONNYDB2\REDO03.LOG' SIZE 100M
11 DATAFILE
12 'D:\ORACLE\ORADATA\DONNYDB2\SYSTEM01.DBF',
13 'D:\ORACLE\ORADATA\DONNYDB2\UNDOTBS01.DBF',
14 'D:\ORACLE\ORADATA\DONNYDB2\DRSYS01.DBF',
15 'D:\ORACLE\ORADATA\DONNYDB2\INDX02.DBF',
16 'D:\ORACLE\ORADATA\DONNYDB2\USERS01.DBF',
17 'D:\ORACLE\ORADATA\DONNYDB2\XDB01.DBF'
18 CHARACTER SET ZHS16GBK
19 ;