rman備份與腳本

SQL> create tablespace rman

 logging datafile '/u01/app/oracle/oradata/TBDB/rman.dbf'  size 1024M

 extent management local segment space  management auto;

create user rman identified by rman default  tablespace rman;

grant connect,resource to rman;

grant recovery_catalog_owner to rman;

grant unlimited tablespace to rman;

grant sysdba to rman;

rman catalog rman/rman

RMAN> create catalog tablespace  "RMAN";

RMAN> exit

rman target sys/oracle@node222 catalog rman/rman@node222

connected to target database: NODE222 (DBID=3694045568)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN> configure retention policy to  recovery window of 30 days;

RMAN> configure controlfile autobackup  on;

RMAN>show all;

mkdir /u01/app/oracle/backup

cd /u01/app/oracle/backup

mkdir controlfileback 存放備份的控製文件

mkdir dbback        存放備份的數據文件

mkdir log           存放備份生成的日誌，堅持該日誌查看備份是否成功

mkdir logback       存放歸檔日誌文件

#!/bin/bash

#this is rman auto full backup script

# Copyright by terrytsang

ORACLE_HOME=/u01/app/oracle/product/11.2.0/db1

NLS_LANG=AMERICAN_AMERICA.AL32UTF8

LD_LIBRARY_PATH=$ORACLE_HOME/lib

ORACLE_BASE=/u01/app/oracle

ORACLE_SID=TBDB

export ORACLE_HOME  LD_LIBRARY_PATH NLS_LANG ORACLE_BASE  ORACLE_SID

backtime=`date +"20%y%m%d%H%M%S"` 

cd $ORACLE_HOME/bin

rman target / catalog rman/rman log=/u01/app/oracle/backup/log/backupall_$backtime.log  <<EOF

run{

   allocate channel c1 device type disk;

   allocate channel c2 device type disk;

   allocate channel c3 device type disk;

   allocate channel c4 device type disk;

   allocate channel c5 device type disk;

   crosscheck backup;

   sql 'alter system archive log current';

     backup database format '/u01/app/oracle/backup/dbback/db_%d_%T_%U';

   sql 'alter system archive log current';

     backup archivelog all format '/u01/app/oracle/backup/logback/arc_%t_%s'  delete all input; 

     backup current controlfile format '/u01/app/oracle/backup/controlfileback/cntrl_%s_%p_%s'; 

   crosscheck archivelog all;

  delete  noprompt expired backup;

  delete  noprompt obsolete;

  delete  noprompt backup of database completed before 'sysdate - 30';

  release  channel c1;

   release channel c2;

   release channel c3;

   release channel c4;

   release channel c5;

}

EOF

echo "backup complete!"

crontab 0 0 * * * /u01/app/oracle/backup/script/dbback.sh  2>&1 >/dev/null