RMAN自动备份任务添加

来源:这里教程网 时间:2026-03-03 16:30:18 作者:

    在tnsnames.ora文件中添加catalog数据库信息。

    登录catalog数据库注册信息并调整参数。rman target / catalog admin/admin@catadbregister database;show all;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

    编写rman.sh脚本并添加至crontab作业#!/bin/bash #set environment variables #ORACLE_SID=gzzsdb1 #ORACLE_BASE=/oracle/app/oracle #ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1 #PATH=$PATH:$ORACLE_HOME/bin #export ORACLE_SID ORACLE_BASE ORACLE_HOME PATH rman target / catalog rc_admin/rc_admin@catadb<<EOF run{ backup as compressed backupset database; crosscheck backup; crosscheck archivelog all; delete noprompt expired backup; delete noprompt archivelog all completed before 'sysdate-1'; delete noprompt obsolete; } EOF

相关推荐