RMAN BACKUPS

hot
---------
RUN
{
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/par1/oracle/par1/incr/%d_HOT_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/par1/oracle/par1/incr/%d_HOT_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH3 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/par1/oracle/par1/incr/%d_HOT_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH4 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/par1/oracle/par1/incr/%d_HOT_%M%D%Y_%p_%s';
BACKUP AS COMPRESSED BACKUPSET INCREMENTAL LEVEL = 0 DATABASE TAG par1_HOTINCR_0110_1323;
BACKUP FORMAT '/disk/copy01/oracle/par1/oracle/par1/control/%d_%M_%D_%Y_%t.ctl' CURRENT CONTROLFILE TAG par1_CONTROLFILE_0110_1323;
sql "alter system archive log current";
backup AS COMPRESSED BACKUPSET archivelog all format '/eoaprod/backup01/oracle/ttprmdp1/oracle/ttprmdp1/arch/%d_ARCH_%M%D%Y_%p_%s';
}


archives
---------------
RUN
{
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/evmp/oracle/evmp/arch/%d_ARCH_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/evmp/oracle/evmp/arch/%d_ARCH_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH3 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/evmp/oracle/evmp/arch/%d_ARCH_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH4 DEVICE TYPE DISK FORMAT '/disk/copy01/oracle/evmp/oracle/evmp/arch/%d_ARCH_%M%D%Y_%p_%s';
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL TAG evmp_ARCH_0110_1418 DELETE INPUT;
RESYNC CATALOG;
}


cold
------------
shu immediate
startup mount
RUN
{
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '/disk/backup/oracle/d1epp2/oracle/d1epp2/full/%d_COLD_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK FORMAT '/disk/backup/oracle/d1epp2/oracle/d1epp2/full/%d_COLD_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH3 DEVICE TYPE DISK FORMAT '/disk/backup/oracle/d1epp2/oracle/d1epp2/full/%d_COLD_%M%D%Y_%p_%s';
ALLOCATE CHANNEL CH4 DEVICE TYPE DISK FORMAT '/disk/backup/oracle/d1epp2/oracle/d1epp2/full/%d_COLD_%M%D%Y_%p_%s';
BACKUP AS COMPRESSED BACKUPSET FULL DATABASE TAG lportal_COLD_0109_0030;
BACKUP FORMAT '/disk/backup/oracle/d1epp2/oracle/d1epp2/full/%d_%M_%D_%Y_%t.ctl' CURRENT CONTROLFILE TAG lportal_CONTROLFILE_0109_0030;
}

sql 'alter database open';


tape copy of backup
-----------------------
RUN
{
ALLOCATE CHANNEL CH1 DEVICE TYPE SBT PARMS 'BLKSIZE=262144';
ALLOCATE CHANNEL CH2 DEVICE TYPE SBT PARMS 'BLKSIZE=262144';
ALLOCATE CHANNEL CH3 DEVICE TYPE SBT PARMS 'BLKSIZE=262144';
ALLOCATE CHANNEL CH4 DEVICE TYPE SBT PARMS 'BLKSIZE=262144';
SEND 'NB_ORA_SCHED=USER_BACK_5WEEK';
BACKUP FORMAT '%d_TAPECOPY_%M%D%Y_%p_%s' BACKUPSET ALL;
BACKUP FORMAT '%d_%M_%D_%Y_%t.ctl' CURRENT CONTROLFILE TAG par1_CONTROLFILE_0110_1348;
}

SCRIPT TO RESTORE RMAN TAPE ARCHIVE:

restore archivelog time between 'SYSDATE-3' and 'SYSDATE';
restore archivelog until time "to_date('27-05-2008','DD-MM-YYYY')";
restore archivelog sequence between 1 and 10;



restore archivelog logseq=4 from tag=TAG20090131T125120;
restore archivelog logseq=1 until logseq=5 from tag=TAG20090131T125145;

restoring archs to different location
-------------------------------------------
run {
set archivelog destination to 'desiredlocation';
restore archivelog all;
 }

ALLOCATE CHANNEL CH1 DEVICE TYPE SBT;
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;

run
{
set archivelog destination to '/vc01pdb035/arch01/oracle/marp/arch/sg';
restore archivelog logseq=578 until logseq=579 from TAG=MARP_ARCH_0608_2130;
}

run
{
set archivelog destination to '/vc01pdb035/arch01/oracle/marp/arch/sg';
ALLOCATE CHANNEL CH1 DEVICE TYPE SBT;
ALLOCATE CHANNEL CH2 DEVICE TYPE SBT;
ALLOCATE CHANNEL CH3 DEVICE TYPE SBT;
ALLOCATE CHANNEL CH4 DEVICE TYPE DISK;
ALLOCATE CHANNEL CH5 DEVICE TYPE DISK;
ALLOCATE CHANNEL CH6 DEVICE TYPE DISK;
restore archivelog sequence between 1 and 10;
}

run
{
ALLOCATE CHANNEL CH1 DEVICE TYPE SBT;
ALLOCATE CHANNEL CH2 DEVICE TYPE DISK;
SET NEWNAME FOR DATAFILE 1 TO '/xyz/file_01.dbf';
restore datafile 1;
}

run
{
restore database from tag="BACKUP_ULYSSE_DEV_020706103001";
}