Database Back up Space optimisation

Anonymous

Posts: 1
offline
Reputation:2

Posted 3 years ago
#

Dear All;
I have a space of 50 GB,which is SAN mounted.
For First cycle Full back up by RMAN it takes 30 GB of Oracle 10g RAC.
When i took Second Full Back up it takes again minimum 31 GB.But i have a only 50 GB space.
Before deletion of first back up it will makes as obsolute by keeping second one.
Is there any way around to make sapce optimised.
Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 73
offline
Reputation:96

Posted 3 years ago
#

Hi,

You can use 'backup as compressed backupset' option for taking RMAN database backup.
This will store the backup in compressed format. Only issue is that compression will require additional CPU resources

Cheers
Amit
http://askdba.org/weblog/
Saurabh Sood

admin
Joined: Jun '08
Posts: 46
offline
Reputation:48

Posted 3 years ago
#

Hi,

Adding to what Amit said, you can also revisit your backup policy.
If it allows you to create incremental backups, then go for it, as only the changed blocks will be backed up and less space will be consumed for next backup.

You did not mentioned the version of your DB, if it is 10g then it is worth to read about block_change_tracking feature of 10g.
Refer to following oracle documentation about Incremental backups:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm

Cheers!!!
Saurabh
http://askdba.org/weblog/

Saurabh Sood
Senior Consultant:DBA Services

Reply

You must log in to post.