[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | Oracle |
| Notice: | For product status see topics: UNIX 1008, OpenVMS 1009, NT 1010 |
| Moderator: | EPS::VANDENHEUVEL |
|
| Created: | Fri Aug 10 1990 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1574 |
| Total number of notes: | 4428 |
1510.0. "Change disk name on OpenVMS. Does it affect the database?" by MXOC00::NOGUERON () Thu Feb 06 1997 19:18
Hi,
I need to reconfigure a system at a customer site. This will represent that a
disk which is currently DKI100 becomes DKF100. This disk contains an Oracle
database.
I am not quite good in Oracle, but I understand that there is a configuration
file where you can change the name of the disk in which the database resides.
The customer knows pretty well how to do this.
My concern is that the local Oracle guys in Mexico City told the customer that
this change cannot be done because the database will be lost. Another option
I suggested was to use a logical name defined with options /executive and
/translation=concealed, but the Oracle people claims that Oracle uses the
physical device name, so the logical would not work.
Like I said, I don't know so much about Oracle, but from what I know from
OpenVMS, I believe that there should be a way to perform this change without
having to recreate the database from scratch.
Can somebody provide any alternatives and/or explanations?
Thanks,
David
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1510.1 | Software versions | MXOC00::NOGUERON | | Thu Feb 06 1997 19:19 | 6 |
| Sorry,
We are using OpenVMS 6.2-1H3 and Oracle 7.1.5.2.3 on an Alphaserver 8400.
David
|
| 1510.2 | Logical Names are OK | MUNICH::KONOPIK | It's all magic ... | Fri Feb 07 1997 05:42 | 6 |
| To use a concealed logical name as you described in 0. should be OK.
However be sure there will not be new disk with the old (DKI100)
name. Alternatively you can rename the file names within Oracle
using the 'ALTER DATABASE ... RENAME ...' command.
-Georg
|
| 1510.3 | Make sure that your tablespaces are defined correctly also | KYOSS1::POLAKOWSKI | One of Us is Over 40 | Wed Feb 19 1997 15:38 | 13 |
|
This is a little late, but I've been on vacation and away
from notes since the 7th. You can change the device
specification provided that you have defined the devices
where the data base and tablespaces reside as concealed
and terminal in the logical names. You can change this
after the fact by issuing the appropriate alter tablespace
and alter database commands.
Ken
|