cancel
Showing results for 
Search instead for 
Did you mean: 

Control file creation issue in oracle.

Former Member
0 Kudos

Hi All,

After restoration while I am trying to run @control.sql we are getting the error as

ORA-01200: actual file size of <act_blocks> is smaller than correct size of <def_blocks> blocks.


We have restored few times but got the similar error. I search on the sdn regarding this issue but couldn't find the resolution.


Kindly suggest.


Regards,

Arpit

Accepted Solutions (1)

Accepted Solutions (1)

former_member182657
Active Contributor
0 Kudos

Hi,

Could you share alert_<SID>.log file from the system.If possible try to regenerate control file and verify the trace file before execution of control.sql on the copied system.

Regards,

Former Member
0 Kudos

Please find attached for alert log entries.

Regards,

Arpit

Former Member
0 Kudos

Hi Arpit,

Did u clear all the files in the sapdata* before restore?

Answers (6)

Answers (6)

Former Member
0 Kudos

Dear All,

Thanks for all your response..I have restored the DB again and regenerated control.sql and this time it was successful.

Appreciate your help.

Regards,

Arpit

0 Kudos

Hi Arpit.

Did you created the control.sql just after the backup was sucessfully executed? Ot rsome time before/later?

ORA-01200 indicates the control file contains different file sizes, waht is really present on the disks.

On the other hand, you should heck the restore, if the files were successfully restored in full size. Also check the mount options of the disks.

Compare the file sizes in backup log and restore log.

Regards,

János

former_member182657
Active Contributor
0 Kudos

Hi Arpit,


Errors in file /oracle/SID/saptrace/usertrace/SID_ora_598266.trc:

ORA-01200: actual file size of 816753 is smaller than correct size of 1118720 blocks

ORA-01110: data file 2: '/oracle/SID/sapdata3/undo_1/undo.data1

Here you could see the issue is with file undo.data1,if possible try to check for exact file size from the database backup available or restore the complete.

ORA-01200 only occurs if database files are corrupt or incomplete in size.

If this is your test DB than you can perform some tests on it like reinitialization or recover undo table space data file.( For this best would be to search ).

If i fails after following all than here i would do a fresh restore from a successful backup and recreate the control files again by removing the previous ones.

Hope this will help you.

Regards,

former_member182657
Active Contributor
0 Kudos

Hi Arpit,

For your issue i would suggest you to restore the system with a good backup once as the issue is related with database block corruption,mismatch of data block size.

Regards,

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi Arpit,

What is your OS ?

Can you give me a full logs for this when you run the control.sql ?

Also, are you doing a system copy  ?

Regards,

Former Member
0 Kudos

Hi,

OS is AIX5.3.

I am doing system refresh from Production to Development server.

I am attaching the control file for your reference.

Regards,

arpit

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "SID" RESETLOGS NOARCHIVELOG

    MAXLOGFILES 255

    MAXLOGMEMBERS 3

    MAXDATAFILES 254

    MAXINSTANCES 50

    MAXLOGHISTORY 11680

