Thursday, June 26, 2014

Oracle RMAN Backup backupset to disk

At occasions there will be need to backup your previously take backup on to a disk, you can either copy the pieces from ASM or you can use RMAN to do this work and below is how this is done. I have tired taking another copy of existing backups on to disk 

RMAN> list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
3381    B  A  A DISK        26-JUN-14       1       1       NO         FULL_DB_RAC
3382    B  A  A DISK        26-JUN-14       1       1       NO         FULL_DB_RAC
3383    B  A  A DISK        26-JUN-14       1       1       NO         FULL_DB_RAC
3487    B  F  A DISK        26-JUN-14       1       1       NO         FULL_DB_RAC
3518    B  A  A DISK        26-JUN-14       1       1       NO         FULL_DB_RAC
3538    B  F  A DISK        26-JUN-14       1       1       NO         TAG20140626T125712
RMAN> run {
2> allocate channel t1 device type disk format '/home/oracle/test/%d_%p_%I_%T_%U';
3> backup backupset 3381, 3382, 3383, 3487,3518;
4> }
allocated channel: t1
channel t1: SID=101 instance=RAC1 device type=DISK
Starting backup at 26-JUN-14
channel t1: input backup set: count=58, stamp=851258835, piece=1
channel t1: starting piece 1 at 26-JUN-14
channel t1: backup piece +FRA/rac/backupset/2014_06_26/annnf0_full_db_rac_0.407.851258837
piece handle=/home/oracle/test/RAC_1_2410645064_20140626_1qpbqbej_1_2 comment=NONE
channel t1: finished piece 1 at 26-JUN-14
channel t1: backup piece complete, elapsed time: 00:03:43
channel t1: input backup set: count=59, stamp=851258972, piece=1
channel t1: starting piece 1 at 26-JUN-14
channel t1: backup piece +FRA/rac/backupset/2014_06_26/annnf0_full_db_rac_0.495.851258975
piece handle=/home/oracle/test/RAC_1_2410645064_20140626_1rpbqbis_1_2 comment=NONE
channel t1: finished piece 1 at 26-JUN-14
channel t1: backup piece complete, elapsed time: 00:02:52
channel t1: input backup set: count=60, stamp=851259110, piece=1
channel t1: starting piece 1 at 26-JUN-14
channel t1: backup piece +FRA/rac/backupset/2014_06_26/annnf0_full_db_rac_0.491.851259111
piece handle=/home/oracle/test/RAC_1_2410645064_20140626_1spbqbn6_1_2 comment=NONE
channel t1: finished piece 1 at 26-JUN-14
channel t1: backup piece complete, elapsed time: 00:00:15
channel t1: input backup set: count=61, stamp=851259114, piece=1
channel t1: starting piece 1 at 26-JUN-14
channel t1: backup piece +FRA/rac/backupset/2014_06_26/nnndf0_full_db_rac_0.500.851259117
piece handle=/home/oracle/test/RAC_1_2410645064_20140626_1tpbqbna_1_2 comment=NONE
channel t1: finished piece 1 at 26-JUN-14
channel t1: backup piece complete, elapsed time: 00:05:17
channel t1: input backup set: count=62, stamp=851259429, piece=1
channel t1: starting piece 1 at 26-JUN-14
channel t1: backup piece +FRA/rac/backupset/2014_06_26/annnf0_full_db_rac_0.418.851259429
piece handle=/home/oracle/test/RAC_1_2410645064_20140626_1upbqc15_1_2 comment=NONE
channel t1: finished piece 1 at 26-JUN-14
channel t1: backup piece complete, elapsed time: 00:00:27
Finished backup at 26-JUN-14
RMAN>  list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
3381    B  A  A DISK        26-JUN-14       1       2       NO         FULL_DB_RAC
3382    B  A  A DISK        26-JUN-14       1       2       NO         FULL_DB_RAC
3383    B  A  A DISK        26-JUN-14       1       2       NO         FULL_DB_RAC
3487    B  F  A DISK        26-JUN-14       1       2       NO         FULL_DB_RAC
3518    B  A  A DISK        26-JUN-14       1       2       NO         FULL_DB_RAC
3538    B  F  A DISK        26-JUN-14       1       1       NO         TAG20140626T125712
RMAN>
[oracle@rac1 test]$ pwd
/home/oracle/test
[oracle@rac1 test]$ ls -lah
total 3.4G
drwxr-xr-x.  2 oracle oinstall 4.0K Jun 26 14:59 .
drwxr-xr-x. 30 oracle oinstall 4.0K Jun 24 15:25 ..
-rw-r-----.  1 oracle dba      946M Jun 26 14:50 RAC_1_2410645064_20140626_1qpbqbej_1_2
-rw-r-----.  1 oracle dba      873M Jun 26 14:53 RAC_1_2410645064_20140626_1rpbqbis_1_2
-rw-r-----.  1 oracle dba      6.2M Jun 26 14:53 RAC_1_2410645064_20140626_1spbqbn6_1_2
-rw-r-----.  1 oracle dba      1.6G Jun 26 14:58 RAC_1_2410645064_20140626_1tpbqbna_1_2
-rw-r-----.  1 oracle dba      879K Jun 26 14:59 RAC_1_2410645064_20140626_1upbqc15_1_2
[oracle@rac1 test]$ 

No comments: