If they're just renaming the disks where the datafiles reside, then the
backup controlfile is the way to go.
However, if they're renaming the disk where the Oracle Home resides, then
you need to go edit the registry. Be sure and make a backup of the
registry before you start the edit.
Unasked,
PROTECTED]
Sent by: cc:
root@fatcity.Subject: Oracle8i on WinNT - renaming
d
Ron,
You're making this way too dificult.
To reorg the drive names on NT/2000:
1. Backup your database (just a good thing to do)
2. ALTER DATABASE BACKUP CONTROLFILE TO TRACE; - Generates a
script with all the datafiles listed in it.
3. Edit init.ora and any ifile linked configs t
If by "rename disk drives" means changing the drive letter where Oracle is
installed. You may have to re-install Oracle since the regisry will now
have the wrong values.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 441
Ron,
When you say log files in the init.ora I assume you mean archive log files.
(Mr. P. Dantic)
Anyway, getting back to the task at hand, a far easier way to do it is to
issue a backup controlfile to trace. Change the location of the files in the
trace file you have generated, shutdown the DB,
Sonja,
It is a complicated process to rename disk drives in the Oracle environment.
Depending in the drives that Oracle uses and what are changes(renamed) could really
cause you frustration.
The initxxx.ora lists the current location of the controlfiles, logfiles, dump dirs,
trace dirs, etc.
Sonja,
you're right, you must recreate your controlfiles.
And check if the drive name of the directory where your ORACLE_HOME lies
is changing: then you also have to change the registry (:-| and your path
I would not recommand it.
Stephan
-Original Message-
Sent: Wednesday, November 28,
List hi!
Oracle 8.1.7 on WinNT.
Our Windows guys want to rename disc drives for some administration reasons.
I'm really in UNIX so I'm wondering could you give me some advices on this
matter.
As far as I know, I have to recreate control files, with new drives. Is
there anything else I should do?