RMAN Script RMAN Archivelog Backup

Updated: 24-Nov-2004
Version: 2.0

Description

RMAN Archivelog Backup & Delete

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';
	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;

}

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 Full 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