Logo

RMAN Script

Incremental Backup

 Tested on Oracle 8.1 Tested on Oracle 8.0

Updated : 08-Jan-2002
Version : 1.0

Description

Incremental Database RMAN Backup

Parameters

None.

Source

# Resync the catalogue
resync catalog;

# Backup the database
run {
	allocate channel 'dev0' type 'SBT_TAPE';
	allocate channel 'dev1' type 'SBT_TAPE';
	backup 
		incremental level 2
		cumulative
		tag Full_Oracle_Backup
		filesperset 5 
		format '%d_%t_%s_%p.dbf'
		database 
		;
	backup
		cumulative
		filesperset 5
		format '%d_%t_%s_%p.cf'
		current controlfile
		;
	sql 'alter system archive log current';
	backup
		filesperset 10
		archivelog all format '%d_%t_%s_%p.arch';

	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