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: Restore and Recover Fuzzy datafiles

RE: Restore and Recover Fuzzy datafiles

From: Ian Cary \(C\) <Ian.Cary_at_ordnancesurvey.co.uk>
Date: Thu, 25 May 2006 11:32:35 +0100
Message-ID: <4AA808D68343824E8891632BD448AE6B02C5F72E@OSMAIL.ordsvy.gov.uk>


There is a parameter  

_allow_resetlogs_corruption=TRUE  

That may allow you to open a database that has fuzzy datafiles. I've seen it work when a database has been cloned but someone (not me) had forgotten to issue a begin backup command. I used it to force the database to open as I was sure-ish no work had been done while the datafiles had been copied. Every thing seemed Okay especially as it was only a test database anyhow.  

I believe that if any work has been done and you try and use inconsistent data you will get an ORA-600 type error however you may be able restore something by selecting around the problem i.e. identify the rows that are inconsistent and cause an ORA-600 and don't select them.  

Cheers,  

Ian

.

This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person.

Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 25 2006 - 05:32:35 CDT

Original text of this message

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