OraFAQ Forum: Backup & Recovery » reduce rman backup size

Home » RDBMS Server » Backup & Recovery » reduce rman backup size (oracle 10.1.0.3 ,windows server 2003) (

) 1 Vote

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

reduce rman backup size [message #399484]

Wed, 22 April 2009 07:31

ankush_chawla
Messages: 136
Registered: November 2006

Senior Member

i have dropped many objects (tables and indexes ) of the total size of approx 10 GB.
However the size of the RMAN backup has not decreased. It is still the same. I am not using compress option as it takes a lot of time. Any other way to reduce the rman backup size.Please help..
Thanks in advance.

Report message to a moderator

Re: reduce rman backup size [message #399490 is a reply to message #399484]

Wed, 22 April 2009 08:00

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

- Move your objects in new tablespaces and drop old ones.
- Export/drop objects/shrink files/import

Regards
Michel

Report message to a moderator

Re: reduce rman backup size [message #399491 is a reply to message #399490]

Wed, 22 April 2009 08:04

ankush_chawla
Messages: 136
Registered: November 2006

Senior Member

Thanks for the reply.I have already dropped many objects . But the size of the RMAN backup is still the same . what is the reason for it ?

Report message to a moderator

Re: reduce rman backup size [message #399493 is a reply to message #399491]

Wed, 22 April 2009 08:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

shrink files.

RMAN still export blocks that have been used some day.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle DB backup/restore (merged)
Next Topic:	Cannot restore from hot full backup(ORA-01152 RMAN-06053)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 15:11:08 CST 2024