Re: urgent - can't do anything till fixed

Kev,
 Hi. You can do a shutdown abort first. Then you can go and modify your init.ora or config.ora to reflect the backup controlfile (if you have one) and then do a startup nomount from svrmgrl. If this succeeds then do a
  alter database mount.
If this succeeds then do a
  alter database open.
If all these three succeed then you have it made. In any case this is a very good Backup and Recovery experience.

                                Tapan H Trivedi

kev wrote:
>
> Hi Oracle Jedi's,
>
> I'm trying to create a DB with a creation script. In between runs, I
> deleted the necessary files before doing a shutdown, so now whenever I
> try to do anything I get (for example):
>
> SVRMGR> shutdown
> ORA-00210: cannot open the specified controlfile
> ORA-00202: controlfile: '/u02/oradata/WWS/control01.ctl'
> ORA-27041: unable to open file
> Linux Error: 2: No such file or directory
> Additional information: 3
>
> because it can't find the files I've deleted. What do I do? I can't do
> anything until I fix this :-(
>
> quick help very much appreciated,
>
> - Kev

Received on Wed Aug 18 1999 - 12:07:23 CDT