Database status when moving datafile using brtools

[Former Member]

Hi Experts,

For moving datafile one from disk to another using brtools, what should we keep the status of database and whether we needs to take tablespace/datafile offline.

Also, what is the differnece between the datafile renaming to different location and datafile moving??

Regards,

Sandeep.

[Former Member]

Dear Sandeep,

When you move datafile one disk to another, first down the R3 instance but not the database. Database should be in open state otherwise brtools cannot connect database.

And for moving the datafile, brtools will takes care of the database state.

1. bring to the MOUNT state,

2. copy datafile to target location

3. fire the SQL.

4. Shutdown the database and open in normal mode.

5. Remove the datafile from old location.

Thanks,

Debi Prasad

[former_member204746]

renaming to different location: rename datafile to another directory from within the same partition/disk. This is quick

and datafile moving: move to other disk/partition:. This takes time

[Former Member]

Hi Sandeep,

status of database - mount

whether we needs to take tablespace/datafile offline - not required.

rename datafile - change the datafile name

moving - moving the same datafile to a different location

Regards

Ashok Dalai

Edited by: Ashok Dalai on Aug 28, 2009 9:53 AM

[stefan_koehler]

Hello Sandeep,

this explains it very well: http://www.jlcomp.demon.co.uk/faq/rename_datafile.html

Regards

Stefan