create control file failed

From: BanarasiBabu Tippa <btippa_at_ORsoftware-india.com>
Date: Wed, 05 Mar 2003 00:49:29 -0800
Message-ID: <F001.005604C7.20030305004929@fatcity.com>

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
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: BanarasiBabu Tippa
  INET: btippa_at_ORsoftware-india.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 05 2003 - 02:49:29 CST