Oracle rman automatic backup script #! /Bin/sh. /opt/oracle /. bash_profilePWD_SYS = "/" BAK_DIR = "/opt/oracle/backup/oatest" BEGIN_SEQ =$ (sqlplus-s $ {PWD_SYS} 'as sysdba' <! Set linesize 1000; www.2cto.com set serveroutput on; set echo off; set heading off; set feedback off; select max (sequence #)-1 from v \ $ archived_log ;!) Echo '------ backup_begin ------------ 'echo $ BEGIN_SEQecho 'backup start time' date +' % Y-% m-% d % H: % M: % s' $ ORACLE_HOME/bin/rman <! Connect target $ {PWD_SYS}; backup full database maxsetsize 20G format' $ {BAK_DIR }_% T _ % s _ % p. dbf'; SQL 'alter system archive log offset '; backup archivelog from sequence $ {BEGIN_SEQ} maxsetsize 20G format' $ {BAK_DIR} _ % T _ % s _ % p. arc'; www.2cto.com backup spfile maxsetsize 10G format' $ {BAK _ DIR} _ % T _ % s _ % p. spf '; backup current controlfile maxsetsize 10G format' $ {BAK_DIR} _ % T _ % s _ % p. ctl '; restore database validate; delete noprompt obsolete ;! Echo 'backup end Time' date + '% Y-% m-% d % H: % M: % S 'echo' ------ backup_end ------------ '# crosscheck backupset; # crosscheck archivelog all; # delete expired backupset; # delete expired archivelog all; #0 4 ***/opt/oracle/backup/oatest/backup_rman.sh>/opt/oracle/backup/oatest/backup_rman.log 2> & 1 &