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

Thread: urgent

  1. #1
    Join Date
    Apr 2001
    Posts
    112

    urgent

    How do I calculate the space required by a hotbackup that will run on my database?

    thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you know maths right....? why you dont add up your datafiles size?

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    What is Hot backup? What do you copy and from where to where?--and after copying do you compress your files?? and do you put them on a tape and delete them?? How frequently do you take the backup (to get rid of the archives ) etc.,

    Answers to some of these will definitely help figure out my space requirement..

    HTH
    There is always a better way to do the things.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Code:
    SQL> l
      1  select sum(mb)*1.25 from (
      2     select sum(bytes/1024/1024) mb
      3     from dba_data_files
      4     union all
      5     select sum(bytes/1024/1024) mb
      6     from dba_temp_files
      7*    )
    SQL> /
    
    SUM(MB)*1.25
    ------------
          511.25
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by marist89
    Code:
      4     union all
      5     select sum(bytes/1024/1024) mb
      6     from dba_temp_files
    Hm, temp files included in hot backup? Wonder why...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by marist89
    Code:
    SQL> l
      1  select sum(mb)*1.25 from (
      2     select sum(bytes/1024/1024) mb
      3     from dba_data_files
      4     union all
      5     select sum(bytes/1024/1024) mb
      6     from dba_temp_files
      7*    )
    SQL> /
    
    SUM(MB)*1.25
    ------------
          511.25
    Childs play I say! Post the sql to determine the size of an RMAN backup and then I will be impressed
    I'm stmontgo and I approve of this message

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by jmodic
    Hm, temp files included in hot backup? Wonder why...
    Hey, he didn't specify he was going to do it the RIGHT way.... Sounds like a "custom script" deal to me...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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