所有数据文件的scn一致，为什么重建控制文件不成功呢？

显示全部楼层 · 2006-3-20 16:25:54

如：
SQL> CREATE CONTROLFILE DATABASE "AFIS" noresetlogs
2MAXLOGFILES 32
3MAXLOGMEMBERS 2
4MAXDATAFILES 32
5MAXINSTANCES 16
6MAXLOGHISTORY 1815
7LOGFILE
8GROUP 1 'C:\ORACLE\ORADATA\AFIS\REDO03.LOG'SIZE 1M,
9GROUP 2 'C:\ORACLE\ORADATA\AFIS\REDO02.LOG'SIZE 1M,
10GROUP 3 'C:\ORACLE\ORADATA\AFIS\REDO01.LOG'SIZE 1M
11DATAFILE
12'C:\ORACLE\ORADATA\AFIS\SYSTEM01.DBF',
13'C:\ORACLE\ORADATA\AFIS\RBS01.DBF',
14'C:\ORACLE\ORADATA\AFIS\USERS01.DBF',
15'C:\ORACLE\ORADATA\AFIS\TEMP01.DBF',
16'C:\ORACLE\ORADATA\AFIS\TOOLS01.DBF',
17'C:\ORACLE\ORADATA\AFIS\INDX01.DBF',
18'C:\ORACLE\ORADATA\AFIS\DR01.DBF'
19CHARACTER SET ZHS16GBK
20;
CREATE CONTROLFILE DATABASE "AFIS" noresetlogs
*
ERROR 位于第 1 行:
ORA-01503: CREATE CONTROLFILE ??
ORA-01189: ????????????? RESETLOGS
ORA-01110: ???? 5: 'C:\ORACLE\ORADATA\AFIS\TOOLS01.DBF'
说明：tools01.dbf是我一个旧的文件，但是我用bbed更改其scn跟其他文件一致了，并且用bbed的sum file 5 apply 成功。从
select file#,change

千问 · 2006-3-20 16:25:54

select file#,checkpoin_change# from v$datafile_header; 查看其checkpoint_change#的数值是一致的。

千问 · 2006-3-20 16:25:54

noresetlogs
改成resetlogs for a try

千问 · 2006-3-20 16:25:54

最初由 yanggq 发布
[B]noresetlogs
改成resetlogs for a try [/B]
不要轻易使用该选项！

千问 · 2006-3-20 16:25:54

backup before resetlogs

千问 · 2006-3-20 16:25:54

最初由 yanggq 发布
[B]noresetlogs
改成resetlogs for a try [/B]
使用resetlogs也不行，是否在创建控制文件时除了scn还要检验别的项

千问 · 2006-3-20 16:25:54

参阅：http://epub.itpub.net/5/6.htm

千问 · 2006-3-20 16:25:54

参考：
Problem Description:
====================
You are attempting to recreate the controlfiles for an existing database.
During creation you may see the following errors:
Case 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u02/oradata/RM805/system01.dbf'
ORA-27046: file size is not a multiple of logical block size
- or -
Case 2:
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/u02/oradata/RM805/system01.dbf'

Solution Description:
=====================
Adjust the DB_BLOCK_SIZE parameter accordingly:
- If you received the errors in Case 1 (ORA-01503, ORA-01565, and ORA-27046),
you should decrease the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.
- If you received the errors in Case 2 (ORA-01503, ORA-01160, and ORA-01110),
you should increase the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.

Explanation:
============
Both cases occur due to an incorrect setting of the db_block_size parameter in
the "init.ora" file.
Case 1: The specified db_block_size in the "init.ora" is too large.
Case 2: The specified db_block_size in the "init.ora" is too small.

The database blocksize must be specified correctly in the init.ora in order
to successfully recreate the controlfile.

Search Words:
=============
ORA-1503 ORA-1565 ORA-1503 ORA-1160 ORA-1110

千问 · 2006-3-20 16:25:54

最初由 Toms_zhang 发布
[B]参考：
Problem Description:
====================
You are attempting to recreate the controlfiles for an existing database.
During creation you may see the following errors:
Case 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/u02/oradata/RM805/system01.dbf'
ORA-27046: file size is not a multiple of logical block size
- or -
Case 2:
ORA-01503: CREATE CONTROLFILE failed
ORA-01160: file is not a data file
ORA-01110: data file : '/u02/oradata/RM805/system01.dbf'

Solution Description:
=====================
Adjust the DB_BLOCK_SIZE parameter accordingly:
- If you received the errors in Case 1 (ORA-01503, ORA-01565, and ORA-27046),
you should decrease the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.
- If you received the errors in Case 2 (ORA-01503, ORA-01160, and ORA-01110),
you should increase the value specified by DB_BLOCK_SIZE before you attempt
to recreate the controlfile.

Explanation:
============
Both cases occur due to an incorrect setting of the db_block_size parameter in
the "init.ora" file.
Case 1: The specified db_block_size in the "init.ora" is too large.
Case 2: The specified db_block_size in the "init.ora" is too small.

The database blocksize must be specified correctly in the init.ora in order
to successfully recreate the controlfile.

Search Words:
=============
ORA-1503 ORA-1565 ORA-1503 ORA-1160 ORA-1110 [/B]
应该不是你上面列出的情况，比较特殊的情况是tools.dbf是个旧的，scn是通过bbed手动改的，