Message-Id: <10544.110910@fatcity.com> From: Philip West Date: Fri, 30 Jun 2000 14:37:08 +0100 Subject: RE: Restoring old Oracle6 db (unix aix3.2) URGENT... 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@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 To: Multiple recipients of list ORACLE-L 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@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" RE: Restoring old Oracle6 db (unix aix3.2) URGENT...
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@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
To: Multiple recipients of list ORACLE-L
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@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.