Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Restoring old Oracle6 db (unix aix3.2) URGENT...

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

From: Surendra_Tirumala <Surendra_Tirumala_at_hht.satyam.com>
Date: Fri, 30 Jun 2000 01:16:53 +0530
Message-Id: <10543.110820@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_01BFE202.CC1A2130
Content-Type: text/plain

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.
> 
> 
> 
> 

------_=_NextPart_001_01BFE202.CC1A2130
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Restoring old Oracle6 db (unix aix3.2) URGENT...</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Mehul,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">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</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Surendra</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">OCP,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Satyam =
India.</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Mehul Zaveri</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Reply To:</FONT></B> =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D1 FACE=3D"MS Sans = Serif">ORACLE-L_at_fatcity.com</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Sent:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Friday, June 30, 2000 1:17 =
AM</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">To:</FONT></B> =
&nbsp;&nbsp;&nbsp; <FONT SIZE=3D1 FACE=3D"MS Sans Serif">Multiple = recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Subject:</FONT></B> =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D1 FACE=3D"MS Sans = Serif">Restoring old Oracle6 db (unix aix3.2) URGENT...</FONT>
</P>

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

<P><FONT SIZE=3D2 FACE=3D"Arial">Appreciate if somebody can highlight. =
I am really in big trouble.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Mehul.</FONT>
Received on Thu Jun 29 2000 - 14:46:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US