Thanks Jeremiah you are correct, I restored the same file again from the backup. The problem was solved
thanks Banarasi -----Original Message----- Sent: Wednesday, March 05, 2003 3:35 PM To: Multiple recipients of list ORACLE-L So the obvious question: What is the db_block_size and what is the size in bytes of /oradba/oradata/HTK443M8/audit_sis01.dbf as it was restored from backup? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 5 Mar 2003, BanarasiBabu Tippa wrote: > 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).