on 02-03-2015 9:34 AM
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.