ORA-01200: actual file size of 437759 is smaller than correct size of 43776

[former_member524429]

Hi,

I am getting the following unexpected errors while going to create CONTROL files after successful completion of offline/online oracle backup RESTORE (of PRD system) on Quality system. We are following Database specific system copy method to do the same.

All the required pre & post restore activities for the same were carried out. Even the same RESTORE activities are performed with different different online/offline backups of PRD system to do such system copy. But, the thing is stuck at control file creation step with the following same error which is seen again & again after every DB restore operation.....

SQL> @/oracle/AEQ/saptrace/usertrace/CONTROL.SQL
ORACLE instance started.

Total System Global Area 4714397696 bytes
Fixed Size                  2050336 bytes
Variable Size            2365589216 bytes
Database Buffers         2332033024 bytes
Redo Buffers               14725120 bytes
CREATE CONTROLFILE REUSE SET DATABASE "AEQ" RESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01200: actual file size of 437759 is smaller than correct size of 437760 blocks
ORA-01110: data file 4: '/oracle/AEQ/sapdata1/sr3_1/sr3.data1'

At OS level the file size of sr3.data1 is found 3586129920 bytes (= 437760 * 8192 bytes).

host1:oraaeq 20> cd /oracle/AEQ/sapdata1/sr3_1
host1:oraaeq 21> ll
total 7004176
-rw-r--r--   1 oraaeq     dba        3586129920 May 11 02:26 sr3.data1

The above mentioned error is coming for all 294 data files. The reported file size difference is only of 1 Block in all data files. The DB block size is 8192 bytes.

Environment: (for SAP QUALITY & PRD systems)

OS: HP_UX ia64 B.11.23

SAP System : SAP ECC 6.0

Database: Oracle 10.2.0.2.0

Your help for this reported issue will be highly appreciated.

Regards,

Bhavik G. Shroff

[Former Member]

Dear Bhavik,

Usually this kind of error indicates improper database restoration. But as you said, you tried restoring it again and again..

I would guess either there may be copy of previous controlfile exist at one of the mirror location, which may causing this error.

OR have you tried also restoring init).

Did you find any other points in your further investigation ?

While seaching on google I got one thread with unique solution....

[/thread/224262 |/thread/224262 ]

I´ve got it!!! Since Oracle was complaining about the size of my datafile:
ORA-01200: actual file size of 1569280 is smaller than correct size of 1569920,
I decided to "manually extend it". So, I created a file of 640 blocks-length (the difference reported by Oracle between correct size and actual size) and appended it to the datafile with the "cat" command from Unix.

After this I recreated the controlfiles, performed a media recovery and... the database opened!

Then, I made a full export of the database and re-created it (I was afraid about future errors due to my rough solution).

See if it helps you....

Regards.

Rajesh Narkhede

[former_member524429]

Hi,

Thanks for your response.

We already have tried the same whatever you have mentioned as suggestions in ur last post .

We already tried to extend all 294 data-files as mentioned in that oracle forum link.

Its not the recommended way to play with data-files in such a way as it can lead to other unnecessary errors.

We have seen the following errors after successful creation of control file by manually extending all those 294 files (it was around 10hrs job).

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00332: archived log is too small - may be incompletely archived
ORA-00334: archived log: '/oracle/AEQ/oraarch/AEQarch1_268984_629943661.dbf'

have you tried also restoring init<SID>.ora file from PRD to new system.

I think its not having relationship with control file generation. Both systems are having same init files with respective SIDs.

Did you find any other points in your further investigation ?

I am thinking to perform Fresh SAP System Installation with same SID (AEQ) and then will try to do Database Restore again with last offline backup of AEQ system.

Regards,

Bhavik G. Shroff

[former_member524429]

Hi,

One useful thread i have found on SDN , which is 100% matching with my problem. Because our SAP systems are also installed on HP IVM Guest Host of HP rx6600 Server.

[|]

We have logged the same with HP. So, let see how they will resolve the issue.

Regards,

Bhavik G. Shroff

[Former Member]

Hi Bhavik,

Is that solution mentioned in above thread also solved your problem ?

I would request, when the issue is resolved, please update the thread with proper explanation and the solution.

It will help others as this problem is strange and very unusual....

All the best...

Regards.

Rajesh Narkhede

[former_member524429]

Hi,

The problem is resolved after upgrading HP IVM version from A 3.00 to A3.50. After such up-gradation done by HP Official support, we were able to complete System Copy procedure on affected host with successful Creation of control files for the same.

Along with your valuable support , the Following Reference links help a lot for the same.

SAP Note 1351051 - Support of Oracle for HP-UX Itanium Integrity VM

Thanks again.

Regards,

Bhavik G. Shroff