Re: Replacing a Disk on WinNT

• George Hofilena <GHofilena_at_cnv.org>

> Hi,
>
> We are replacing once of the disks where a mirrored control file and redo
> logs reside, nothing else, with a higher disk capacity.
> I can either use the recommended Oracle approach to moving/relocating
> control
> and redo log files but for my purpose it would seem laborious compared to
> what I am thinking is the quickest. But I need to know whether you agree
> to this.
>
> This is what I intend to do:
>
> 1. Shutdown the database
> 2. Make a full backup.
> 3. Copy the control and redo log files on Disk A to Disk B
> 4. Replace Disk A (Disk A wiil have the same drive letter/designation)
> 5. Copy control and redo log files back from Disk B
> 6. Startup the database.
>
> Is this safe?

No. Only for the reason that you don't have a full backup of everything on stable, offline media. On the other hand, you do have a working backup of the media on the disk that is being removed. Why just just up the scsi address, write lock it and use the drive as its own backup? Basically you'd add the new drive in where the old one was in the chain, up the address of the old one -- total time 15 sec if you don't drop the jumpers too many times -- and copy the contents of the old drive to the new one.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).