Problem while doing recovery using backup controlfile

[jee]

Hi all,

1. I have created a new controlfile using the create controlfile command.

2. while opening the db , I got the following error.
ORA-01113 File 1 needs media recovery
ORA-01110 data fiel 1: 'e:\test\sys1test.ora'

3. Tried, RECOVER DATABASE USING BACKUP CONTROLFILE;

ORA-00289 suggestion: e:\archive\tests0000000055.arc

But the suggested file is missing , what should i do?

Thanks in advance
Jee

[hnagia]

After creating a new control file you will need to recover the database by typing ( at the server manager ) nomount mode :

Recover Database;

[jm]

you can use
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
press RTN for each arch log
enter "cancel" when the file missing.

[Kishore]

Apply all the archive logs as long as they are available. If you are still concerned about database loss, you may also want to give the present redo log also. Then enter cancel and open the database. It should work.