create control file failed

Wed, 05 Mar 2003 01:44:02 -0800

Hi All
 
I am recreating the database from cold backup. But I am facing the following problem
 
Oracle version : 8.1.7
Environment     : HP
 
SVRMGR> CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS ARCHIVELOG
     2>     MAXLOGFILES 32
     3>     MAXLOGMEMBERS 2
     4>     MAXDATAFILES 254
     5>     MAXINSTANCES 8
     6>     MAXLOGHISTORY 29041
     7> LOGFILE
     8>   GROUP 1 '/oradba/oradata/HTK443M8/redo01.log'  SIZE 500K,
     9>   GROUP 2 '/oradba/oradata/HTK443M8/redo02.log'  SIZE 500K,
    10>   GROUP 3 '/oradba/oradata/HTK443M8/redo03.log'  SIZE 500K,
    11>   GROUP 4 '/oradba/oradata/HTK443M8/redo04.log'  SIZE 500K
    12> DATAFILE
    13>   '/oradba/oradata/HTK443M8/system01.dbf',
    14>   '/oradba/oradata/HTK443M8/tools01.dbf',
    15>   '/oradba/oradata/HTK443M8/rbs01.dbf',
    16>   '/oradba/oradata/HTK443M8/temp01.dbf',
    17>   '/oradba/oradata/HTK443M8/users01.dbf',
    18>   '/oradba/oradata/HTK443M8/indx01.dbf',
    19>   '/oradba/oradata/HTK443M8/admin_01.dbf',
    20>   '/oradba/oradata/HTK443M8/bmpi_01.dbf',
    21>   '/oradba/oradata/HTK443M8/cnc_01.dbf',
    22>   '/oradba/oradata/HTK443M8/evnt_mast_01.dbf',
    23>   '/oradba/oradata/HTK443M8/evnt_othr_01.dbf',
    24>   '/oradba/oradata/HTK443M8/images_01.dbf',
    25>   '/oradba/oradata/HTK443M8/lists_01.dbf',
    26>   '/oradba/oradata/HTK443M8/matrl_01.dbf',
    27>   '/oradba/oradata/HTK443M8/audit_sis01.dbf',
    28>   '/oradba/oradata/HTK443M8/audit_sis_idx01.dbf',
    29>   '/oradba/oradata/HTK443M8/matrl_use_01.dbf',
    30>   '/oradba/oradata/HTK443M8/modules_01.dbf',
    31>   '/oradba/oradata/HTK443M8/obs_01.dbf',
    32>   '/oradba/oradata/HTK443M8/patients_01.dbf',
    33>   '/oradba/oradata/HTK443M8/pdt_01.dbf',
    34>   '/oradba/oradata/HTK443M8/personnel_01.dbf',
    35>   '/oradba/oradata/HTK443M8/quality_01.dbf',
    36>   '/oradba/oradata/HTK443M8/schedules_01.dbf',
    37>   '/oradba/oradata/HTK443M8/script_01.dbf',
    38>   '/oradba/oradata/HTK443M8/admin_idx_01.dbf',
    39>   '/oradba/oradata/HTK443M8/bmpi_idx_01.dbf',
    40>   '/oradba/oradata/HTK443M8/cnc_idx_01.dbf',
    41>   '/oradba/oradata/HTK443M8/rbs1_01.dbf',
    42>   '/oradba/oradata/HTK443M8/evnt_mast_idx_01.dbf',
    43>   '/oradba/oradata/HTK443M8/evnt_othr_idx_01.dbf',
    44>   '/oradba/oradata/HTK443M8/images_idx_01.dbf',
    45>   '/oradba/oradata/HTK443M8/lists_idx_01.dbf',
    46>   '/oradba/oradata/HTK443M8/matrl_idx_01.dbf',
    47>   '/oradba/oradata/HTK443M8/matrl_use_idx_01.dbf',
    48>   '/oradba/oradata/HTK443M8/modules_idx_01.dbf',
    49>   '/oradba/oradata/HTK443M8/rbs2_01.dbf',
    50>   '/oradba/oradata/HTK443M8/obs_idx_01.dbf',
    51>   '/oradba/oradata/HTK443M8/patients_idx_01.dbf',
    52>   '/oradba/oradata/HTK443M8/pdt_idx_01.dbf',
    53>   '/oradba/oradata/HTK443M8/personnel_idx_01.dbf',
    54>   '/oradba/oradata/HTK443M8/quality_idx_01.dbf',
    55>   '/oradba/oradata/HTK443M8/schedules_idx_01.dbf',
    56>   '/oradba/oradata/HTK443M8/script_idx_01.dbf',
    57>   '/oradba/oradata/HTK443M8/interface_01.dbf',
    58>   '/oradba/oradata/HTK443M8/drsys01.dbf',
    59>   '/oradba/oradata/HTK443M8/quest01.dbf',
    60>   '/oradba/oradata/HTK443M8/crystal_report_01.dbf',
    61>   '/oradba/oradata/HTK443M8/crystal_report_idx_01.dbf',
    62>   '/oradba/oradata/HTK443M8/interface_idx_01.dbf',
    63>   '/oradba/oradata/HTK443M8/sisweb_01.dbf',
    64>   '/oradba/oradata/HTK443M8/rules_engine_01.dbf'
    65> CHARACTER SET US7ASCII
    66> ;
CREATE CONTROLFILE REUSE SET DATABASE "HTK443M8" RESETLOGS ARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01565: error in identifying file '/oradba/oradata/HTK443M8/audit_sis01.dbf'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
SVRMGR> spool off
I verified with metalink, It is saying this is due to incorrect DB_BLOCK_SIZE parameter. But I am sure there is no change in this parameter.
 
Any thoughts/suggestions in this regard very much appreciated.
 
 
Banarasi Babu
OCP, DBA

Reply via email to