Re: RMAN - Oracle Suggested Backup

Re: RMAN - Oracle Suggested Backup

 

  

Here is the daily script I am using as generated by Grid Control....

run {
allocate channel oem_disk_backup device type disk;
recover copy of database with tag 'ORA\$OEM_LEVEL_0';
backup incremental level 1 cumulative copies=1 for recover of copy with tag 'ORA\$OEM_LEVEL_0' database;
}


I also run this cleanup script nightly, but no affect on incremental
backupsets......

run {
crosscheck backup;
crosscheck copy;
crosscheck backup of database;
crosscheck backup of controlfile;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired copy;
delete noprompt expired archivelog all;
}



Carrie Berlin wrote:
> I have a retention policy of 2 days, run level 0 cumulative backup every day
>
>
> run {
> allocate channel d2 device type disk FORMAT '/backup2/%d/bk/%d_level_0_d_%p_%s_%T_%f_%N_%U';
> allocate channel d3 device type disk FORMAT '/backup3/%d/bk/%d_level_0_d_%p_%s_%T_%f_%N_%U';
>
> backup
> as backupset
> incremental level 0 cumulative
> database INCLUDE CURRENT CONTROLFILE FOR STANDBY
> filesperset=1;
> release channel d2;
> release channel d3;
> }
>
> delete noprompt obsolete;
>
> -----Original Message-----
> From: Rubino John [mailto:oracledba-ezmlmshield-x21629748.[Email address protected]
> Sent: Tuesday, January 08, 2008 3:52 PM
> To: LazyDBA Discussion
> Subject: RE: RMAN - Oracle Suggested Backup
>
> DID YOU RUN "DELETE OBSOLETE" UNDER RMAN ?
>
>
>


Oracle LazyDBA home page