Skip to Content
avatar image
Former Member

Database status when moving datafile using brtools

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Aug 28, 2009 at 07:21 AM

    Hello Sandeep,

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

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2009 at 07:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 28, 2009 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2009 at 11:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded