Changing datafile.

[Morten Primdahl]

Hi. I'm trying to correct some issues on a very messy NT machine.
Drives C: and D: both hold Oracle installations, it's the 'wrong'
installation that gets run as a service at boot time though. This
began to happen after a faulty OS upgrade *sigh*

What I need to do, is
ALTER TABLESPACE biis RENAME DATAFILE
'C:\orant\database\biis01.dbf' TO
'D:\orant\database\biis01.dbf';

When I try to bring the tablespace online however, I get the
following:

ORA-01122: database file 6 failed verification check
ORA-01110: data file 6: 'D:\ORANT\DATABASE\BIIS01.DBF'
ORA-01251: Unknown File Header Version read for file number 6

I'm really stuck here - I read somewhere that I may need
to edit the control file generated by
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Would I need to just replace the reference to the old datafile
to the new?

Thanks,

Morten

[Nuno Souto]

On Wed, 22 Aug 2001 13:42:23 +0200, Morten Primdahl <mor...@caput.com>
wrote:

>Would I need to just replace the reference to the old datafile
>to the new?
>

I hope you also copied the file across from C: to D:? Renaming
doesn't move it, you have to do so yourself.

Cheers
Nuno Souto
nso...@optushome.com.au.nospam

[Morten Primdahl]

Nuno Souto wrote:
>
> I hope you also copied the file across from C: to D:? Renaming
> doesn't move it, you have to do so yourself.

Yep. The new file already resides on D:

[Nuno Souto]

On Wed, 22 Aug 2001 14:01:50 +0200, Morten Primdahl <mor...@caput.com>
wrote:

Hmmm, the error you have seems to indicate the fil is not what O would
expect it to be. Sort of "different signature", if you get my drift.
You sure nothing else has changed in all that re-arranging of drives?
Like an upgrade to a different version of ORACLE, or a startup with
the fil offline and then trying to bring it back online without
recovery? Sounds like that to me.

Cheers
Nuno Souto
nso...@optushome.com.au.nospam

[Niall Litchfield]

You actually have to move the file from c to d yourself. The most likely
cause of your problem is that the file on d: is not the same as the file on
c:.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Morten Primdahl" <mor...@caput.com> wrote in message
news:3B839F2...@caput.com...

[Norman Dunbar]

Silly question, but did you copy the datafile from C to D when the
database was running ?

Regards,
Norman.

------------------------------------------------------------------------
--------
Norman Dunbar EMail: NDu...@LynxFinancialSystems.co.uk
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. Fax: 0113 201 7265
URL: http://www.LynxFinancialSystems.com
------------------------------------------------------------------------
--------