Re: Renaming datafiles on 7.1/OpenVMS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 05 Nov 1998 20:28:34 +0100
Message-ID: <3641FC61.BA364C3B@sybrandb.demon.nl>

Yes,
you need to rename the datafiles in the controlfile as well by issuing alter database rename datafile 'xyz' to 'abc'. Of course you will need to issue a startup nomount first (or was it mount). Anyway, the database will definitely not open.
Question: Does VMS still have concealed logicals for every disk? If so I would recommend using them instead of hardcoded disknames like dra0:. I had to rebuild a database once on a different system and hardcoded disknames was one of the biggest issues.

Hth,

Sybrand Bakker, Oracle DBA

James Petts wrote:

> I had a disk go bad, and had to replace it with another. The name of
> the new disk is different from the original. I have renamed the
> datafiles using the appropriate syntax.
>
> Do I need to do anything to the controlfiles?
>
> James
Received on Thu Nov 05 1998 - 13:28:34 CST