Bo's Oracle Station

查看: 2787|回复: 0

课程27次

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2019-7-17 21:15:55 | 显示全部楼层 |阅读模式
注意:recover copy of database with tag 'ORA_OEM_LEVEL_0';
  1. Daily Script:
  2. run {
  3. allocate channel oem_disk_backup device type disk;
  4. recover copy of database with tag 'ORA_OEM_LEVEL_0';
  5. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  6. release channel oem_disk_backup;
  7. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station79)';
  8. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station79)';
  9. backup archivelog all not backed up;
  10. }
  11. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station79)';
  12. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
  13. Weekly Script:
  14. run {
  15. allocate channel oem_disk_backup device type disk;
  16. recover copy of database with tag 'ORA_OEM_LEVEL_0';
  17. backup incremental level 1 cumulative  copies=1 for recover of copy with tag 'ORA_OEM_LEVEL_0' database;
  18. release channel oem_disk_backup;
  19. allocate channel oem_sbt_backup1 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station79)';
  20. allocate channel oem_sbt_backup2 type 'SBT_TAPE' format '%U' parms 'ENV=(OB_MEDIA_FAMILY=station79)';
  21. backup recovery area;
  22. }
  23. allocate channel for maintenance device type 'SBT_TAPE' parms 'ENV=(OB_MEDIA_FAMILY=station79)';
  24. delete noprompt obsolete recovery window of 31 days device type 'SBT_TAPE';
复制代码


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-5-20 15:58 , Processed in 0.028573 second(s), 24 queries .

快速回复 返回顶部 返回列表