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;
}
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;
}