urgent

[tansdot]

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

thanks

[pando]

you know maths right....? why you dont add up your datafiles size?

[badrinathn]

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

[marist89]

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

[jmodic]

Originally posted by marist89

  4     union all
  5     select sum(bytes/1024/1024) mb
  6     from dba_temp_files

Hm, temp files included in hot backup? Wonder why...

[stmontgo]

Originally posted by marist89

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

[marist89]

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...