export ORACLE_SID=orcl
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
BCK=`date "+%Y%m%d"`
mkdir /home/oracle/backup/BACKUP_FULL/backup_full_$BCK
mkdir /home/oracle/backup/BACKUP_FULL/backup_full_$BCK/datafile
mkdir /home/oracle/backup/BACKUP_FULL/backup_full_$BCK/cfile
mkdir /home/oracle/backup/BACKUP_FULL/backup_full_$BCK/archive
/u01/app/oracle/product/10.2.0/db_1/bin/rman target / LOG=/home/oracle/backup/BACKUP_FULL/LOG_BACKUP/backup_full_$BCK.log << EOF
run
{
allocate channel bck1 type disk;
allocate channel bck2 type disk;
allocate channel bck3 type disk;
backup
incremental level 0
tag full_backup
format '/home/oracle/backup/BACKUP_FULL/backup_full_$BCK/datafile/df_full_%T_d%d_p%p_u%u_c%c.bak'
(database);
backup
incremental level 0
tag full_backup
format '/home/oracle/backup/BACKUP_FULL/backup_full_$BCK/cfile/cf_full_%T_d%d_p%p_u%u_c%c.bak'
(current controlfile);
backup
tag full_backup
format '/home/oracle/backup/BACKUP_FULL/backup_full_$BCK/archive/arclog_full_%T_d%d_p%p_u%u_c%c.bak'
(archivelog all);
release channel bck1;
release channel bck2;
release channel bck3;
DELETE NOPROMPT OBSOLETE;
}
EOF
Tidak ada komentar:
Posting Komentar