Pages

Monday, July 15, 2013

How to take RMAN Disk backup while Tape backup is configured ? [ TESTED ]


The below script overrides the DEFAULT DEVICE TYPE for backup.



RMAN> SHOW DEFAULT DEVICE TYPE;

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

RMAN> run
{
backup AS COMPRESSED BACKUPSET device type disk database 
format '/ora/dbbkp/DB_%d_%t_%s_%p' plus archivelog format '/ora/dbbkp/Archive_%d_%U';
backup AS COMPRESSED BACKUPSET device type disk current controlfile tag =cf1 
format '/ora/dbbkp/ctrlfile_%t_%s_p%p.dbf';
backup AS COMPRESSED BACKUPSET device type disk spfile 
format '/ora/dbbkp/Manual_spfile_%t_%s_p%p.dbf';




No comments:

Post a Comment