How do I calculate the space required by a hotbackup that will run on my database?
thanks
Printable View
How do I calculate the space required by a hotbackup that will run on my database?
thanks
you know maths right....? why you dont add up your datafiles size?
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
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
Hm, temp files included in hot backup? Wonder why...Quote:
Originally posted by marist89
Code:4 union all
5 select sum(bytes/1024/1024) mb
6 from dba_temp_files
Childs play I say! Post the sql to determine the size of an RMAN backup and then I will be impressed :DQuote:
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
Hey, he didn't specify he was going to do it the RIGHT way.... Sounds like a "custom script" deal to me...Quote:
Originally posted by jmodic
Hm, temp files included in hot backup? Wonder why...