Physically moving DB to new server

[JMac]

I'm shortly to move our 8.1.5 DB from one NT4 box to another. The new server has extra disks and I'm spreading the datafiles over these new disks. My current datafiles are on disks F: G; H; and I want to split them over G:, H:, I:, J:, K; and L:.

Whats' the best way to achieve this? What are the steps involved?

My indexes for example are spread over 5 100Mb datafiles in an INDEX tablespace on Drive H: How do I create a new Index tablespace on the new drive K: and get the data in to it? Do I need to create 5 x 100Mb datafiles and export and import?

[Sameer]

Originally posted by JMac
My indexes for example are spread over 5 100Mb datafiles in an INDEX tablespace on Drive H: How do I create a new Index tablespace on the new drive K: and get the data in to it? Do I need to create 5 x 100Mb datafiles and export and import?

You can relocate your indexes to new tablespace by rebuillding it... no need for import/export..

Sameer

[servant]

For indexes you can rebuild them .But if you want move
your entire db to new server

the easy method would be recreate control file

1)alter database backup controlfile to trace;

this'll give you control-file generation script..in trace-dir(background_dump_dest)

2)shut the database

3)transfer all the database files(redo-log files may be included) to new-server

4)edit the control-file script so that they point to new-data-files

5)you can use resetlogs option if you don't want to take old redo logs

6)svrmgrl< connect internal
@control-file script

7)Your new database will be up and running by now

[ales]

The easiest method would be renaming datafiles, I think.

1) Copy all files that you don't want to relocate to their original location (including redo, controlfiles, init).

2) Copy files that you want to relocate to their new locations.

3) Start database to the MOUNT state.

4) Use ALTER DATABASE REANAME FILE to relocate the datafiles. This changes filenames in control files.

5) alter database open