RMAN备份脚本

Askbuckly

已于 2024-01-31 14:08:41 修改

阅读量155

点赞数

分类专栏： Oracle Base 文章标签： oracle

于 2021-04-22 20:39:25 首次发布

本文链接：https://blog.csdn.net/love4959/article/details/116031057

版权

Oracle Base 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

[oracle@Server ~]$ cat rman.sh

#!/bin/bash
export ORACLE_BASE=/Oracle/app/oracle
export ORACLE_HOME=/Oracle/app/oracle/product/11.2.0/db_1
export ORACLE_SID=primaryd1
/Oracle/app/oracle/product/11.2.0/db_1/bin/rman target system/sys cmdfile=/Oracle/backup/primarydb/rman/rman.txt >>/Oracle/backup/primarydb/rman/rman_log_$(date +%Y%m%d).log

[oracle@Server ~]$ cat rman.txt

RUN{

ALLOCATE CHANNEL C1 TYPE DISK;
ALLOCATE CHANNEL C2 TYPE DISK;
ALLOCATE CHANNEL C3 TYPE DISK;
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE COMPRESSION ALGORITHM ‘BASIC’;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
BACKUP ARCHIVELOG ALL FORMAT ‘/Oracle/backup/primarydb/DBBACKUP/ARCHIVE_%d_%t_%s_%p.BAK’ DELETE ALL INPUT;
backup as compressed backupset full database format ‘/Oracle/backup/primarydb/DBBACKUP/DB_BACKUP_%d_%s_%T.BAK’;
BACKUP SPFILE FORMAT ‘/Oracle/backup/primarydb/DBBACKUP/SPFILE_%U.BAK’;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
BACKUP ARCHIVELOG ALL FORMAT ‘/Oracle/backup/primarydb/DBBACKUP/ARCHIVE_%d_%t_%s_%p.BAK’ DELETE ALL INPUT;
BACKUP CURRENT CONTROLFILE FORMAT ‘/Oracle/backup/primarydb/DBBACKUP/CONTROL_FILE_%d_%f_%t.BAK’;
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
RELEASE CHANNEL C3;
}