poniedziałek, 10 lutego 2014

Skrypt bash do Backup'u RMAN (Linux)

Tworzenie skryptu sh

tworzymy plik

touch backuporacle.sh

nadajemy uprawnienia do pliku

chmod 755 backuporacle.sh

edytujemy 

vi backuporacle.sh

wpisujemy

#!/bin/bash
sleep 10
USER=oracle
PASSWD=xxxxx
DBASE=orcl
RMAN=/opt/oracle/product/11.2.0/bin/rman
SCRIPT=/home/oracle/scripts/backuporacle
$RMAN target $DBASE/$PASSWD nocatalog @$SCRIPT


Skrypt RMAN Backup dla urządzenia 1 taśma

run {
allocate channel t1 type 'sbt_tape';
backup database plus archivelog;
backup spfile format 'spfile_%d_%s_%T.bak' tag 'spfile backup';
backup current controlfile format 'ctl_%t_dbid%I.bak' tag 'controfile backup';
release channel t1;
}



dla 4 taśm 

run {
allocate channel tape1 type 'sbt_tape';
allocate channel tape2 type 'sbt_tape';
allocate channel tape3 type 'sbt_tape';
allocate channel tape4 type 'sbt_tape';
backup database;
release channel tape1;
release channel tape2;
release channel tape3;
release channel tape4;
}