DB Refresh Error

[Former Member]

Hello All,

I have got following error during the restore

ORA-01122: database file 3 failed verification check

ORA-01110: data file 3: '/oracle/XXX/sapdataX/btabd_12/btabd.data12'

ORA-01200: actual file size of 93223 is smaller than correct size of 334976 blocks

Filesystems on source and target are exactly the same.

If u all can guide, please let me know the poosible causes.

Thanks in advance,

Anu

[Former Member]

Hi All, thanks for ur help.

there was some issue at the OS level and also file was corrupted.

We have used another backup.

Thanks again,

Anu

[Former Member]

Actually you dont need to create a new control file if you have a clean offline backup .You have to restore and recover the system.For a safer side

just

run the command

alter system switch logs

several times and then set the database in noarchivelog mode from command line or from sapdba/br* binaries.

Shutdown the system and copy files manually or take backup from brarchive with offile_force option.

Thank you.

Amit

[Former Member]

Anu

1.I believe that after generating the control file ,you or your team members might have added datafile or extended it and there fore you are getting the mismatch in the size of datafile.

2 .Are you copying the files manually .If that is the case then you have to stop the backup script if it is scheduled.It also updates the control file even if you db is down.

3.How you are doing system copy

Use oradbcopy +backup /restore method using sapinst

4.you can restore the offline backup again and delete the old control files and create cntrl files from trace file if required but and do the recovery.

hope this helps you.

Amit

[Former Member]

Hi,

I have followd the below procedure.

cd /oracle/<target_SID>/saptrace/usertrace

sqlplus u201C/as sysdbau201D

startup

alter database backup controlfile to trace;

shutdown

exit

thanks,

anu

[markus_doehr2]

You did this on the source system, modified the resulting trace file and created the new control files on the target system?

Markus

[Former Member]

I am using offline backup and doing it manually.

Anu

[Former Member]

Hi,

It look like you r using the OLD control file. did you generate the control file after you backup?

[markus_doehr2]

Doing "manually" implies the creation of the control file. To copy a database is not enough to just copy the data files from an offline backup.

Markus

[Former Member]

See below link it may help you

/thread/224262 [original link is broken]

[Former Member]

Yes,

Database mounted fine but whle opening i got this error.

Anu.

[Former Member]

Amit,

But Datafiles are going to be restored from production, so if filesystem size is same then there shud not be any problem.

Thanks,

Anu

[Former Member]

Hi,

Which process your are doing the DB Refresh using any tool or manually ?

& you are using the Online backup or Offline backup ?

Thanks,

Shambo

[markus_doehr2]

Did you

- create new control files?

- opened the database using resetlogs?

Markus

[Former Member]

FS might be same in src and tgt but I believe datafiles are not same.

Can you check the size of datafile in question in src and target system?

or if your backup is in tapes ,you can read the size of file if you have any third party tool for backup i.e data protector or netbackup etc

or take the backup and restore it again.

Thanks

Amit