| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restoring old Oracle6 db (unix aix3.2) URGENT...
This is a multi-part message in MIME format.
------=_NextPart_000_0233_01BFE232.62028E00 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
RE: Restoring old Oracle6 db (unix aix3.2) URGENT...Noops, there is no arc. activated. Only cold backup (files are surely not = modified. This is old legacy, whose data is not migrated to Oracle = financials. and is just used for quering. I need some info about the undocumented header structure of datafiles = and controlfiles. Thereafter small piece of C code or mixture of unix = tools can make wonders.
Mehul,=20
There is only one way to make your database up..that is by recovering =
the files restored from older copies to the timestamp of the file =
restored from latest copy.Ofcourse this is possible only if you have all =
the arc files intact from the timestamp at which you have oldest =
datafile to the timestamp at which you have the latest datafile
Surendra=20
OCP,=20
Satyam India.=20
----------=20
From: Mehul Zaveri=20
Reply To: ORACLE-L_at_fatcity.com=20
Sent: Friday, June 30, 2000 1:17 AM=20
To: Multiple recipients of list ORACLE-L=20
Subject: Restoring old Oracle6 db (unix aix3.2) URGENT...=20
Dear friends,=20
I am not able to start one very old Oracle6 DB restored recently. =
This is=20
due to the mismatches in data files (files were (cold) backed up at=20
different dates)=20
I understand that it is impossible in normal cases. Is there any =
method=20
(documented/undocumentd) to force the start (let some objects be in=20
unpredicatble state!)=20
Can we change some bytes in header of datafiles / controlfiles to =
make=20
them sync to system.dbf or something like that.=20
Appreciate if somebody can highlight. I am really in big trouble.=20
Mehul.=20
------=_NextPart_000_0233_01BFE232.62028E00 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Restoring old Oracle6 db (unix aix3.2) =
URGENT...</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Noops,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>there is no arc. activated. Only cold =
backup (files=20
are surely not modified. This is old legacy, whose data is not migrated =
to=20
Oracle financials. and is just used for quering.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I need some info about the undocumented =
header=20
structure of datafiles and controlfiles. Thereafter small piece of C =
code or=20
mixture of unix tools can make wonders.</FONT></DIV>
<DIV> </DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:Surendra_Tirumala_at_hht.satyam.com"=20
title=3DSurendra_Tirumala_at_hht.satyam.com>Surendra_Tirumala</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, June 30, 2000 =
12:56=20
AM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Restoring old =
Oracle6 db=20
(unix aix3.2) URGENT...</DIV>
<DIV><BR></DIV>
<P><FONT color=3D#0000ff face=3DArial size=3D2>Mehul,</FONT> <BR><FONT =
color=3D#0000ff=20
face=3DArial size=3D2>There is only one way to make your database =
up..that is by=20
recovering the files restored from older copies to the timestamp of =
the file=20
restored from latest copy.Ofcourse this is possible only if you have =
all the=20
arc files intact from the timestamp at which you have oldest datafile =
to the=20
timestamp at which you have the latest datafile</FONT></P>
<P><FONT color=3D#0000ff face=3DArial size=3D2>Surendra</FONT> =
<BR><FONT=20
color=3D#0000ff face=3DArial size=3D2>OCP,</FONT> <BR><FONT =
color=3D#0000ff face=3DArial=20
size=3D2>Satyam India.</FONT> </P>
<UL>
<P><FONT face=3D"MS Sans Serif" size=3D1>----------</FONT> =
<BR><B><FONT=20
face=3D"MS Sans Serif" size=3D1>From:</FONT></B> <FONT=20
face=3D"MS Sans Serif" size=3D1>Mehul Zaveri</FONT> <BR><B><FONT=20
face=3D"MS Sans Serif" size=3D1>Reply To:</FONT></B>=20
<FONT face=3D"MS Sans Serif"=20
size=3D1>ORACLE-L_at_fatcity.com</FONT> <BR><B><FONT face=3D"MS Sans =
Serif"=20
size=3D1>Sent:</FONT></B> <FONT face=3D"MS Sans Serif" = size=3D1>Friday,=20
June 30, 2000 1:17 AM</FONT> <BR><B><FONT face=3D"MS Sans Serif"=20 size=3D1>To:</FONT></B> <FONT face=3D"MS Sans = Serif"=20
size=3D1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT=20
face=3D"MS Sans Serif" size=3D1>Subject:</FONT></B>=20
<FONT face=3D"MS Sans Serif"=20
size=3D1>Restoring old Oracle6 db (unix aix3.2) URGENT...</FONT> =
</P>
<P><FONT face=3DArial size=3D2>Dear friends,</FONT> <BR><FONT = face=3DArial=20
size=3D2>I am not able to start one very old Oracle6 DB restored = recently.=20
This is</FONT> <BR><FONT face=3DArial size=3D2>due to the mismatches = in data=20
files (files were (cold) backed up at</FONT> <BR><FONT face=3DArial=20 size=3D2>different dates)</FONT> <BR><FONT face=3DArial size=3D2>I = understand that=20
it is impossible in normal cases. Is there any method</FONT> =
<BR><FONT=20
face=3DArial size=3D2>(documented/undocumentd) to force the start = (let some=20
objects be in</FONT> <BR><FONT face=3DArial size=3D2>unpredicatble=20 state!)</FONT> <BR><FONT face=3DArial size=3D2>Can we change some = bytes in=20
header of datafiles / controlfiles to make</FONT> <BR><FONT = face=3DArial=20
size=3D2>them sync to system.dbf or something like that.</FONT> </P> <P><FONT face=3DArial size=3D2>Appreciate if somebody can highlight. = I am really=20
in big trouble.</FONT> </P> Received on Thu Jun 29 2000 - 16:27:40 CDT
 |
 |