Message-Id: <10543.110837@fatcity.com> From: "Mehul Zaveri" Date: Fri, 30 Jun 2000 01:27:40 +0400 Subject: 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. ----- Original Message -----=20 From: Surendra_Tirumala=20 To: Multiple recipients of list ORACLE-L=20 Sent: Friday, June 30, 2000 12:56 AM Subject: RE: Restoring old Oracle6 db (unix aix3.2) URGENT... 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@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 RE: Restoring old Oracle6 db (unix aix3.2) = URGENT...
Noops,
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.
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.
 
----- Original Message -----
From:=20 Surendra_Tirumala
To: Multiple recipients of list ORACLE-L =
Sent: Friday, June 30, 2000 = 12:56=20 AM
Subject: RE: Restoring old = Oracle6 db=20 (unix aix3.2) URGENT...

Mehul,
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

Surendra =
OCP,
Satyam India.

    ---------- =
    From:   Mehul Zaveri
    Reply To:=20       ORACLE-L@fatcity.com
    Sent:   Friday,=20 June 30, 2000 1:17 AM
    To:     Multiple recipients of list ORACLE-L
    Subject:=20        Restoring old Oracle6 db (unix aix3.2) URGENT... =

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

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