Identify four RMAN commands that produce a multi-section backup.

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A.
BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B.
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

C.
BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

D.
BACKUP TABLESPACE “TEMP” SECTION SIZE 10M;

E.
BACKUP TABLESPACE “UNDO” INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

F.
BACKUP SPFILE SECTION SIZE 1M;

G.
BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Explanation:

Show Hint

Leave a Reply 8

Your email address will not be published. Required fields are marked *

ora600

ora600

A,B,C,G

Reply

ora600

ora600

Oh sorry, I was wrong!
Correct answer: A,B,E,G
*Not C because “Specifies the size of each backup section produced during a data file or data file copy backup.” archivelogs are no datafiles and no file copys
*Not D because tempfiles are never backed up

Reply

bella2016

bella2016

A, B, C, G

A
RMAN> BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=41 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set

B
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

Starting backup at 02-AUG-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/PRUEBA/DATAFILE/system.261.915813835
backing up blocks 1 through 12800
output file name=+FRA/PRUEBA/DATAFILE/system.318.918835531 tag=TAG20160802T160530
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:16
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/PRUEBA/DATAFILE/system.261.915813835

C
RMAN> BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

Starting backup at 02-AUG-16
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=60 RECID=58 STAMP=917205835
input archived log thread=1 sequence=61 RECID=59 STAMP=917215264
input archived log thread=1 sequence=62 RECID=60 STAMP=917215416
input archived log thread=1 sequence=63 RECID=61 STAMP=917215525

G
RMAN> BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Starting backup at 02-AUG-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/PRUEBA/DATAFILE/sysaux.266.915813749
backing up blocks 1 through 12800
channel ORA_DISK_1: starting piece 1 at 02-AUG-16
channel ORA_DISK_1: finished piece 1 at 02-AUG-16

D
RMAN> BACKUP TABLESPACE “TEMP” SECTION SIZE 10M;

Starting backup at 02-AUG-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/02/2016 16:07:57
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name “TEMP”

E
RMAN> BACKUP TABLESPACE “UNDO” INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

Starting backup at 02-AUG-16
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/02/2016 16:08:18

RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name “UNDO”

RMAN> BACKUP SPFILE SECTION SIZE 1M;

Starting backup at 02-AUG-16
using channel ORA_DISK_1
PSDRPC returns significant error 1013.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/02/2016 16:08:33
ORA-01013: user requested cancel of current operation

Reply

bella2016

bella2016

Corrijo el F

RMAN> BACKUP SPFILE SECTION SIZE 1M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=90 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 02-AUG-16
channel ORA_DISK_1: finished piece 1 at 02-AUG-16
piece handle=+FRA/PRUEBA/BACKUPSET/2016_08_02/nnsnf0_tag20160802t164258_0.293.918837779 tag=TAG20160802T164258 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-AUG-16

Reply

Alexis

Alexis

A,B,C,F and G this CORRECT

9 Backing Up the Database
Specifying Multisection Incremental Backups
Making Multisection Backups Using Image Copies

https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV380

SQL> SELECT COMPLETION_TIME, BLOCKS, DATAFILE_BLOCKS, BLOCK_SIZE, BLOCKS_READ from v$BACKUP_DATAFILE;

COMPLETIO BLOCKS DATAFILE_BLOCKS BLOCK_SIZE BLOCKS_READ
——— ———- ————— ———- ———–
02-AUG-16 85238 101120 8192 100224
02-AUG-16 1096 1096 16384 1096
02-AUG-16 1096 1096 16384 1096
02-AUG-16 1096 1096 16384 1096
02-AUG-16 76068 99840 8192 94336
02-AUG-16 1096 1096 16384 1096

5 rows selected.

http://www.oracle-scn.com/rman-12c-new-feature-multisection-backup/

From Oracle 12c RMAN, Multisection Backups are supported for the below.,

Backup using Backup sets and Image Copies.
Full Backups using Backup sets and Image Copies.
Incremental level 0 backups and higher than level 0

A very important point to note here is,

If we specify the SECTION SIZE larger than the actual Datafile size, then RMAN does not use the Multi-Section option.

* OPTION A – CORRECT

RMAN> BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11 device type=DISK
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 1 through 12800
channel ORA_DISK_1: starting piece 1 at 02-AUG-16
channel ORA_DISK_1: finished piece 1 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1ldlvj_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 12801 through 25600
channel ORA_DISK_1: starting piece 2 at 02-AUG-16
channel ORA_DISK_1: finished piece 2 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1lfct0_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 25601 through 38400
channel ORA_DISK_1: starting piece 3 at 02-AUG-16
channel ORA_DISK_1: finished piece 3 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1lgj5f_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 38401 through 51200
channel ORA_DISK_1: starting piece 4 at 02-AUG-16
channel ORA_DISK_1: finished piece 4 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1lhbg9_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 51201 through 64000
channel ORA_DISK_1: starting piece 5 at 02-AUG-16
channel ORA_DISK_1: finished piece 5 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1lj3yd_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 64001 through 76800
channel ORA_DISK_1: starting piece 6 at 02-AUG-16
channel ORA_DISK_1: finished piece 6 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1ljxg5_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 76801 through 89600
channel ORA_DISK_1: starting piece 7 at 02-AUG-16
channel ORA_DISK_1: finished piece 7 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1lkqb4_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
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=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 89601 through 101120
channel ORA_DISK_1: starting piece 8 at 02-AUG-16
channel ORA_DISK_1: finished piece 8 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnndf_TAG2016 0802T112553_ct1llkc9_.bkp tag=TAG20160802T112553 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 02-AUG-16

