System homogeneous copy using Backup restore Oracle Error: ORA:01200

[Former Member]

Hi,

I am freshing my DEV system with PRD online backup. After database restore, I am creating controlfile. While doing so I am getting following error.

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS ARCHIVELOG

*

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01200: actual file size of 262143 is smaller than correct size of 335360

blocks

ORA-01110: data file 4: 'F:\ORACLE\DEV\SAPDATA1\PRD_1\PRD.DATA1'

Please help.

Regards,

Prashant Parab.

[Former Member]

Hi Raul,

I think it's better if you try with an offline bakcup, only if it's possible. A few days ago I made a copy homegeneus copy between systems. But I use an offline backup actually you can use the ORABRCOPY tool to create de Controlfile.

Check this procedure.

https://websmp210.sap-ag.de/~sapidb/011000358700000416402008E.pdf

Just my two cents.

Regards.

[Former Member]

Did you check the procedure at http://service.sap.com/systemcopy ?

[Former Member]

Hi,

Below mention datafile is not properly restored.

please ask unix admin to resotre the missing files again.

Then again try to create control file.This time it should work.

Regards,

Phani.

[Former Member]

Hi,

Please check below SAP Notes.

Note 696141 - Composite SAP Note: ORA-01122

Note 205501 - ORA-600 [KZSRSDN 1] with ORA-1503 create controlfile

I believe you are executing above sql in nomount mode (STARTUP NOMOUNT)

Can you try by alter database backup controlfile to trace restelogs;

http://www.orafaq.com/forum/t/63615/0/

1 more thing

Copying production or QA to DEV such a procedure does not correspond to the strategy recommended by SAP to always retain the development system.

But If you want to do a copy then please have a look at SAP Note 130906 - How can versions be transported?

Hope this helps.

Thanks

Sushil

[Former Member]

Oracle says this:

oerr ora 1200
01200, 00000, "actual file size of %s is smaller than correct size of %s blocks"
// *Cause:  The size of the file as returned by the operating system is smaller
//         than the size of the file as indicated in the file header and the
//         control file. Somehow the file has been truncated. Maybe it is the
//         result of a half completed copy.
// *Action: Restore a good copy of the data file and do recovery as needed.

It seems, your backup file is flawed. Was your online backup successful? Did you do it with brbackup ?

Anyway, try with a new backup.