Database Backup and Recovery (MOSC)

MOSC Banner

RMAN restore is very slow

edited Jun 22, 2010 1:55AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
We have a RAC database (10.2.0.4, p18) with around 150 Gb of datafiles. We are performing a RMAN backup to disk, which is done in appr. 1hr and 15 minutes, using the following config:

RMAN parameters:

CONFIGURE RETENTION POLICY TO recovery window of 28 days; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'z:\backup\%F';

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