Urgent!!! ORA-01113 file 1 needs media recovery

[samdba]

Hi there,

We are on 805/NT. I am performing Cold backup recovery test on Testing server.

I did the following.

1. Shutdown database/instance.
2. Zipped all datafiles, control files, redo log files and everything.
3. Renamed all *.dbf files and redo log files to *.bdf files as if they are deleted.
4. Unzipped everything from zip file zipped in step 2.
5. Tried to start the database. It gave foll. message.

ORA-01113 file 1 needs media recovery.
ORA-01110: data file 1: 'E:\...system1.dbf'.

Now, I have one database in *.bdf form on to the server itself and another database in zip form.

What are the options available to me do to cleanly startup the database.

Thanks in Adv.

[samdba]

I checked that I did not unzip one copy of control file. Is it due to that it gives the error?

If yes, I can delete unzipped files and again do unzip with both copies of control files.

pl. advise ASAP.

Thanks,

[Mr.Hanky]

Sam, this one is clearly over my head but I am fairly certain that you need ALL control files for the DB to open.

MH

[Mr.Hanky]

My Bad; You only need one copy of the control file to open, since they are so small why not just copy it over without zipping it. This way you are eliminating that as a possible cause of corruption.

Have you tried renaming the datafile to .DBF, if that is specified in the control file, than that is what oracle is looking for, no?

MH

[samdba]

Hi,
I commented another control file in init.ora and tried to open the DB with only one control file which was unzipped. but still giving the same err. msg.

Thanks,

[anandkl]

Retry to unzip all the files you ziped in you first step.Make sure all the files are there as it was earlier.Then start up the database it should work..

cheese
anandkl

[jovery]

Are you sure the database closed cleanly, did you shut it down with an immediate or normal?

It might be worth checking the alert log to make sure.

Regards

[samdba]

Jovery,

Database was closed with 'immediate' option.

Will this create problem when we restore and try to open the database next time?

Thanks,

[jovery]

Immediate should not cause you any problems with recovery, but I have seen this problem before when the DBA used shutdown abort.

Does the original database still work okay when you copy the files back?

Regards

[ac]

Hi Samba,

Did you solve the problem and if yes how?. Coincidentally I have the same error message as you did in the beginning but I didn't do any zip etc.

AC