Home » RDBMS Server » Server Administration » 10g change disk with datafiles
10g change disk with datafiles [message #531622] Thu, 17 November 2011 02:31 Go to next message
dustfree64
Messages: 1
Registered: November 2011
Location: LT
Junior Member

Hi,

What is best practice to change small disk D:?

I am beginner with Oracle.
10g on W2008.
5 datafiles (all indexes,second data file, 2 undotabs)*.dbf (34;30;1;34;12 GB) is on D:. Part of tablespaces (1 data, 1 undo)has files on c:.

I.
1.Shutdown 2008 server.
2.Copy D: image with GHOST to USB, network.
3.Connect new D, create RAID.
4.Restore image to D.
5.Start 2008 server.

II.
1.Stop application.
2.CONNECT AS SYSDBA
3.SHUTDOWN NORMAL or (IMMEDIATE)?
4.Copy files *.dbf at OS level from d:\ to ... USB disk, network.
5.Shutdown 2008 server.
6.Change disks, create RAID in BIOS.
7.Start W2008.
Is Oracle at this moment in SHUTDOWN mode?
8.Copy back *.dbf to new D:\ (with directory structure).
9.STARTUP Oracle.

Regards
Dustfree64
Re: 10g change disk with datafiles [message #531651 is a reply to message #531622] Thu, 17 November 2011 04:03 Go to previous message
ThomasG
Messages: 3087
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I) will work, as long as the imaging process works.

II) depends on a few things.
3) Shutdown normal if no other sessions are connected, immediate if they are.
4) copy the *exact same directory structure* with the *exact same* user rights. (might be a problem if the Oracle user is only a local user not known to the network storage)
7) That would depend if Oracle is configured to auto-start or not. If it is, it will fail to start and you have to shut all services down again before copying the files back.

If I were to do it I would take option I)
Previous Topic: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated.
Next Topic: calculate used space in a block
Goto Forum:
  


Current Time: Wed Jul 23 04:57:18 CDT 2014

Total time taken to generate the page: 0.14387 seconds