Renaming datafiles on 7.1/OpenVMS 
Author Message
 Renaming datafiles on 7.1/OpenVMS
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



Mon, 23 Apr 2001 03:00:00 GMT
 Renaming datafiles on 7.1/OpenVMS

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

Quote:

> 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



Mon, 23 Apr 2001 03:00:00 GMT
 Renaming datafiles on 7.1/OpenVMS
Did you rename the files in Oracle or only at the OS level?  The alter
database command includes a syntax for renaming files as does the alter
tablespace command.  Both of these commands will update the control file as
necessary.
I have used the alter database command to take files offline so Oracle
would start clean and then used other commands like alter and create
tablespace to fix the damage.  That would be the approach that I would
take.  You could get Oracle to dump the control file to text, modify it
with the new filenames, and re-create the control file, but I do not
recommend this approach unless you have trouble trying the other method.



Quote:
> 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



Mon, 23 Apr 2001 03:00:00 GMT
 Renaming datafiles on 7.1/OpenVMS
On Thu, 05 Nov 1998 20:28:34 +0100, Sybrand Bakker

Quote:

>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.

Sorry, I didn't make myself clear eanough. I have already copied the
files using the OS commands to the appropriate places, mounted the
database, and used the ALTER DATABASE RENAME FILE <> to <> to change
the datafiles as well.

The reason for my question about the control file is that in
RevealNet's DBA knowledge base it says that if you are renaming the
system tablespace, or renaming multiple tablespaces at one you should
'Alter the database to backup the control file.'

Also, when I do a hex dump of the control file I can still see the
name of the original device on which the disk was stored.

However, saying that, the database will start and appears to run fine.

Quote:
>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.

That is something I was wondering about. Does Oracle stop at the
logical name, or will it try to resolve it to the actual device? I
can't find anything about that in the documentation...

Would you recommend using concealed logigals for the disk names?

james



Tue, 24 Apr 2001 03:00:00 GMT
 Renaming datafiles on 7.1/OpenVMS
Hi James,
That knowledge base is correct though a bit unclear.
You need to issue the command

alter database backup controlfile to '<a filename>' | trace

after any changes for like you just made. The reason for this is simple: if
the database crashes and you loose the controlfile, you can't use an old
backupped controlfile, because of the changes.
The remnants of old filenames in the control file seem to be 'normal', I have
been looking at similar dumps.

The concealed logicals: I now remember there has been an issue there. But
then as far as I remember they changed that and logicals are stored
untranslated in the control file. In that time I worked for a firm with a
disaster recovery contract. The situation there was completely different, and
hardcoded drivenames initially even prevented us from VMS getting up and
running with our own software. If Oracle doesn't translate concealed logical,
yes in that case I would use them to avoid problems with upgrading, plugging
in new disks and disaster recovery.

Hth,
Sybrand Bakker, Oracle DBA

Quote:

> On Thu, 05 Nov 1998 20:28:34 +0100, Sybrand Bakker

> >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.

> Sorry, I didn't make myself clear eanough. I have already copied the
> files using the OS commands to the appropriate places, mounted the
> database, and used the ALTER DATABASE RENAME FILE <> to <> to change
> the datafiles as well.

> The reason for my question about the control file is that in
> RevealNet's DBA knowledge base it says that if you are renaming the
> system tablespace, or renaming multiple tablespaces at one you should
> 'Alter the database to backup the control file.'

> Also, when I do a hex dump of the control file I can still see the
> name of the original device on which the disk was stored.

> However, saying that, the database will start and appears to run fine.

> >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.

> That is something I was wondering about. Does Oracle stop at the
> logical name, or will it try to resolve it to the actual device? I
> can't find anything about that in the documentation...

> Would you recommend using concealed logigals for the disk names?

> james



Tue, 24 Apr 2001 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Move Oracle 7.1 on OpenVMS 6.1 to 7.1 VAX

2. RDBMS 7.1 on OpenVMS 7.1

3. RDBMS 7.1 on OpenVMS 7.1

4. ORA-07690 on OpenVMS 7.1

5. TNS 12203 with SQLNET-TCPIP and OPENVMS 7.1

6. SQL*NET - OpenVMS 7.1 long connect time

7. Forms 3.O on OpenVMS 7.1?

8. OpenVMS 7.1 error

9. Oracle 7.3 and OpenVMS 7.1 FAST I/O

10. TNS 12203 SQLNET - TCPIP - OPENVMS 7.1


 
Powered by phpBB® Forum Software