Xref: alice comp.databases.oracle.server:39583
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: randy.justice@smtp.cnet.navy.mil
Newsgroups: comp.databases.oracle.server
Subject: Re: recovery
Date: Tue, 02 Feb 1999 17:57:05 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 79
Message-ID: <797e9a$fom$1@nnrp1.dejanews.com>
References: <78sqlm$qsr$1@nnrp1.dejanews.com> <36B39D85.73AB@oriolecorp.com>
X-Article-Creation-Date: Tue Feb 02 17:57:05 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.0 x11.dejanews.com:80 (Squid/1.1.22) for client 160.125.255.11

In article <36B39D85.73AB@oriolecorp.com>,
  sfaroult@oriolecorp.com wrote:
> randy.justice@smtp.cnet.navy.mil wrote:
> >
> > Hi..
> >
> > I had a disk to die.   It contained the "redo" logs.
> > How do I recover??
> >
> > Thanks in advanced
> >
> > Randy
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own
> See 'ALTER DATABASE' in the SQL reference manual, your solution is
> probably there.
>
> 1) Do you have several members in your redo log groups? (in other words,
> are your redo log files mirrored [by Oracle] on several disks?). If this
> is the case, startup your database without opening it (startup mount),
> and drop the redo log file members which were on your now defunct disk
> before opening the database.
>  2) If the answer to previous question is 'No', I presume you weren't
> working in archive log mode, either? I am afraid you are going to lose
> all the (committed) transactions which occurred since the last
> checkpoint. Polish your diplomatic skills before going to users. You can
> use the 'RESETLOGS' keyword to reopen your database and forget about
> what was in the current logfile.
>
> --
> Regards,
>
>   Stéphane Faroult
>   Oriole Corporation
>

Hi

I should be doing the following:
     1. Connect internal
     2. Startup Mount
     3. Recover database until cancel
     4. alter database open resetlogs

I get the following results:

SVRMGR> startup mount
ORACLE instance started.
Total System Global Area                         15077376 bytes
Fixed Size                                          49152 bytes
Variable Size                                    12906496 bytes
Database Buffers                                  2048000 bytes
Redo Buffers                                        73728 bytes
Database mounted.
SVRMGR> recover database until cancel;
ORA-00279: change 83063 generated at 02/02/99 09:37:38 needed for thread 1
ORA-00289: suggestion : C:\ORANT\RDBMS80\ARC7.1
ORA-00280: change 83063 for thread 1 is in sequence #7
 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log 'C:\ORANT\RDBMS80\ARC7.1'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:\ORANT\DATABASE\SYS1ORCL.ORA'
SVRMGR>

I can't get past step 3.
I have tried recover tablespace too.

Thanks for your help.

Randy Justice

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own