Thursday, May 28, 2015

RMAN Backup In ASM Disk Group.

It will help us to take RMAN Backup in ASM Disk Group.

[oracle@OEL564ASMN1 ~]$ rman target/

Recovery Manager: Release 11.2.0.3.0 - Production on Thu May 28 17:16:59 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASMDB (DBID=624768357)

RMAN> backup device type disk format '+RMAN_BACKUP/%U' database plus archivelog delete input;

Starting backup at 28-MAY-15
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=47 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=1 STAMP=880572465
input archived log thread=1 sequence=4 RECID=2 STAMP=880573855
input archived log thread=1 sequence=5 RECID=3 STAMP=880658166
input archived log thread=1 sequence=6 RECID=4 STAMP=880897231
input archived log thread=1 sequence=7 RECID=5 STAMP=880898978
input archived log thread=1 sequence=8 RECID=6 STAMP=880909238
input archived log thread=1 sequence=9 RECID=7 STAMP=880910336
channel ORA_DISK_1: starting piece 1 at 28-MAY-15
channel ORA_DISK_1: finished piece 1 at 28-MAY-15
piece handle=+RMAN_BACKUP/01q83801_1_1 tag=TAG20150528T171856 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRA/asmdb/archivelog/2015_05_24/thread_1_seq_3.260.880572457 RECID=1 STAMP=880572465
archived log file name=+FRA/asmdb/archivelog/2015_05_24/thread_1_seq_4.261.880573849 RECID=2 STAMP=880573855
archived log file name=+FRA/asmdb/archivelog/2015_05_25/thread_1_seq_5.262.880658159 RECID=3 STAMP=880658166
archived log file name=+FRA/asmdb/archivelog/2015_05_28/thread_1_seq_6.263.880897227 RECID=4 STAMP=880897231
archived log file name=+FRA/asmdb/archivelog/2015_05_28/thread_1_seq_7.264.880898973 RECID=5 STAMP=880898978
archived log file name=+FRA/asmdb/archivelog/2015_05_28/thread_1_seq_8.265.880909235 RECID=6 STAMP=880909238
archived log file name=+FRA/asmdb/archivelog/2015_05_28/thread_1_seq_9.266.880910333 RECID=7 STAMP=880910336
Finished backup at 28-MAY-15

Starting backup at 28-MAY-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/asmdb/datafile/system.256.880569463
input datafile file number=00002 name=+DATA/asmdb/datafile/sysaux.257.880569467
input datafile file number=00005 name=+DATA/asmdb/datafile/example.265.880569629
input datafile file number=00003 name=+DATA/asmdb/datafile/undotbs1.258.880569467
input datafile file number=00004 name=+DATA/asmdb/datafile/users.259.880569471
channel ORA_DISK_1: starting piece 1 at 28-MAY-15
channel ORA_DISK_1: finished piece 1 at 28-MAY-15
piece handle=+RMAN_BACKUP/02q8380o_1_1 tag=TAG20150528T171920 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 28-MAY-15
channel ORA_DISK_1: finished piece 1 at 28-MAY-15
piece handle=+RMAN_BACKUP/03q83833_1_1 tag=TAG20150528T171920 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 28-MAY-15

Starting backup at 28-MAY-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=8 STAMP=880910447
channel ORA_DISK_1: starting piece 1 at 28-MAY-15
channel ORA_DISK_1: finished piece 1 at 28-MAY-15
piece handle=+RMAN_BACKUP/04q8383g_1_1 tag=TAG20150528T172047 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRA/asmdb/archivelog/2015_05_28/thread_1_seq_10.266.880910443 RECID=8 STAMP=880910447
Finished backup at 28-MAY-15

RMAN> exit

Recovery Manager complete.
[oracle@OEL564ASMN1 ~]$

=== Backup Piece ====

[grid@OEL564ASMN1 ~]$ asmcmd
ASMCMD> ls
DATA/
FRA/
RMAN_BACKUP/
ASMCMD> cd /RMAN_BACKUP/
ASMCMD> ls
01q83801_1_1
02q8380o_1_1
03q83833_1_1
04q8383g_1_1
ASMDB/
ASMCMD> ls -ltr
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'

Type       Redund  Striped  Time             Sys  Name
                                             Y    ASMDB/
                                             N    01q83801_1_1 => +RMAN_BACKUP/ASMDB/BACKUPSET/2015_05_28/annnf0_TAG20150528T171856_0.256.880910339
                                             N    02q8380o_1_1 => +RMAN_BACKUP/ASMDB/BACKUPSET/2015_05_28/nnndf0_TAG20150528T171920_0.257.880910361
                                             N    03q83833_1_1 => +RMAN_BACKUP/ASMDB/BACKUPSET/2015_05_28/ncsnf0_TAG20150528T171920_0.258.880910437
                                             N    04q8383g_1_1 => +RMAN_BACKUP/ASMDB/BACKUPSET/2015_05_28/annnf0_TAG20150528T172047_0.259.880910449
ASMCMD>

No comments:

Post a Comment