RMAN backup size problem

[doganay_n]

Hi all,

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!!
Thanks...

I wrote 3 batch script.Finally this backup script call

backup script:

run
{
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;

}
database version:11.1.0.7
database size:3.5Gb
OS:Windows Server 2003

[vnktummala]

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.

Regards,

[doganay_n]

Thanks vnktummala,

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...

[vnktummala]

okay, i got it. are you using the same RMAN script to backup manually as well?

Regards,

[doganay_n]

I used just

rman>backup database while taking manually backup

[LKBrwn_DBA]

run
{
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;

}

Perhaps the "plus archivelog" makes the difference...

[vnktummala]

Perhaps the "plus archivelog" makes the difference...

agree, but poster said backup piece size is less when he used "plus archivelog"...

Regards,