OraFAQ Forum: Backup & Recovery » Decide size of LEVEL 0 RMAN backups

Home » RDBMS Server » Backup & Recovery » Decide size of LEVEL 0 RMAN backups

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Decide size of LEVEL 0 RMAN backups [message #434840]

Fri, 11 December 2009 03:37

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,

Report message to a moderator

Re: Decide size of LEVEL 0 RMAN backups [message #434842 is a reply to message #434840]

Fri, 11 December 2009 03:50

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Sum of all database files.

Regards
Michel

Report message to a moderator

Re: Decide size of LEVEL 0 RMAN backups [message #434844 is a reply to message #434840]

Fri, 11 December 2009 03:53

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,

Report message to a moderator

Re: Decide size of LEVEL 0 RMAN backups [message #434845 is a reply to message #434844]

Fri, 11 December 2009 03:56

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Decide size of LEVEL 0 RMAN backups [message #434847 is a reply to message #434840]

Fri, 11 December 2009 04:10

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

Michel Cadot
Messages: 68641
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 03:22:07 CDT 2024