RMAN Script RMAN Full Backup

Updated: 24-Nov-2004
Version: 2.0

Description

Full Database backup script using RMAN

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

# Resync the catalogue
resync catalog;

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

	release channel dev0;
	release channel dev1;

}

allocate channel for delete type disk;

# validate backups older than 8 days. If they are no longer on tape then mark then for deletion
crosscheck backup completed before 'SYSDATE-8';

# delete expired backups
delete expired backup;

Related Links

Oracle 8i: (RMAN Script) RMAN Archivelog Backup

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links