-
urgent
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
There is always a better way to do the things.
-
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
-
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?
-
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
-
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
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
|