#!/bin/sh
echo "-----------------------------satrt-----------------------------";date
#set environment variable
ORACLE_BASE=/u01/oracle;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/ora920;export ORACLE_HOME
ORACLE_SID=gd; export ORACLE_SID
ORACLE_NLS=$ORACLE_HOME/ocommon/nls/admin/data; export ORACLE_NLS
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH;export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'; export NLS_DATE_FORMAT
#backup start
$ORACLE_HOME/bin/rman target /
connect catalog rman/rman@rman
#delete noprompt obsolete;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup database include current controlfile;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all delete input;
#list backup;
delete noprompt obsolete;
exit;
EOF
echo "------------------------------end------------------------------";date
没有评论:
发表评论