Re: recovery

From: <randy.justice_at_smtp.cnet.navy.mil>
Date: Tue, 02 Feb 1999 17:57:05 GMT
Message-ID: <797e9a$fom$1@nnrp1.dejanews.com>

In article <36B39D85.73AB_at_oriolecorp.com>,   sfaroult_at_oriolecorp.com wrote:
> randy.justice_at_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 Received on Tue Feb 02 1999 - 11:57:05 CST