full_backup_dmbfxms.ksh

#!/bin/ksh
#full_backup_dmbfxms.ksh
export log_file=/paic/bank/tmpsun/rman1/backup/DM8/dmbfxms/full_backup_${ORACLE_SID}_`date '+%Y%m%d_%H%M%S'`.log
rman target / << EOF > ${log_file} 2>&1
sql 'alter system switch logfile';
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
BACKUP as compressed backupset full DATABASE FORMAT '/paic/bank/tmpsun/rman1/backup/DM8/dmbfxms/full_%T-%d-%u-%p' filesperset=10 plus archivelog SKIP INACCESSIBLE format '/paic/bank/tmpsun/rman1/backup/DM8/dmbfxms/arch_%T-%d-%u-%p.log';
backup as copy current controlfile format '/paic/bank/tmpsun/rman1/backup/DM8/dmbfxms/ctrl_%t-%s-%p.f';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
}
EOF
echo "Backup finished at `date '+%Y%m%d_%H%M%S'`" >> ${log_file}

 

 

 

 

 

 

9i 用你们的脚本不行。下面这个应该可以。

 

cd $HOME && . ./.profile

LOGDIR=/paic/hq/paces/data/oppaces/shell

log_file=$LOGDIR/full_backup_${ORACLE_SID}_`date '+%Y%m%d_%H%M%S'`.log

 

rman target / << EOF > ${log_file} 2>&1

sql 'alter system switch logfile';

run

{

allocate channel c1 type disk ;

allocate channel c2 type disk ;

allocate channel c3 type disk ;

allocate channel c4 type disk ;

allocate channel c5 type disk ;

allocate channel c6 type disk ;

BACKUP incremental level 0 DATABASE format '/paic/restore/paces/20120217/full_%T-%d-%u-%p' filesperset=15 plus archivelog SKIP INACCESSIBLE format '/paic/restore/paces/20120217/arch_%T-%d-%u-%p.log';

backup current controlfile format '/paic/restore/paces/20120217/ctrl_%t-%s-%p.f';

release channel c1;

release channel c2;

release channel c3;

release channel c4;

release channel c5;

release channel c6;

}

 

EOF

 

echo "Backup finished at `date '+%Y%m%d_%H%M%S'`" >> ${log_file}

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14385647/viewspace-748468/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14385647/viewspace-748468/