Database Backup and Recovery (MOSC)

MOSC Banner

RMAN backup optimization

edited Jun 18, 2010 1:32AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
  Hi

we have configured RMAN backup with backup optimization on
The database is a TEST database for testing RMAN backups and recovery and does not get changed at all
we run the database backup everynight

here is the script

configure channel device type disk clear;
configure channel device type sbt clear;
configure retention policy to recovery window of 1 days;
configure controlfile autobackup on;
configure device type disk backup type to backupset;
configure channel 1 device type disk format 'd:\rmanbkp\%U' maxpiecesize 2048 M;
configure controlfile autobackup format for device type disk to 'd:\rmanbkp\cfspf_%F';
configure backup optimization on;
run {

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center