Oracle Technology Blog

OraTech Blog provides tips,tricks,scripts and how-to type answers for Oracle related technologies. I use these commands very often, so I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions.

Saturday, November 20, 2010

RMAN Backup Scripts to device backup strategy

Backup database and archivelogs:

allocate channel for maintenance device type disk;
delete force backup completed before 'sysdate - 1 + 1';
crosscheck archivelog all;
run {
allocate channel c1 type DISK ;
allocate channel c2 type DISK ;
backup
database
plus archivelog;
 }


Backup Archive logs:

RMAN> connect catalog *
run {
 allocate channel c1 type SBT PARMS="ENV=(NB_ORA_CLIENT=client_backup_interface,NB_ORA_POLICY=policy_name)";
allocate channel c2 type SBT PARMS="ENV=(NB_ORA_CLIENT=client_backup_interface,NB_ORA_POLICY=policy_name)";
backup
archivelog all ;
}


Delete Archivelog backed up 1 times to device type SBT and completed couple of days ago:

RMAN> connect catalog *
allocate channel for maintenance device type disk;
delete force archivelog all backed up 1 times to device type SBT completed before 'sysdate - 2';


Backup backupset to Tape:

RMAN> connect catalog *
 run {
allocate channel c1 type 'SBT' ;
 allocate channel c2 type 'SBT' ;
 backup backupset completed after "to_date('MM/DD/YYYY HH24:MI:SS','MM/DD/YYYY HH24:MI:SS')"
 ;
 }

Delete Obsolete Backups:

RMAN> connect catalog *
 allocate channel for maintenance device type DISK PARMS="ENV=(NB_ORA_CLIENT=client_backup_interface,NB_ORA_POLICY=policy_name)";
 crosscheck archivelog all;
 crosscheck backup;
 delete force expired archivelog all;
 delete force expired backup;
 allocate channel for maintenance device type SBT PARMS="ENV=(NB_ORA_CLIENT=client_backup_interface,NB_ORA_POLICY=policy_name)";
 delete force obsolete device type SBT;

Incrementally Updated Backups:

 run {
    allocate channel c1 type DISK;
    allocate channel c2 type DISK;
    recover copy of database with tag 'incr_update';
    delete force backup tag='DISKONLY';
    backup  incremental level 1 tag='DISKONLY' for recover of copy with tag 'incr_update'
    database;
 }

2 Comments:

Anonymous Anonymous said...

top [url=http://www.001casino.com/]casino bonus[/url] coincide the latest [url=http://www.casinolasvegass.com/]free casino[/url] unshackled no deposit bonus at the chief [url=http://www.baywatchcasino.com/]casino games
[/url].

12:04 AM  
Anonymous Anonymous said...

Hello would you mind stating which blog platform you're using? I'm going to start my own blog
in the near future but I'm having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I'm looking for something
unique. P.S Apologies for getting off-topic but I had to
ask!

Also visit my web blog :: waist to height calculator

9:31 AM  

Post a Comment

<< Home