RE: Read only tablespace ORA-01251: Unknown File Header Version r ead for file number

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Mon, 10 May 2004 10:11:16 -0400
Message-ID: <6362087FB073D41195B800D0B78284BE0621CA06@mail01.corp.abwf.com>

Juan,

Find out whether datafile needs recovery or not by selecting V$DATAFILE_HEADER.

Muqthar

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Cachito Reyes Pacheco Sent: Friday, May 07, 2004 6:44 PM
To: oracle-l_at_freelists.org
Subject: Read only tablespace ORA-01251: Unknown File Header Version read for file number

Hi I don't know if you know please how to fix this error ORA-01251: Unknown File Header Version read for file number

The datafiles was copied, but for some reason in windows xp, (problem didn't happen with other databases), can recognize a readonly datafile, then the tablespace was offile, copying again and trying to put online I got the previous error.

The datafile is there, all is ok, v$datafile checked, etc., I don't know if there is a trick to fix it.

Thanks

Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

* * * * * * * *

The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Mon May 10 2004 - 12:49:47 CDT