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:
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].
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
Post a Comment
<< Home