Wednesday, 31 July 2019

RMAN Backup with Multisection Option

RMAN> report schema;

Report of database schema for database with db_unique_name RAC

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    880      SYSTEM               YES     +DATA/RAC/DATAFILE/system.258.1011960053
2    2400     IDATA                NO      +DATA/RAC/DATAFILE/idata.269.1014653909
3    1480     SYSAUX               NO      +DATA/RAC/DATAFILE/sysaux.257.1011959959
4    200      UNDOTBS1             YES     +DATA/RAC/DATAFILE/undotbs1.260.1011960171
5    200      UNDOTBS2             YES     +DATA/RAC/DATAFILE/undotbs2.265.1011960859
6    5        USERS                NO      +DATA/RAC/DATAFILE/users.259.1011960169
7    100      INDX                 NO      +DATA/RAC/DATAFILE/indx.270.1014656575
8    100      ILOG                 NO      +DATA/RAC/DATAFILE/ilog.271.1014656841

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    214      TEMP                 32767       +DATA/RAC/TEMPFILE/temp.264.1011960267

RMAN> RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
BACKUP TABLESPACE IDATA TAG 'IDATA_MULTIS' SECTION SIZE 1200M;
}2> 3> 4> 5> 6>

allocated channel: c1
channel c1: SID=84 instance=rac1 device type=DISK

allocated channel: c2
channel c2: SID=59 instance=rac1 device type=DISK

Starting backup at 30-JUL-19
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
backing up blocks 1 through 153600
channel c1: starting piece 1 at 30-JUL-19
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
backing up blocks 153601 through 307200
channel c2: starting piece 2 at 30-JUL-19

channel c1: finished piece 1 at 30-JUL-19
piece handle=+FRA/RAC/BACKUPSET/2019_07_30/nnndf0_idata_multis_0.417.1014989245 tag=IDATA_MULTIS comment=NONE
channel c1: backup set complete, elapsed time: 00:03:45
channel c2: finished piece 2 at 30-JUL-19
piece handle=+FRA/RAC/BACKUPSET/2019_07_30/nnndf0_idata_multis_0.420.1014989247 tag=IDATA_MULTIS comment=NONE
channel c2: backup set complete, elapsed time: 00:03:45
Finished backup at 30-JUL-19

Starting Control File and SPFILE Autobackup at 30-JUL-19
piece handle=+FRA/RAC/AUTOBACKUP/2019_07_30/s_1014989470.419.1014989473 comment=NONE
Finished Control File and SPFILE Autobackup at 30-JUL-19
released channel: c1
released channel: c2

RMAN>
RMAN> list backupset TAG 'IDATA_MULTIS';


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
128     Full    2.14G      DISK        00:03:40     30-JUL-19
  List of Datafiles in backup set 128
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 13961427   30-JUL-19 +DATA/RAC/DATAFILE/idata.269.1014653909

  Backup Set Copy #1 of backup set 128
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:40     30-JUL-19       NO         IDATA_MULTIS

    List of Backup Pieces for backup set 128 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    129     1   AVAILABLE   +FRA/RAC/BACKUPSET/2019_07_30/nnndf0_idata_multis_0.417.1014989245
    128     2   AVAILABLE   +FRA/RAC/BACKUPSET/2019_07_30/nnndf0_idata_multis_0.420.1014989247

RMAN>

No comments:

Post a Comment