Tuesday, May 13, 2014

Creating Duplex Copies using RMAN 11gR2



1. Check the datafile copies default setting

Recovery Manager: Release 11.2.0.4.0 - Production on Tue May 13 14:28:04 2014

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

connected to target database: CVRMAN (DBID=*********, open)

RMAN> show datafile backup copies;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name CVRMAN are:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default


2.Run the command within the run block

RMAN> run
2> {
3> backup
4> copies 2 #create duplex copies
5> format '+DATA','/SHARED/backup1/%U' # location for backup pieces
6> datafile 2;
7> }

Starting backup at 13-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=31 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
channel ORA_DISK_1: starting piece 1 at 13-MAY-14
channel ORA_DISK_1: finished piece 1 at 13-MAY-14 with 2 copies and tag TAG20140513T143111
piece handle=+DATA/cvrman/backupset/2014_05_13/nnndf0_tag20140513t143111_0.303.847463473 comment=NONE
piece handle=/SHARED/backup1/1lp86h1f_1_2 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
Finished backup at 13-MAY-14

3) Check the duplex backup pieces created for the datafile 2

RMAN> list backup of datafile 2
2> tag="TAG20140513T143111";


List of Backup Sets
===================


BS Key  Type LV Size
------- ---- -- ----------
40      Full    71.81M
  List of Datafiles in backup set 40
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1039635    13-MAY-14 +DATA/cvrman/datafile/sysaux.257.847354793

  Backup Set Copy #1 of backup set 40
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:30     13-MAY-14       YES        TAG20140513T143111

    List of Backup Pieces for backup set 40 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    48      1   AVAILABLE   +DATA/cvrman/backupset/2014_05_13/nnndf0_tag20140513t143111_0.303.847463473

  Backup Set Copy #2 of backup set 40
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:30     13-MAY-14       YES        TAG20140513T143111

    List of Backup Pieces for backup set 40 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    49      1   AVAILABLE   /SHARED/backup1/1lp86h1f_1_2


No comments: