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

Thread: capacity planning issue!

  1. 01-21-2003, 11:27 AM #1
    roman33
    roman33 is offline Junior Member
    Join Date
    Dec 2002
    Posts
    36

    capacity planning issue!

    Hi all!

    I have 2 VLDB databases on 1 server and have been asked to move one of the databases to another server mapping out a 2 year use plan. The DB I'm moving is mainly used for reporting with an update of approximately 1 million rows.

    Any ideas.....
    Reply With Quote Reply With Quote
  2. 01-21-2003, 11:33 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525

    Re: capacity planning issue!

    Originally posted by roman33
    Any ideas.....
    About what? What are you asking for?
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!
    Reply With Quote Reply With Quote
  3. 01-21-2003, 01:20 PM #3
    roman33
    roman33 is offline Junior Member
    Join Date
    Dec 2002
    Posts
    36
    What I am asking for are:

    1. What is the best way to move a VLDB from one server to another?i.e cloning, Import/Export,sqlloader etc..
    2. What is the best method to provide adequate disk storage for the the VLDB I'm moving on the new server?
    3. What issues should I be concerned about?

    I will appreciate comments from all


    Thank you
    Reply With Quote Reply With Quote
  4. 01-21-2003, 01:23 PM #4
    roman33
    roman33 is offline Junior Member
    Join Date
    Dec 2002
    Posts
    36
    Please disregard the cloning comment.
    Reply With Quote Reply With Quote
  5. 01-21-2003, 02:46 PM #5
    TheSlob
    TheSlob is offline Member
    Join Date
    Jun 2001
    Posts
    132
    fastest would be to do a cold backup of the db files and restore it on the new server.
    You think I'm going to have an affair with you? --Stanley Kowalski
    Reply With Quote Reply With Quote
  6. 01-21-2003, 04:09 PM #6
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. Definitely not export/import. I would go with a cold backup.
    2. See how big your database is now, figure out how much disk space you use in 1 month, multiply by 24 and double that.
    3. Scalability, backup, and management of multiple instances.
    Last edited by marist89; 01-21-2003 at 04:12 PM.
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width