Senin, 19 Juli 2010

scrip backup level 0 / full online backup dengan RMAN

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