Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman restore datafile : how to force parallelism ?

3138225Mar 21 2017 — edited Mar 23 2017

Hi,

I had to restore rman backup

I used this script!

#!/home/oracle/admgen/ksh

export ORACLE_SID=CARL

. /home/oracle/admin/CARL/dbs/.profileCARL 2> /dev/null

MIPATH=`dirname $0`

MIDATE=`date +%Y%m%d_%H%M%S`

MILOG="$MIPATH/restore_${ORACLE_SID}_${MIDATE}.log"

sqlplus -s "/ as sysdba" <<EOF$ORACLE_SID > /dev/null

shutdown immediate

shutdown abort

startup mount

EOF$ORACLE_SID

rman target / nocatalog <<EOF$ORACLE_SID |tee $MILOG

crosscheck backup;

runĀ  {

allocate channel c1 type disk ; allocate channel c2 type disk ; allocate channel c3 type disk ; allocate channel c4 type disk ; allocate channel c5 type disk ; allocate channel c6 type disk ;

restore datafile '/appli/oradata01/CARL/CARL_system_01.dbf' ;

restore datafile '/appli/oradata03/CARL/CARL_SYSAUX_01.dbf' ;

restore datafile '/appli/oradata03/CARL/undotbs01.dbf' ;

restore datafile '/appli/oradata03/CARL/CARL_users_01.dbf' ;

restore datafile '/appli/oradata03/CARL/CARL_tools_01.dbf' ;

restore datafile '/appli/oradata01/CARL/CARL_tools_02.dbf' ;

restore datafile '/appli/oradata03/CARL/CARL_tools_03.dbf' ;

restore datafile '/appli/oradata01/CARL/TBLS_S03_32.xtf' ;

......

release channel c1; release channel c2; release channel c3; release channel c4; release channel c5; release channel c6;

}

recover database;

Rman configuration:

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name ZEQ332B0CARL are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/sauvebase/CARL/%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/sauvebase/CARL/snap.cf';

The problem is that the datafiles are restored one by oneĀ 

How can i do to force parallelism ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2017
Added on Mar 21 2017
13 comments
4,757 views