RE: Restoring old Oracle6 db (unix aix3.2) URGENT...

From: Philip West <P.West_at_g-icap.com>
Date: Fri, 30 Jun 2000 14:37:08 +0100
Message-Id: <10544.110910@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_01BFE29B.A1A921CC
Content-Type: text/plain;

charset="iso-8859-1"

Why not start up mount and take the dodgy files offline?

Regards

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

[ all opinions - unless otherwise stated - may be ill-informed and will be defended as such! ]

-----Original Message-----
From: Mehul Zaveri [mailto:mehuldba_at_hotmail.com] Sent: 29 June 2000 23:45
To: Multiple recipients of list ORACLE-L Subject: 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.

Original Message -----

From: Surendra_Tirumala <mailto:Surendra_Tirumala_at_hht.satyam.com> To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com> Sent: Friday, June 30, 2000 12:56 AM
Subject: RE: Restoring old Oracle6 db (unix aix3.2) URGENT...

Mehul,
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
OCP,
Satyam India.

From: Mehul Zaveri
Reply To: ORACLE-L_at_fatcity.com
Sent: Friday, June 30, 2000 1:17 AM

To:     Multiple recipients of list ORACLE-L 
Subject:        Restoring old Oracle6 db (unix aix3.2) URGENT... 

	Dear friends,

I am not able to start one very old Oracle6 DB restored recently. This is due to the mismatches in data files (files were (cold) backed up at different dates)
I understand that it is impossible in normal cases. Is there any method (documented/undocumentd) to force the start (let some objects be in unpredicatble state!)
Can we change some bytes in header of datafiles / controlfiles to make them sync to system.dbf or something like that.

Appreciate if somebody can highlight. I am really in big trouble.

Mehul.

The information in this Internet e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.

------_=_NextPart_001_01BFE29B.A1A921CC
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">
<TITLE>RE: Restoring old Oracle6 db (unix aix3.2) URGENT...</TITLE>

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

<BODY bgColor=#ffffff>
<DIV>Why not start up mount and take the dodgy files offline?</DIV>

<DIV>&nbsp;</DIV>
<P><FONT face=Arial size=2>Regards</FONT> </P>
<P><FONT face=Arial>Phil West - Impex IT ltd</FONT> <BR><FONT

face="Arial Narrow" size=1>Unix Sys Admin and Oracle Financials DBA Services 
[  all opinions - unless otherwise stated -  may be  ill-informed and will be defended as such!  ] <DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Mehul Zaveri [mailto:mehuldba_at_hotmail.com] Sent: 29 June 2000 23:45 To: Multiple recipients of list ORACLE-L Subject: Re: Restoring old Oracle6 db (unix aix3.2) URGENT... </DIV> <DIV>Noops,</DIV> <DIV>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.</DIV> <DIV>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.</DIV>

<DIV>&nbsp;</DIV>
<DIV>----- Original Message ----- </DIV>
<BLOCKQUOTE

style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> <DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A href="mailto:Surendra_Tirumala_at_hht.satyam.com" title=Surendra_Tirumala_at_hht.satyam.com>Surendra_Tirumala</A> </DIV> <DIV style="FONT: 10pt arial">To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> </DIV>

  <DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 30, 2000 12:56 
AM</DIV>
  <DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Restoring old Oracle6 db

(unix aix3.2) URGENT...</DIV>
 <DIV> </DIV>
 Mehul, 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 OCP, Satyam India. 
 <UL>
 ---------- <FONT

    face="MS Sans Serif" size=1>From:</FONT></B> &nbsp; <FONT 
    face="MS Sans Serif" size=1>Mehul Zaveri</FONT> <BR><B><FONT 
    face="MS Sans Serif" size=1>Reply To:</FONT></B>

ORACLE-L_at_fatcity.com Sent:   Friday, June 30, 2000 1:17 AM <FONT face="MS Sans Serif"

    size=1>To:</FONT></B> &nbsp;&nbsp;&nbsp; <FONT face="MS Sans Serif" 
    size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT 
    face="MS Sans Serif" size=1>Subject:</FONT></B>

Restoring old Oracle6 db (unix aix3.2) URGENT... Dear friends, I am not able to start one very old Oracle6 DB restored recently. This is due to the mismatches in data files (files were (cold) backed up at different dates) I understand that it is impossible in normal cases. Is there any method (documented/undocumentd) to force the start (let some objects be in unpredicatble state!) Can we change some bytes in header of datafiles / controlfiles to make them sync to system.dbf or something like that.

    <P><FONT face=Arial size=2>Appreciate if somebody can highlight. I am really 
    in big trouble.</FONT> </P>
    <P><FONT face=Arial size=2>Mehul.</FONT>

</UL></BLOCKQUOTE><CODE> 
******************************************************************************* 
The information in this Internet e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients. 
Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc. Received on Fri Jun 30 2000 - 08:37:08 CDT