Logo

RMAN Script

RMAN Archive Log Backup

 Tested on Oracle 8.1 Tested on Oracle 8.0

Updated : 08-Jan-2002
Version : 1.0

Description

RMAN Archive Log backup and delete

Parameters

None.

Source

# Resync the catalogue
resync catalog;

# Backup the database
run {
	allocate channel 'dev0' type 'SBT_TAPE';
	allocate channel 'dev1' type 'SBT_TAPE';
	sql 'alter system archive log current';
	backup
		filesperset 50
		archivelog all format '%d_%t_%s_%p.arch';
	backup 
		filesperset 50
		format '%d_%t_%s_%p.arch'
		archivelog all delete input
 		;

# Use this line if you want a time based delete
#		archivelog until time 'sysdate-2' delete input

	release channel dev0;
	release channel dev1;

}

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo