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: URGENT: INCOMPLETE RECOVERY

RE: URGENT: INCOMPLETE RECOVERY

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 12 Apr 2007 19:46:50 +0800
Message-id: <001401c77cf8$4231ebd0$6701a8c0@windows01>


select file#, checkpoint_change# from v$datafile_header should provide some insight.  

All checkpoint SCNs for read-write tablespaces should match.  

Tanel.


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Paula Stankus
Sent: Thursday, April 12, 2007 18:21
To: 'oracle-l'
Subject: RE: URGENT: INCOMPLETE RECOVERY  

I cannot open the database with resetlogs. I cannot open it at all. I am getting that error that not all my files are in-synch. sigh.  

Any good ideas out there - maybe I just need another set of eyes. :)  

Thanks,
Paula  

Version 8.1.7.4

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 12 2007 - 06:46:50 CDT

Original text of this message

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