Home » RDBMS Server » Backup & Recovery » reduce rman backup size (oracle 10.1.0.3 ,windows server 2003)  () 1 Vote
reduce rman backup size [message #399484] Wed, 22 April 2009 07:31 Go to next message
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.
Re: reduce rman backup size [message #399490 is a reply to message #399484] Wed, 22 April 2009 08:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Move your objects in new tablespaces and drop old ones.
- Export/drop objects/shrink files/import

Regards
Michel
Re: reduce rman backup size [message #399491 is a reply to message #399490] Wed, 22 April 2009 08:04 Go to previous messageGo to next message
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 ?
Re: reduce rman backup size [message #399493 is a reply to message #399491] Wed, 22 April 2009 08:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
shrink files.

RMAN still export blocks that have been used some day.

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


Current Time: Fri Mar 29 00:29:28 CDT 2024