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