Skip to content
Home » Oracle Database » How to Switch the Default Channel From One to Another

How to Switch the Default Channel From One to Another

Let's say, our RMAN is currently running on the channel 'SBT_TAPE' by default. We're planing to switch the default channel to DISK before tapes for shortening recovery time. Especially, the destination for the backup pieces is DB_RECOVERY_FILE_DEST which is recommended by Oracle.

Configure DEVICE TYPE DISK, if necessary.

There already has a default device type settings for disk (but not for sbt), you can suppress it if the default setting does not meet your requirements.

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

Configure a channel for DEVICE TYPE DISK, if necessary.

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G;

new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;
new RMAN configuration parameters are successfully stored

RMAN> SHOW CHANNEL;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2 G;

Did you see that? I configure the disk channel without the modifier FORMAT (e.g. FORMAT '/disk1/ora_df%t_s%s_s%p'). This will make the backup destination goes to DB_RECOVERY_FILE_DEST.

Change the DEFAULT DEVICE TYPE from 'SBT_TAPE' into DISK.

RMAN> SHOW DEFAULT DEVICE TYPE;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored

RMAN> SHOW DEFAULT DEVICE TYPE;

RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;

Clear the device type for 'SBT_TAPE'.

RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' CLEAR;

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
RMAN configuration parameters are successfully reset to default value

Of course, you can also switch back to SBT_TAPE by this procedure.

Leave a Reply

Your email address will not be published. Required fields are marked *