课程第24/25次（2017-05-06星期六上下午）

botang

上完1Z0-052备份（第15章）
上完1Z0-052恢复（第16章）
1Z0-052共19章（上完12章），1Z0-053共21章（上完5章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的17章

手工备份：

1. tar cf - | ( cd /u01/app/oracle/oradata/rcat.backup ; tar xf - )

复制代码

Daily Script：

1. run {
   
2. allocate channel oem_disk_backup device type disk;
   
3. recover copy of database with tag 'ORA_OEM_LEVEL_0';
   
4. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
   
5. release channel oem_disk_backup;
   
6. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
   
7. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
   
8. backup archivelog all not backed up;
   
9. backup backupset all not backed up;
   
10. }
    
11. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
    
12. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';

复制代码

Weekly Script：

1. run {
   
2. allocate channel oem_disk_backup device type disk;
   
3. recover copy of database with tag 'ORA_OEM_LEVEL_0';
   
4. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
   
5. release channel oem_disk_backup;
   
6. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
   
7. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
   
8. backup recovery area;
   
9. }
   
10. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station90)';
    
11. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';

复制代码