Re: Oracle 7.3 logfile removed...How 2 Recreate/Clear/Ignore it?

brandon__at_NO_vv.com_SPAM.NET wrote:
Hi Brendon,

try this:

copy /opt/oracle7/dbs/log1WG73.dbf to /opt/oracle7/dbs/log2WG73.dbf then startup db

>
> Hello, everyone. I'm new to the world of Oracle and am slowly
> making my way through it. I've created my own database which works
> great, but in the process I've stepped on one of the logfiles of the
> sample workgroup database that Oracle creates during a fresh
> installation.
>
> The error I get is below and yes, the file doesn't exist because I
> intentionally wiped it. The error used to be 'such-n-such logfile
> belongs to another database'. What I'm looking for is a way to recreate,
> clear, ignore or reinit this logfile. I've looked at the ALTER DATABASE
> SQL command however, it won't let me DROP or CLEAR this particular
> logfile because it's set 'CURRENT'...If I try to ADD, it says it already
> exists... The 'WG73' (the default one created under Solaris x86)
> database refuses to come up because of this error.
>
> If someone could point me in the right direction, I'd much
> appreciate it. I'm trying to work all these bugs out before I actually
> have data I'm worried about... Thanks.
>
> ORA-00313: open failed for members of log group 2 of thread 1
> ORA-00312: online log 2 thread 1: '/opt/oracle7/dbs/log2WG73.dbf'
> ORA-07360: sfifi: stat error, unable to obtain information about file.
> Intel SVR4 UNIX Error: 2: No such file or directory
>
> brandon__at_NO_vv.com_SPAM.NET (uh, just remove the words in caps to reply)
 

-- 
Regards

Matthias Gresz    :-)