Home » RDBMS Server » Backup & Recovery » Decide size of LEVEL 0 RMAN backups
Decide size of LEVEL 0 RMAN backups [message #434840] Fri, 11 December 2009 03:37 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I need to decide size of mount point for my RMAN backup.
I need to take FULL,INCREMENTAL,COMMULATIVE, ARCHIVE backups.

Please let me know how i can decide how much size of the FULL LEVEL 0 backup?

Thanks,
Re: Decide size of LEVEL 0 RMAN backups [message #434842 is a reply to message #434840] Fri, 11 December 2009 03:50 Go to previous messageGo to next message
Michel Cadot
Messages: 63805
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sum of all database files.

Regards
Michel
Re: Decide size of LEVEL 0 RMAN backups [message #434844 is a reply to message #434840] Fri, 11 December 2009 03:53 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
But i guess RMAN only considers used block size?

So do we need to consider total size from dba_segments?
select sum(bytes/1024/1024/10124)
from dba_segments;


Is that correct?

Thanks,
Re: Decide size of LEVEL 0 RMAN backups [message #434845 is a reply to message #434844] Fri, 11 December 2009 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 63805
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No. You need the content of the files up to their HWM which will change from one backup to the next one, so take the whole files.

Regards
Michel
Re: Decide size of LEVEL 0 RMAN backups [message #434847 is a reply to message #434840] Fri, 11 December 2009 04:10 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
So i need to check bytes for dba_data_files?


select sum(bytes/1024/1024/10124)
from dba_data_files;


The output size is 150GB

So should i consider by LEVEL 0 backup size is = 150G?

Thanks,

[Updated on: Fri, 11 December 2009 04:15]

Report message to a moderator

Re: Decide size of LEVEL 0 RMAN backups [message #434851 is a reply to message #434847] Fri, 11 December 2009 04:38 Go to previous message
Michel Cadot
Messages: 63805
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is safe as it (ignoring size of control file and spfile that are very small).
You have to add to this the size of archived logs generated during the backup depends on your activity during this time.

Regards
Michel

[Updated on: Fri, 11 December 2009 04:40]

Report message to a moderator

Previous Topic: RMAN-08132 during backup archive logs on physical standby database.
Next Topic: Duplicate database: problem with the syntax
Goto Forum:
  


Current Time: Tue Sep 27 02:28:18 CDT 2016

Total time taken to generate the page: 0.11838 seconds