Welcome! This is a website that everyone can build together. It's easy!

Location: Database

Discussion: RMAN Backup

Keyword tags: 10g 11g 7 8 8i 9i database sql

Watch

Anonymous  (Get credit for your thread)
hardeep.singh

hardeep.singh		 RMAN Backup
Jan 1 2008, 10:31 AM EST
Hi,

I have an oracle Applications DB which has size of 70 GB Approx. When i backup the Database using RMAN, backup goes beyond 70 GB. I am using RMAN for full Backup. Please advise. 4  out of 18 found this valuable. Do you?    
a.aravind.kumar
a.aravind.kumar		 RE: RMAN Backup
Jan 2 2008, 8:17 AM EST
Hi
You haven't mentioned what kind of backup you are doing. It would be easy to look into if you give logs of your backup job. 0  out of 10 found this valuable. Do you?    
pjuanola

pjuanola		 RE: RMAN Backup
Jan 4 2008, 5:23 AM EST
Hi,

do you backup your archivelogs ? maybe the total size of the backup is the size of the database plus the archivelogs.

Bye.
 1  out of 10 found this valuable. Do you?    
JLATASTE

JLATASTE		 RE: RMAN Backup
Jan 8 2008, 12:50 PM EST
Hi,
Since 10g version you can compress the backupsets including the datafiles. In any way, the database full backup is always smaller then the OS copy of files since Rman does not backup the non-modified blocks in datafiles and the tempfiles.
 0  out of 8 found this valuable. Do you?    
lewonkas

lewonkas		 RE: RMAN Backup
Jan 9 2008, 8:33 PM EST
when u say 70GB, are you saying 70GB used? what is the sum of sizes all datafiles (excluding temp)? with a rman full backup, if data was ever in the block it'll get backed up. While the rman exact behavior depends on your version SE/EE and release. backing up to these file HWMs could account for your difference.
 0  out of 8 found this valuable. Do you?    
Lukorito

Lukorito		 RE: RMAN Backup
Jan 22 2008, 2:29 AM EST
Consider using the compressed option which should significantly reduce the size of the backup. 0  out of 5 found this valuable. Do you?    
rucknrun
rucknrun		 RE: RMAN Backup
Jan 25 2008, 10:12 AM EST
If you use the compressed option it increases the time it takes to for the backup to complete dramatically. Especially if you are storing BLOBS int he database.

Just a heads up. I recently had an issue with this. 0  out of 4 found this valuable. Do you?    

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Why can't we build wiki's on Oracle. SQLPro Green Program At OpenWorld
Unconference: How to use native database REST Web Services in Oracle 11g Oracle Database インストールFAQ Certs
Good Luck ideas for utilizing Real Application Testing Oracle Roles and Privileges
Why are there so few Oracle Certs? Certs should be considered carefully Take 11g Cert Test