Re: ORACLE BACKUP SIZE

Posted by Arsalan on Jun 03, 2017; 9:46am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORACLE-BACKUP-SIZE-tp2736p2760.html


Sir,

Kindly check my backup script.

So if needs change bring some changes on it please recommends me.

MY DBSIZE IS 19 GB


Note:
1)   backup incremental level 0 cumulative Run on Wednesday and sunday at 11 pm
and

2)   backup incremental level 1 cumulative level 1 run monday tuesday thursday friday saturday every day 11 pm


$rman_script="backup incremental level 0 cumulative device type disk tag '%TAG' database;
backup device type disk tag '%TAG' archivelog all not backed up delete all input;
run {
allocate channel oem_backup_disk1 type disk  maxpiecesize 1000 G;
backup tag '%TAG' current controlfile;
release channel oem_backup_disk1;
}
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;
";
&br_save_agent_env();
&br_prebackup($l_db_connect_string, $l_is_cold_backup, $l_use_rcvcat, $l_db_10_or_higher, $l_backup_strategy, "TRUE");
my $result = &br_backup();
exit($result);

------------------------------------------------------------------------------
$rman_script="backup incremental level 1 cumulative device type disk tag '%TAG' database;
recover copy of database;
backup device type disk tag '%TAG' archivelog all not backed up delete all input;
run {
allocate channel oem_backup_disk1 type disk  maxpiecesize 1000 G;
backup tag '%TAG' current controlfile;
release channel oem_backup_disk1;
}
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;
";
&br_save_agent_env();
&br_prebackup($l_db_connect_string, $l_is_cold_backup, $l_use_rcvcat, $l_db_10_or_higher, $l_backup_strategy, "TRUE");
my $result = &br_backup();

exit($result);