Error (Ora-01194 and Ora-0110) in Homogenous System Copy Win / oracle

[Former Member]

Hi,

We are performing a homogenous System Copy of our prod. BW Server

OS: Windows

DB: Oracle 9.2.0.5.0

System Copy Method

ORABRCOPY

System Copy / Backup Restore

While in the Mid of Database Installation, it has stopped for Data copy.

We have carried out offline backup and copied the SAP directories of the source system as mentioned in the System copy Guide for Webas640.

We performed the Datacopy, control files, init<sid>.ora files and continued..

It has stopped in the following error :

ORA-1194 : file 1 needs more recovery to be consistent

ORA-0110 : data file 1: 'I:\ORACLE\W10\SAP\DATA1\SYSTEM_1\SYSTEM.DATA1'

Could you please help to solve this error ..

Thanks a million in advance..

Best Regards

Paguras

[andreas_herzog]

-> your datafiles are not consistant

-> you will need to apply sufficient archived redo logs before you can open with resetlogs

-> copy over the logs

-> recover your database (might be <i>recover database using backup controlfile until cancel</i>)

-> have a look at sapnotes 4164, 43490

GreetZ, AH