Re: ORACLE BACKUP SIZE

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

You have archivelog backup as well.

How do you check your backup sizes anyways?

2017-06-03 12:46 GMT+03:00 Arsala [via Erman Arslan's Oracle Forum] <[hidden email]>:

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);

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ORACLE-BACKUP-SIZE-tp2736p2760.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--