Starting Control File and SPFILE Autobackup at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2016_08_02/o1_mf_s_918818492_ ct1lmn60_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 02-AUG-16

* OPTION B – CORRECT

RMAN> BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=249 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 1 through 12800
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 12801 through 25600
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:59
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 25601 through 38400
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 38401 through 51200
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 51201 through 64000
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 64001 through 76800
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 76801 through 89600
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_98zk d0yc_.dbf
backing up blocks 89601 through 101120
output file name=/u01/app/oracle/fast_recovery_area/CDB1/datafile/o1_mf_system_ct1lfgjc_.dbf tag=TAG20160802T112621
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 02-AUG-16

Starting Control File and SPFILE Autobackup at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2016_08_02/o1_mf_s_918818492_ ct1lpvrw_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 02-AUG-16

RMAN>

* OPTION C – CORRECT

RMAN> BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

Starting backup at 02-AUG-16
using channel ORA_DISK_1
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 02-AUG-16

RMAN>

* OPTION D – INCORRECT

RMAN> BACKUP TABLESPACE “TEMP” SECTION SIZE 10M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=16 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/02/2016 11:34:18
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name “???TEMP???”

RMAN>

* OPTION E – INCORRECT

RMAN> BACKUP TABLESPACE “UNDO” INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=254 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/02/2016 11:34:38
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name “???UNDO???”

* OPTION F – CORRECT

RMAN> BACKUP SPFILE SECTION SIZE 1M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 02-AUG-16
channel ORA_DISK_1: finished piece 1 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnsnf_TAG20160802T113509_ct1lxxjk_.bkp tag=TAG20160802T113509 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-AUG-16

Starting Control File and SPFILE Autobackup at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2016_08_02/o1_mf_s_918818492_ct1lxz77_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 02-AUG-16

* OPTION G – CORRECT

RMAN> BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Starting backup at 02-AUG-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=257 device type=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 1 through 12800
channel ORA_DISK_1: starting piece 1 at 02-AUG-16
channel ORA_DISK_1: finished piece 1 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1lyocm_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 12801 through 25600
channel ORA_DISK_1: starting piece 2 at 02-AUG-16
channel ORA_DISK_1: finished piece 2 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1lywlh_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 25601 through 38400
channel ORA_DISK_1: starting piece 3 at 02-AUG-16
channel ORA_DISK_1: finished piece 3 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1lz3t5_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 38401 through 51200
channel ORA_DISK_1: starting piece 4 at 02-AUG-16
channel ORA_DISK_1: finished piece 4 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1lzc2y_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 51201 through 64000
channel ORA_DISK_1: starting piece 5 at 02-AUG-16
channel ORA_DISK_1: finished piece 5 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1lzlbt_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 64001 through 76800
channel ORA_DISK_1: starting piece 6 at 02-AUG-16
channel ORA_DISK_1: finished piece 6 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1lzsjm_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 76801 through 89600
channel ORA_DISK_1: starting piece 7 at 02-AUG-16
channel ORA_DISK_1: finished piece 7 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1m00ro_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/CDB1/datafile/o1_mf_sysaux_98zk9zr6_.dbf
backing up blocks 89601 through 99840
channel ORA_DISK_1: starting piece 8 at 02-AUG-16
channel ORA_DISK_1: finished piece 8 at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2016_08_02/o1_mf_nnnd0_TAG20160802T113533_ct1m07y2_.bkp tag=TAG20160802T113533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 02-AUG-16

Starting Control File and SPFILE Autobackup at 02-AUG-16
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2016_08_02/o1_mf_s_918818492_ct1m0cth_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 02-AUG-16

RMAN>

Reply

tanglihui

tanglihui

RMAN> BACKUP ARCHIVELOG ALL SECTION SIZE 2M;

Starting backup at 12-NOV-16
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=137 RECID=111 STAMP=927735988
input archived log thread=1 sequence=138 RECID=112 STAMP=927735989
input archived log thread=1 sequence=139 RECID=113 STAMP=927735991
input archived log thread=1 sequence=140 RECID=114 STAMP=927735991
input archived log thread=1 sequence=141 RECID=115 STAMP=927736053
input archived log thread=1 sequence=142 RECID=116 STAMP=927736256
input archived log thread=1 sequence=143 RECID=117 STAMP=927736265
input archived log thread=1 sequence=144 RECID=118 STAMP=927736287
input archived log thread=1 sequence=145 RECID=119 STAMP=927736290
input archived log thread=1 sequence=146 RECID=120 STAMP=927736374
channel ORA_DISK_1: starting piece 1 at 12-NOV-16
channel ORA_DISK_1: finished piece 1 at 12-NOV-16
piece handle=/u01/app/oracle/fast_recovery_area/TESTCDB/backupset/2016_11_12/o1_mf_annnn_TAG20161112T163254_d2fnxpk2_.bkp tag=TAG20161112T163254 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 12-NOV-16

Starting Control File and SPFILE Autobackup at 12-NOV-16
piece handle=/u01/app/oracle/fast_recovery_area/TESTCDB/autobackup/2016_11_12/o1_mf_s_927736390_d2fny6pb_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 12-NOV-16

Reply