Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: create control file failed

RE: create control file failed

From: BanarasiBabu Tippa <btippa_at_ORsoftware-india.com>
Date: Wed, 05 Mar 2003 20:08:39 -0800
Message-ID: <F001.00561B3C.20030305200839@fatcity.com>


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: jwilton_at_speakeasy.net 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). -- 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 - 22:08:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US