Em algumas situações, podemos nos deparar com a necessidade de realizar um backup RMAN de um arquivo muito grande (proveniente de uma Bigfile Tablespace, que por exemplo na versão 12.1 pode chegar até 128TB). No passado, essa operação seria muito demorada, pois haveria apenas um processo do RMAN realizando, de forma serializada, o backup. A partir deste cenário, a Oracle disponibilizou o recurso de Multisection Backups, onde podemos “quebrar” estes arquivos em sessões/pedaços para serem backupeados independentemente, e em paralelo, gerando assim um backup piece para cada sessão. Podemos usar esta opção para backup sets (full ou incrementais) e backups do tipo image copy. Lembrando que é importante validarmos se teremos este backup paralelizado rodando em Storage Devices diferentes (como representa o desenho abaixo). Neste artigo vamos explorar sua aplicação prática com um exemplo simples.
Realizando um REPORT SCHEMA para ver o tamanho atual das tablespaces em meu laboratório:
[oracle@oel8 ~]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Sat May 1 04:14:19 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: RMANDB (DBID=3825250984)
RMAN> REPORT SCHEMA;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name RMANDB
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 860 SYSTEM YES /oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
3 680 SYSAUX NO /oracle/dados/RMANDB/datafile/o1_mf_sysaux_h8nyq35q_.dbf
4 305 UNDOTBS1 YES /oracle/dados/RMANDB/datafile/o1_mf_undotbs1_h8nyrjdr_.dbf
5 200 TS_CORTEX_CATALOG NO /oracle/dados/RMANDB/datafile/ts_cortex_catalog.dbf
7 16 USERS NO /oracle/dados/RMANDB/datafile/o1_mf_users_h8nyrkn7_.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 32 TEMP 32767 /oracle/dados/RMANDB/datafile/o1_mf_temp_h8nyvt1f_.tmp
Realizando um backup da tablespace SYSTEM, que possui 860MB, sem o recurso de Multisection. O que é possível abstrair: O RMAN cria apenas um canal (ORA_DISK_1) que fará o backup de forma serializada em apenas um backup piece:
RMAN> BACKUP TABLESPACE SYSTEM;
Starting backup at 2021-05-01:04:28:42
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=77 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=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
channel ORA_DISK_1: starting piece 1 at 2021-05-01:04:28:43
channel ORA_DISK_1: finished piece 1 at 2021-05-01:04:28:58
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp tag=TAG20210501T042843 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 2021-05-01:04:28:58
Starting Control File and SPFILE Autobackup at 2021-05-01:04:28:58
piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376138_j8t0sv3f_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-05-01:04:29:01
RMAN> LIST BACKUP OF TABLESPACE SYSTEM;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
275 Full 738.98M DISK 00:00:03 2021-05-01:04:28:46
BP Key: 277 Status: AVAILABLE Compressed: NO Tag: TAG20210501T042843
Piece Name: /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp
List of Datafiles in backup set 275
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 Full 2608562 2021-05-01:04:28:43 NO /oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
Deletando backup:
RMAN> DELETE BACKUPSET;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
277 275 1 1 AVAILABLE DISK /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp
278 276 1 1 AVAILABLE DISK /oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376138_j8t0sv3f_.bkp
Do you really want to delete the above objects (enter YES or NO)? Y
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T042843_j8t0sck9_.bkp RECID=277 STAMP=1071376123
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376138_j8t0sv3f_.bkp RECID=278 STAMP=1071376139
Deleted 2 objects
Realizando o backup da mesma tablespace adicionando a opção “SECTION SIZE” no comando. Podemos observer que, apesar de criar backup pieces a mais, o RMAN ainda utiliza apenas 1 canal (pois o parâmetro DEVICE TYPE está com paralelismo definido em seu valor padrão, que é 1):
[oracle@oel8 ~]$ rman target /
Recovery Manager: Release 18.0.0.0.0 - Production on Sat May 1 04:30:46 2021
Version 18.13.0.0.0
Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.
connected to target database: RMANDB (DBID=3825250984)
RMAN> SHOW DEVICE TYPE;
RMAN configuration parameters for database with db_unique_name RMANDB are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
RMAN> BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;
Starting backup at 2021-05-01:04:30:54
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=57 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=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 1 through 51200
channel ORA_DISK_1: starting piece 1 at 2021-05-01:04:30:55
channel ORA_DISK_1: finished piece 1 at 2021-05-01:04:31:02
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp tag=TAG20210501T043055 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
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=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 51201 through 102400
channel ORA_DISK_1: starting piece 2 at 2021-05-01:04:31:02
channel ORA_DISK_1: finished piece 2 at 2021-05-01:04:31:09
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp tag=TAG20210501T043055 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
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=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 102401 through 110080
channel ORA_DISK_1: starting piece 3 at 2021-05-01:04:31:09
channel ORA_DISK_1: finished piece 3 at 2021-05-01:04:31:10
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp tag=TAG20210501T043055 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2021-05-01:04:31:10
Starting Control File and SPFILE Autobackup at 2021-05-01:04:31:10
piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376270_j8t0xyw9_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-05-01:04:31:11
RMAN> LIST BACKUP OF TABLESPACE SYSTEM;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
277 Full 739.08M DISK 00:00:14 2021-05-01:04:31:09
List of Datafiles in backup set 277
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 Full 2608689 2021-05-01:04:30:55 NO /oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
Backup Set Copy #1 of backup set 277
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:14 2021-05-01:04:31:09 NO TAG20210501T043055
List of Backup Pieces for backup set 277 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
279 1 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp
280 2 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp
281 3 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp
Deletando backup:
RMAN> DELETE BACKUPSET;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
279 277 1 1 AVAILABLE DISK /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp
280 277 2 1 AVAILABLE DISK /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp
281 277 3 1 AVAILABLE DISK /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp
282 278 1 1 AVAILABLE DISK /oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376270_j8t0xyw9_.bkp
Do you really want to delete the above objects (enter YES or NO)? Y
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xh5f_.bkp RECID=279 STAMP=1071376255
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xp8v_.bkp RECID=280 STAMP=1071376262
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043055_j8t0xxf0_.bkp RECID=281 STAMP=1071376269
deleted backup piece
backup piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376270_j8t0xyw9_.bkp RECID=282 STAMP=1071376270
Deleted 4 objects
Realizando o backup com a mesma opção de SECTION SIZE, porém fazendo a abertura dos canais de forma manual, para que o processo seja feito em paralelo. Lembrando que caso queiramos delegar ao RMAN a abertura de múltiplos canais conforme a situação, basta definirmos o paralelismo no parâmetro DEVICE TYPE:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;
}2> 3> 4> 5> 6>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=77 device type=DISK
allocated channel: c2
channel c2: SID=76 device type=DISK
allocated channel: c3
channel c3: SID=69 device type=DISK
Starting backup at 2021-05-01:04:33:27
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 1 through 51200
channel c1: starting piece 1 at 2021-05-01:04:33:27
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 51201 through 102400
channel c2: starting piece 2 at 2021-05-01:04:33:27
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 102401 through 110080
channel c3: starting piece 3 at 2021-05-01:04:33:27
channel c1: finished piece 1 at 2021-05-01:04:33:36
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043327_j8t127o9_.bkp tag=TAG20210501T043327 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:09
channel c3: finished piece 3 at 2021-05-01:04:33:36
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043327_j8t1280b_.bkp tag=TAG20210501T043327 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:09
channel c2: finished piece 2 at 2021-05-01:04:33:44
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043327_j8t127xk_.bkp tag=TAG20210501T043327 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:17
Finished backup at 2021-05-01:04:33:44
Starting Control File and SPFILE Autobackup at 2021-05-01:04:33:44
piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376424_j8t12rsf_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-05-01:04:33:45
released channel: c1
released channel: c2
released channel: c3
RMAN> LIST BACKUP OF TABLESPACE SYSTEM;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
279 Full 739.08M DISK 00:00:04 2021-05-01:04:33:31
List of Datafiles in backup set 279
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 Full 2608837 2021-05-01:04:33:27 NO /oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
Backup Set Copy #1 of backup set 279
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:04 2021-05-01:04:33:36 NO TAG20210501T043327
List of Backup Pieces for backup set 279 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
284 1 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043327_j8t127o9_.bkp
285 2 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043327_j8t127xk_.bkp
283 3 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnndf_TAG20210501T043327_j8t1280b_.bkp
Dando exemplo do mesmo recurso funcionando em backup incremental:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP INCREMENTAL LEVEL 1 SECTION SIZE 400M DATAFILE '/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf';
}2> 3> 4> 5> 6>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=58 device type=DISK
allocated channel: c2
channel c2: SID=57 device type=DISK
allocated channel: c3
channel c3: SID=72 device type=DISK
Starting backup at 2021-05-01:04:37:20
no parent backup or copy of datafile 1 found
channel c1: starting incremental level 1 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 1 through 51200
channel c1: starting piece 1 at 2021-05-01:04:37:20
channel c2: starting incremental level 1 datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 51201 through 102400
channel c2: starting piece 2 at 2021-05-01:04:37:20
channel c3: starting incremental level 1 datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 102401 through 110080
channel c3: starting piece 3 at 2021-05-01:04:37:20
channel c1: finished piece 1 at 2021-05-01:04:37:28
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnnd1_TAG20210501T043720_j8t19jgq_.bkp tag=TAG20210501T043720 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:08
channel c3: finished piece 3 at 2021-05-01:04:37:28
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnnd1_TAG20210501T043720_j8t19jr1_.bkp tag=TAG20210501T043720 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:08
channel c2: finished piece 2 at 2021-05-01:04:37:28
piece handle=/oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnnd1_TAG20210501T043720_j8t19jog_.bkp tag=TAG20210501T043720 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:08
Finished backup at 2021-05-01:04:37:28
Starting Control File and SPFILE Autobackup at 2021-05-01:04:37:28
piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376648_j8t19sg9_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-05-01:04:37:31
released channel: c1
released channel: c2
released channel: c3
RMAN> LIST BACKUP OF DATAFILE 1;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
281 Incr 1 723.13M DISK 00:00:04 2021-05-01:04:37:24
List of Datafiles in backup set 281
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 0 Incr 2609032 2021-05-01:04:37:20 NO /oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
Backup Set Copy #1 of backup set 281
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
DISK 00:00:04 2021-05-01:04:37:28 NO TAG20210501T043720
List of Backup Pieces for backup set 281 Copy #1
BP Key Pc# Status Piece Name
------- --- ----------- ----------
288 1 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnnd1_TAG20210501T043720_j8t19jgq_.bkp
289 2 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnnd1_TAG20210501T043720_j8t19jog_.bkp
287 3 AVAILABLE /oracle/fra/RMANDB/backupset/2021_05_01/o1_mf_nnnd1_TAG20210501T043720_j8t19jr1_.bkp
Exemplo com Image Copy:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP AS COPY SECTION SIZE 400M TABLESPACE SYSTEM;
}2> 3> 4> 5> 6>
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=72 device type=DISK
allocated channel: c2
channel c2: SID=76 device type=DISK
allocated channel: c3
channel c3: SID=77 device type=DISK
Starting backup at 2021-05-01:04:41:06
channel c1: starting datafile copy
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 1 through 51200
channel c2: starting datafile copy
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 51201 through 102400
channel c3: starting datafile copy
input datafile file number=00001 name=/oracle/dados/RMANDB/datafile/o1_mf_system_h8nynqfx_.dbf
backing up blocks 102401 through 110080
output file name=/oracle/fra/RMANDB/datafile/o1_mf_system_j8t1jl8o_.dbf tag=TAG20210501T044106
channel c3: datafile copy complete, elapsed time: 00:00:15
output file name=/oracle/fra/RMANDB/datafile/o1_mf_system_j8t1jl8o_.dbf tag=TAG20210501T044106
channel c1: datafile copy complete, elapsed time: 00:00:26
output file name=/oracle/fra/RMANDB/datafile/o1_mf_system_j8t1jl8o_.dbf tag=TAG20210501T044106
channel c2: datafile copy complete, elapsed time: 00:00:26
Finished backup at 2021-05-01:04:41:32
Starting Control File and SPFILE Autobackup at 2021-05-01:04:41:32
piece handle=/oracle/fra/RMANDB/autobackup/2021_05_01/o1_mf_s_1071376892_j8t1kf5h_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2021-05-01:04:41:33
released channel: c1
released channel: c2
released channel: c3
RMAN> LIST BACKUP OF TABLESPACE SYSTEM;
specification does not match any backup in the repository
RMAN> LIST COPY OF TABLESPACE SYSTEM;
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time Sparse
------- ---- - ------------------- ---------- ------------------- ------
43 1 A 2021-05-01:04:41:06 2609223 2021-05-01:04:41:06 NO
Name: /oracle/fra/RMANDB/datafile/o1_mf_system_j8t1jl8o_.dbf
Tag: TAG20210501T044106
Obs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laboratório pessoal para fins de aprendizado.
Portuguese
English
Spanish