[daniesh]

Hi Amit,

please find the error below.

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

ORA-01110: data file 1: ‘C:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF’

Thanks.

[daniesh]

Hi Amit,

Thanks for the input.

I am using hot backup.

The steps which i am following is

1. alter system switch logfile;(2-3 times)

2.Taking the database in backup mode

3.copy all the datafiles from source to target server.

4.alter system switch logfile;(2-3 times)

5.alter database backup controlfile to trace;

to generate a trace of the control file

go to the udump location and copy the last trace file

make chages and generate the control file script

for e.g

copy the contents of trace file from create controifile reuse….. character set

and made some changes like inplace of reuse i write set as i am my database name is different from the source one.

save the file as create.sql

on target server:

set the sid of target db.

then conect to database using sqlplus

create the dir udump, bdump and cdump.

copy the pfile from the source database to the target database and made changes accordingly like dbname , path of controlfile as i am using different location for control file.

startup the database in nomount stage

run the script which i generated in step 5.

on sql prompt i got the result as file created.

now when i try to open the database using reset log option

alter database open resetlogs;

now i am getting an error that system01.dbf needs recovery.

when i execute the conmmand

recover database using backup controlfile until cancel;

again i am getting an error.

the error is

ORA-01110

i didnt remember the error exactly.

I have one doubt if i will not copy the online redo log then how it will get generated.

Please help me on this.

Thanks

Daniesh

[Author]

Posts