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>
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