OraFAQ Forum: Backup & Recovery » RMAN Backup Script (merged 3)

Home » RDBMS Server » Backup & Recovery » RMAN Backup Script (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN Backup Script (merged 3) [message #413527]

Thu, 16 July 2009 04:46

html
Messages: 1
Registered: July 2009

Junior Member

I'm new to Oracle DB Admin. Can anybody explain to me wht actually below code doing??? if posibble by line by line, thks Smile

run {
allocate channel chn1 TYPE disk ;
allocate channel chn2 TYPE disk ;
allocate channel chn3 TYPE disk ;
allocate channel chn4 TYPE disk ;

backup incremental level 0
tag 'hot_db_bk_level0'
filesperset 4
format '/u02/backup/bk_%s_%Y%M%D_%t'
as compressed backupset
database;

sql 'alter system archive log current';

BACKUP
filesperset 20
FORMAT '/u02/backup/al_%s_%Y%M%D_%t'
as compressed BACKUPSET
ARCHIVELOG ALL DELETE INPUT;

BACKUP
FORMAT '/u02/backup/ctl-%I-%Y%M%D_%t'
CURRENT CONTROLFILE;

release channel chn1;
release channel chn2;
release channel chn3;
release channel chn4;
}

Report message to a moderator