DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Contingency plans for DB move to new hardware

  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Contingency plans for DB move to new hardware

    we are planning to move our datawarehouse db from one hardware to another. can someone suggest the contingency plans to take before moving to new hardware?

  2. #2
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    This is an effort that involves a lot of folks
    -Sysadmins
    -App folks
    -Network folks/firewall
    -Help desk?
    -DBAs
    The contingency here is at many levels. As a DBA your role should be to
    -have a clean shutdown.
    -take a backup
    The bulk of the work here would be done by sysadmin/network folks. Oncecomplete they should ask you to bring up your database if they don't it via some oratab entry. then your app folks would tell you if they can connect or not. I'm sure others would add or subtract from this...good luck..
    Looking for the greatest evil in the world? Look in the mirror.

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Take a backup on the tapes/disks.
    Shutdown the instance.
    If the LUNs are created on the SAN, unmount the FS and remount on the new server.
    Startup the database.

Posting Permissions

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


Click Here to Expand Forum to Full Width