incomplete recovery help

From: Indra Harimurti <indra_at_sofrecom.co.id>
Date: Fri, 27 Oct 2000 16:45:52 +0700
Message-Id: <10662.120411@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C04035.5E7BF440 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20
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 =20 ORA-00289: Suggestion : /data1/USERS/indra/dafarc/ind1_17.dbf = =20 Specify log: {<RET>=3Dsuggested | filename | AUTO | FROM logsource | = CANCEL} =20 Log applied

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

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

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

Indra

------=_NextPart_000_000C_01C04035.5E7BF440 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>Dear DBA,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>I have a problem when doing an =
incomplete=20
recovery test as follows :</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV><FONT color=3D#000000 size=3D2>1. create emp table</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>2. insert 4 records</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>3. alter system switch logfile, =
produced :=20
ind1_17.dbf </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>4. truncate table emp</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>5. alter system switch logfile, =
produced :=20
ind1_18.dbf</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>6. I wanted to recover back to point =

2.</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>7. shutdown db</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>8. restore back datafile from recent =
cold=20
backup</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>9. start sqldba</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>10. startup mount</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>11. recover database until =
cancel</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>ORA-00279: Change 5539 generated at =
10/27/00=20
16:40:09 needed for thread 1   <BR>ORA-00289: Suggestion :=20 /data1/USERS/indra/dafarc/ind1_17.dbf      =         =20
<BR>Specify log: {<RET>=3Dsuggested | filename | AUTO | FROM =
logsource |=20
CANCEL}  </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2>Log applied</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV>
<DIV>
<DIV><FONT color=3D#000000 size=3D2>ORA-00279: Change 5540 generated at =
10/27/00=20
16:40:09 needed for thread 1   <BR>ORA-00289: Suggestion :=20 /data1/USERS/indra/dafarc/ind1_18.dbf      =         =20
<BR>Specify log: {<RET>=3Dsuggested | filename | AUTO | FROM =
logsource |=20
CANCEL}  </FONT></DIV>
<DIV><FONT size=3D2>CANCEL</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>12. alter database open resetlogs</FONT></DIV>
<DIV><FONT size=3D2>ORA-01152: file 1 was not restored from a =
sufficiently old=20
backup     <BR>ORA-01110: data file 1:=20 '/data1/BASE/db716/sys_db716.dbf'      &nbs= p;     =20
<BR></FONT></DIV>
<DIV><FONT size=3D2>Does that I need to restore system datafile =
mentioned above=20
?</FONT></DIV>
<DIV><FONT size=3D2>Please advise. Thanks in advance.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Indra</FONT></DIV></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT> </DIV></BODY></HTML>
Received on Fri Oct 27 2000 - 04:45:52 CDT