RMAN backup size problem
I have Oracle database.I take rman backup everyday.Also I set a scheduled backup script.But scheduled backup size is 166MB,but if I take manual rman backup(rman>backup database) this backup size will 2.8GB.This backup isn't incremental backup.There is a problem.But I can't solve it.Help me!!
I wrote 3 batch script.Finally this backup script call
backup database plus archivelog delete input format 'C:\db_11g_backup\backup\oracle_scheduled_backup\backups\%d_%t_%s.rman';
restore database validate;
delete noprompt obsolete device type disk;
OS:Windows Server 2003
If you are looking to increase the size of each backup piece then you can configure it along wich channel.
configure channel device type disk maxpiecesize = 4g;
the above commands configures the automatic disk channel and limits the maximum size of a backup piece to 4G.
My problem isn't this.I execute this script as scheduled,backup size is too small.But I take backup manually,backup size is normal.I guessed there is an error in script;but I couldn't anything...
okay, i got it. are you using the same RMAN script to backup manually as well?
I used just
rman>backup database while taking manually backup
Perhaps the "plus archivelog" makes the difference...
Originally Posted by doganay_n
agree, but poster said backup piece size is less when he used "plus archivelog"...
Originally Posted by LKBrwn_DBA