oracle学习50-rman备份脚本

最新推荐文章于 2024-05-24 15:46:25 发布

前端歌谣

最新推荐文章于 2024-05-24 15:46:25 发布

阅读量178

点赞数

文章标签： oracle 学习数据库

本文链接：https://blog.csdn.net/qq_41632427/article/details/126256705

版权

歌谣-后端-oracle 专栏收录该内容

92 篇文章 3 订阅

订阅专栏

D盘新建一个文件夹backup_file，里面新建一个文件夹logs

一个文件叫auto_full_one_rman.bat

修改这三处

set oracle_sid=wiicare

rman cmdfile= D:/backup_file/level_full_one_rman.rman msglog= D:/backup_file/logs/full_one_%date:~0,4%%date:~5,2%%date:~8,2%.log

一个叫level_full_one_rman.rman

修改这四处

    connect target wiicare/Mdsd123@wiicare
    run {
    CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:/backup_file\%F';
    allocate channel T1 device type disk;
    allocate channel T2 device type disk;
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    backup   database
    format 'D:/backup_file\level_full_%d_%T_%s';
    backup archivelog all format 'D:/backup_file\arch_%d_%U' ;
    release channel T1;
    release channel T2;
     }
    allocate channel for maintenance device type disk;
    crosscheck backup;
    crosscheck archivelog all;
    delete noprompt expired backup;
    delete noprompt expired archivelog all;
    delete noprompt archivelog all completed before 'sysdate -3';
    report obsolete;
    delete noprompt obsolete;
    list backup summary;
    release channel;