RE: incomplete recovery help

From: Hamid Alavi <HamidA_at_aimdirect.co.nz>
Date: Tue, 31 Oct 2000 11:01:16 +1300
Message-Id: <10665.120617@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C042BF.FB93FC30
Content-Type: text/plain;

charset="iso-8859-1"

imdra,
i had similar problem on my dev database you have to add this to your ini_sid.ora(init file) _allow_resetlogs_corruption=TRUE shutdown immediate
startup mount
then recover the database with resetlogs

-----Original Message-----
From: Indra Harimurti [mailto:indra_at_sofrecom.co.id] Sent: Saturday, 28 October 2000 01:18
To: Multiple recipients of list ORACLE-L Subject: incomplete recovery help

Dear DBA,
I have a problem when doing an incomplete recovery test as follows :

create emp table
insert 4 records
alter system switch logfile, produced : ind1_17.dbf
truncate table emp
alter system switch logfile, produced : ind1_18.dbf
I wanted to recover back to point 2.
shutdown db
restore back datafile from recent cold backup
start sqldba
startup mount
recover database until cancel ORA-00279: Change 5539 generated at 10/27/00 16:40:09 needed for thread 1 ORA-00289: Suggestion : /data1/USERS/indra/dafarc/ind1_17.dbf Specify log: {<RET>=suggested | filename | AUTO | FROM logsource | CANCEL} Log applied

ORA-00279: Change 5540 generated at 10/27/00 16:40:09 needed for thread 1 ORA-00289: Suggestion : /data1/USERS/indra/dafarc/ind1_18.dbf Specify log: {<RET>=suggested | filename | AUTO | FROM logsource | CANCEL} CANCEL

alter database open resetlogs ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/data1/BASE/db716/sys_db716.dbf'

Does that I need to restore system datafile mentioned above ? Please advise. Thanks in advance.

Indra

------_=_NextPart_001_01C042BF.FB93FC30
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>

<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=507490722-30102000>imdra,</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=507490722-30102000>i had similar problem on my dev database you have to add this to your ini_sid.ora(init file) _allow_resetlogs_corruption=TRUE</SPAN></FONT></DIV>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=507490722-30102000>shutdown immediate</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN

class=507490722-30102000>startup mount</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=507490722-30102000>then recover the database with resetlogs</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=507490722-30102000></SPAN></FONT> </DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=507490722-30102000></SPAN></FONT> </DIV> <BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Indra Harimurti [mailto:indra_at_sofrecom.co.id]<BR><B>Sent:</B> Saturday, 28 October 2000 01:18<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>

  incomplete recovery help<BR><BR></DIV></FONT>

<DIV><FONT color=#000000 size=2>Dear DBA,</FONT></DIV>
<DIV><FONT color=#000000 size=2>I have a problem when doing an incomplete
  recovery test as follows :</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV><FONT color=#000000 size=2>1. create emp table</FONT></DIV>
<DIV><FONT color=#000000 size=2>2. insert 4 records</FONT></DIV>
<DIV><FONT color=#000000 size=2>3. alter system switch logfile, produced :
  ind1_17.dbf </FONT></DIV>
<DIV><FONT color=#000000 size=2>4. truncate table emp</FONT></DIV>
<DIV><FONT color=#000000 size=2>5. alter system switch logfile, produced :
  ind1_18.dbf</FONT></DIV>
<DIV><FONT color=#000000 size=2>6. I wanted to recover back to point
  2.</FONT></DIV>
<DIV><FONT color=#000000 size=2>7. shutdown db</FONT></DIV>
<DIV><FONT color=#000000 size=2>8. restore back datafile from recent cold
  backup</FONT></DIV>
<DIV><FONT color=#000000 size=2>9. start sqldba</FONT></DIV>
<DIV><FONT color=#000000 size=2>10. startup mount</FONT></DIV>
<DIV><FONT color=#000000 size=2>11. recover database until cancel</FONT></DIV>
<DIV><FONT color=#000000 size=2>ORA-00279: Change 5539 generated at 10/27/00
  16:40:09 needed for thread 1   <BR>ORA-00289: Suggestion :   /data1/USERS/indra/dafarc/ind1_17.dbf              
<BR>Specify log: {<RET>=suggested | filename | AUTO | FROM logsource |
  CANCEL}  </FONT></DIV>
<DIV><FONT color=#000000 size=2>Log applied</FONT></DIV>
<DIV><FONT color=#000000 size=2></FONT> </DIV>
<DIV>
<DIV><FONT color=#000000 size=2>ORA-00279: Change 5540 generated at 10/27/00
  16:40:09 needed for thread 1   <BR>ORA-00289: Suggestion :   /data1/USERS/indra/dafarc/ind1_18.dbf              
<BR>Specify log: {<RET>=suggested | filename | AUTO | FROM logsource |
  CANCEL}  </FONT></DIV>
<DIV><FONT size=2>CANCEL</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=2>12. alter database open resetlogs</FONT></DIV>
<DIV><FONT size=2>ORA-01152: file 1 was not restored from a sufficiently old
  backup     <BR>ORA-01110: data file 1:   '/data1/BASE/db716/sys_db716.dbf'            
<BR></FONT></DIV>
<DIV><FONT size=2>Does that I need to restore system datafile mentioned above
  ?</FONT></DIV>
<DIV><FONT size=2>Please advise. Thanks in advance.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Indra</FONT></DIV></DIV>
Received on Mon Oct 30 2000 - 16:01:16 CST