Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    133

    Unanswered: moving off database local device to raw device

    Hi guys,
    I need your suggestions about this.

    One of the database data currently altered to a local device which supposed to be on a raw device. How can i move one of the local device created and altered to a raw device?

    I've been looking to backup and drop the database and load the backup. the problem is data and log would be mixed.

    or

    i have a reverse script for sysusages and sysdevices to load backup based on altered procedures of DB but the problem is the last device were not altered to a raw device. how can i accomplish this?


    TIA

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    I always thought it didn't matter if a device was local or a raw device.
    Are you sure you can't backup the db, drop db, drop devices, recreate devices as raw devices, recreate the db in the right order and load the db?
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Feb 2012
    Posts
    133
    Thanks for the replied. I've been looking on that option.

    Currently the machine has 64G RAM with 16 processors running Redhat enterprise with one database with approximately 198G. Do you have any idea how long would it take to backup and load the db.

    TIA

  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    I do not know, sorry. You can always try to make a dump before you plan the maintanance and downtime to see how long it takes.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •