DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Backups timing

  1. #1
    Join Date
    Jan 2002
    Posts
    38

    Backups timing

    I'm trying to find bottle necks in our backup and restores. We have two databases that we use alot of. One is 2.5 gigs and the othere is about 10 gigs. For these two databases how long would each backup take. Were using a command line backup. I'm not looking for an exact science, just some general numbers.
    Please let me know if you need more information.
    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    depends what you back up to, a disk copy of 2.5 gigs could takes a few seconds if you have a good setup, to tape it will be slower

    10 gigs will take about 4 times as long

  3. #3
    Join Date
    Jan 2002
    Posts
    38
    What were doing is using the exp.exe in Oracle. Doing an export of the two databases. I just want to get a idea of, is how long do most peoples exports take, when there databases are this size?
    Thanks for the help

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    Don't you think the question is very vague ?

    What are you trying to find ? If you are running a 16-way server, state-of-the-art disk arrays, these exports will finish in minutes. If not, its anybody's guess.

    How long is it taking now ? Is that a problem ? If so, WHY and what is acceptable ?
    svk

  5. #5
    Join Date
    Jan 2002
    Posts
    38
    No, I don't think my question is vague. I'm asking people how long there database exports take when the db is around 2.5gigs in size. Seems like a easy question.

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Is your backup and restore strategy based on exp and imp?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Jan 2002
    Posts
    38
    yes it is. But were looking at coldbackups.

  8. #8
    Join Date
    Jan 2002
    Posts
    38
    yes it is.

  9. #9
    Join Date
    Sep 2002
    Posts
    411
    exp/imp is not a good backup strategy

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I just tested. On my box, it takes about 93 seconds to export a 10G database.
    Jeff Hunter

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