LOGFILE

  GROUP 1 (

    '/oracle/SID/origlogA/log_g11m1.dbf',

    '/oracle/SID/mirrlogA/log_g11m2.dbf'

  ) SIZE 50M,

  GROUP 2 (

    '/oracle/SID/origlogB/log_g12m1.dbf',

    '/oracle/SID/mirrlogB/log_g12m2.dbf'

  ) SIZE 50M,

  GROUP 3 (

    '/oracle/SID/origlogA/log_g13m1.dbf',

    '/oracle/SID/mirrlogA/log_g13m2.dbf'

  ) SIZE 50M,

  GROUP 4 (

    '/oracle/SID/origlogB/log_g14m1.dbf',

    '/oracle/SID/mirrlogB/log_g14m2.dbf'

  ) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  '/oracle/SID/sapdata1/system_1/system.data1',

  '/oracle/SID/sapdata3/undo_1/undo.data1',

  '/oracle/SID/sapdata1/sysaux_1/sysaux.data1',

  '/oracle/SID/sapdata1/sr3_1/sr3.data1',

  '/oracle/SID/sapdata1/sr3_2/sr3.data2',

  '/oracle/SID/sapdata1/sr3_3/sr3.data3',

  '/oracle/SID/sapdata1/sr3_4/sr3.data4',

  '/oracle/SID/sapdata1/sr3_5/sr3.data5',

  '/oracle/SID/sapdata2/sr3_6/sr3.data6',

  '/oracle/SID/sapdata2/sr3_7/sr3.data7',

  '/oracle/SID/sapdata2/sr3_8/sr3.data8',

  '/oracle/SID/sapdata2/sr3_9/sr3.data9',

  '/oracle/SID/sapdata2/sr3_10/sr3.data10',

  '/oracle/SID/sapdata3/sr3_11/sr3.data11',

  '/oracle/SID/sapdata3/sr3_12/sr3.data12',

  '/oracle/SID/sapdata3/sr3_13/sr3.data13',

  '/oracle/SID/sapdata3/sr3_14/sr3.data14',

  '/oracle/SID/sapdata3/sr3_15/sr3.data15',

  '/oracle/SID/sapdata4/sr3_16/sr3.data16',

  '/oracle/SID/sapdata4/sr3_17/sr3.data17',

  '/oracle/SID/sapdata4/sr3_18/sr3.data18',

  '/oracle/SID/sapdata4/sr3_19/sr3.data19',

  '/oracle/SID/sapdata4/sr3_20/sr3.data20',

  '/oracle/SID/sapdata1/sr3700_1/sr3700.data1',

  '/oracle/SID/sapdata1/sr3700_2/sr3700.data2',

  '/oracle/SID/sapdata1/sr3700_3/sr3700.data3',

  '/oracle/SID/sapdata1/sr3700_4/sr3700.data4',

  '/oracle/SID/sapdata2/sr3700_5/sr3700.data5',

  '/oracle/SID/sapdata2/sr3700_6/sr3700.data6',

  '/oracle/SID/sapdata2/sr3700_7/sr3700.data7',

  '/oracle/SID/sapdata2/sr3700_8/sr3700.data8',

  '/oracle/SID/sapdata3/sr3700_9/sr3700.data9',

  '/oracle/SID/sapdata3/sr3700_10/sr3700.data10',

  '/oracle/SID/sapdata3/sr3700_11/sr3700.data11',

  '/oracle/SID/sapdata3/sr3700_12/sr3700.data12',

  '/oracle/SID/sapdata4/sr3700_13/sr3700.data13',

  '/oracle/SID/sapdata4/sr3700_14/sr3700.data14',

  '/oracle/SID/sapdata4/sr3700_15/sr3700.data15',

  '/oracle/SID/sapdata4/sr3700_16/sr3700.data16',

  '/oracle/SID/sapdata1/sr3usr_1/sr3usr.data1',

  '/oracle/SID/sapdata4/sr3700_17/sr3700.data17',

  '/oracle/SID/sapdata4/sr3700_18/sr3700.data18',

  '/oracle/SID/sapdata4/sr3700_19/sr3700.data19',

  '/oracle/SID/sapdata4/sr3700_20/sr3700.data20',

  '/oracle/SID/sapdata4/sr3700_21/sr3700.data21'

CHARACTER SET UTF8

;

former_member182657
Active Contributor
0 Kudos

Hi,

Could you check with SAP KBA  696141 - Composite SAP Note: ORA-01122

Regards,

Former Member
0 Kudos

Hi Gaurav,

I have gone through the note and it suggest some patch set for HP-UX however we are at very higher patch level mentioned in the note.

Regards,

Arpit

0 Kudos

Hi Gaurav.

"Could you check with SAP KBA  696141 - Composite SAP Note: ORA-01122".

This is an SAP Note and not a KBA. I admit, they seems to be the same but in the header you can distinguish them. 

KBA stands for "Knowledge Base Article". Among the many differences, KBA can not contain code correction, on the other hand it can have screenshots and videos, etc. 🙂


Regards,

János


former_member182657
Active Contributor
0 Kudos

Thanks for correcting me !!

Regards,

Gaurav