Pasos
1. Conectar a RMAN
2. List backup summary;
Este comando demora un tiempo, y nos muestra un listado de los backups realizados a la base, nos quedamos con la ultima parte, ya que esta ordenado por fecha de backup:
126334 B 1 A SBT_TAPE 29-AUG-11 1 1 NO TAG20110829T190434
126369 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T000623
126428 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T015955
126445 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T020918
126518 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T035936
126549 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T041625
126630 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T055957
126661 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T060943
126740 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T075916
126766 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T080832
126832 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T095958
126856 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T100653
126930 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T115941
127077 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T141457
127358 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T182638
127505 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T201344
127606 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127678 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T221215
127850 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T001222
127984 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T020930
128053 B A A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T040004
128080 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T041450
128151 B A A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T055927
128177 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T060732
128251 B A A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T080004
128278 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T080930
128343 B A A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T095930
128366 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T100515
El primer cuadro, indica lo realizado el día 30/08, pero como se puede ver en la tercer columna, son backups F (Full de controlfile) y A (de archives). Seguimos con el Segundo cuadro.
El Segundo cuadro, indica lo realizado el día 30/08 y 31/08, y en la tercer columna podemos apreciar un 0 (level 0), A (de archives) y F (full de controlfile). Prestamos atención a los “0”.
También podemos observar la etiqueta de los backupsets resaltados, en todos los casos es la misma, y vemos que continuo el día 31/08.
3. List backup tag
Ahora nos interesa ver el detalle del tag TAG20110830T121816, para ello escribimos el siguiente commando:
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127028 Incr 0 48.64G SBT_TAPE 01:18:49 30-AUG-11
BP Key: 127031 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: tlml9o08_1_1 Media:
List of Datafiles in backup set 127028
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
4 0 Incr 7981067127414 30-AUG-11 /ARCMA/data1/cma_01_ARCMA.dbf
5 0 Incr 7981067127414 30-AUG-11 /ARCMA/data1/chargemanager_01_ARCMA.dbf
20 0 Incr 7981067127414 30-AUG-11 /ARCMA/data1/cma_06_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127150 Incr 0 45.02G SBT_TAPE 01:17:46 30-AUG-11
BP Key: 127153 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: tmml9sk8_1_1 Media:
List of Datafiles in backup set 127150
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
7 0 Incr 7981096466854 30-AUG-11 /ARCMA/data1/cma_index_01_ARCMA.dbf
11 0 Incr 7981096466854 30-AUG-11 /ARCMA/data1/chargemanager_04_ARCMA.dbf
13 0 Incr 7981096466854 30-AUG-11 /ARCMA/data1/cma_04_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127211 Incr 0 45.27G SBT_TAPE 01:19:23 30-AUG-11
BP Key: 127232 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: tpmla163_1_1 Media:
List of Datafiles in backup set 127211
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
16 0 Incr 7981125244130 30-AUG-11 /ARCMA/data1/chargemanager_07_ARCMA.dbf
18 0 Incr 7981125244130 30-AUG-11 /ARCMA/data1/cma_05_ARCMA.dbf
27 0 Incr 7981125244130 30-AUG-11 /ARCMA/data2/chargemanager_13_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127297 Incr 0 46.75G SBT_TAPE 01:20:06 30-AUG-11
BP Key: 127300 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: trmla5r1_1_1 Media:
List of Datafiles in backup set 127297
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
2 0 Incr 7981151072602 30-AUG-11 /ARCMA/data1/undo_tbs_01_ARCMA.dbf
21 0 Incr 7981151072602 30-AUG-11 /ARCMA/data1/cma_07_ARCMA.dbf
23 0 Incr 7981151072602 30-AUG-11 /ARCMA/data1/chargemanager_09_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127442 Incr 0 44.79G SBT_TAPE 02:01:05 30-AUG-11
BP Key: 127445 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: ttmlaahh_1_1 Media:
List of Datafiles in backup set 127442
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
8 0 Incr 7981178583904 30-AUG-11 /ARCMA/data1/undo_tbs_02_ARCMA.dbf
12 0 Incr 7981178583904 30-AUG-11 /ARCMA/data1/cma_03_ARCMA.dbf
24 0 Incr 7981178583904 30-AUG-11 /ARCMA/data1/chargemanager_10_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127605 Incr 0 39.17G SBT_TAPE 01:10:15 30-AUG-11
BP Key: 127609 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: u0mlahkj_1_1 Media:
List of Datafiles in backup set 127605
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
1 0 Incr 7981222170715 30-AUG-11 /ARCMA/data1/system_01_ARCMA.dbf
6 0 Incr 7981222170715 30-AUG-11 /ARCMA/data1/cma_02_ARCMA.dbf
15 0 Incr 7981222170715 30-AUG-11 /ARCMA/data1/chargemanager_06_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127606 Incr 0 39.46G SBT_TAPE 01:10:12 30-AUG-11
BP Key: 127610 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: u3mlalob_1_1 Media:
List of Datafiles in backup set 127606
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
3 0 Incr 7981244378229 30-AUG-11 /ARCMA/data1/sysaux_01_ARCMA.dbf
9 0 Incr 7981244378229 30-AUG-11 /ARCMA/data1/chargemanager_02_ARCMA.dbf
25 0 Incr 7981244378229 30-AUG-11 /ARCMA/data2/chargemanager_11_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127779 Incr 0 40.33G SBT_TAPE 01:11:27 30-AUG-11
BP Key: 127782 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: u4mlaps3_1_1 Media:
List of Datafiles in backup set 127779
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
10 0 Incr 7981264665936 30-AUG-11 /ARCMA/data1/chargemanager_03_ARCMA.dbf
17 0 Incr 7981264665936 30-AUG-11 /ARCMA/data1/cma_index_02_ARCMA.dbf
26 0 Incr 7981264665936 30-AUG-11 /ARCMA/data2/chargemanager_12_ARCMA.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
——- —- — ———- ———– ———— —————
127951 Incr 0 40.91G SBT_TAPE 01:08:53 31-AUG-11
BP Key: 127954 Status: AVAILABLE Compressed: NO Tag: TAG20110830T121816
Handle: u7mlau2b_1_1 Media:
List of Datafiles in backup set 127951
File LV Type Ckp SCN Ckp Time Name
—- — —- ———- ——— —-
14 0 Incr 7981285884341 30-AUG-11 /ARCMA/data1/chargemanager_05_ARCMA.dbf
19 0 Incr 7981285884341 30-AUG-11 /ARCMA/data1/cma_index_03_ARCMA.dbf
22 0 Incr 7981285884341 30-AUG-11 /ARCMA/data1/chargemanager_08_ARCMA.dbf
Si contamos los datafiles de cada backupset, suman 27.
4. Report schema
Para comprobar si todos fueron backapeados, emitimos por último, el comando
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 3072 SYSTEM YES /ARCMA/data1/system_01_ARCMA.dbf
2 12288 UNDOARCMA YES /ARCMA/data1/undo_tbs_01_ARCMA.dbf
3 3072 SYSAUX NO /ARCMA/data1/sysaux_01_ARCMA.dbf
4 24000 CMA NO /ARCMA/data1/cma_01_ARCMA.dbf
5 16000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_01_ARCMA.dbf
6 24000 CMA NO /ARCMA/data1/cma_02_ARCMA.dbf
7 15000 CMA_INDEX NO /ARCMA/data1/cma_index_01_ARCMA.dbf
8 12288 UNDOARCMA YES /ARCMA/data1/undo_tbs_02_ARCMA.dbf
9 24000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_02_ARCMA.dbf
10 24000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_03_ARCMA.dbf
11 24000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_04_ARCMA.dbf
12 10000 CMA NO /ARCMA/data1/cma_03_ARCMA.dbf
13 10000 CMA NO /ARCMA/data1/cma_04_ARCMA.dbf
14 18000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_05_ARCMA.dbf
15 16000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_06_ARCMA.dbf
16 24000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_07_ARCMA.dbf
17 3000 CMA_INDEX NO /ARCMA/data1/cma_index_02_ARCMA.dbf
18 10000 CMA NO /ARCMA/data1/cma_05_ARCMA.dbf
19 3000 CMA_INDEX NO /ARCMA/data1/cma_index_03_ARCMA.dbf
20 10000 CMA NO /ARCMA/data1/cma_06_ARCMA.dbf
21 12000 CMA NO /ARCMA/data1/cma_07_ARCMA.dbf
22 22000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_08_ARCMA.dbf
23 24000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_09_ARCMA.dbf
24 24000 CHARGEMANAGER NO /ARCMA/data1/chargemanager_10_ARCMA.dbf
25 16000 CHARGEMANAGER NO /ARCMA/data2/chargemanager_11_ARCMA.dbf
26 16000 CHARGEMANAGER NO /ARCMA/data2/chargemanager_12_ARCMA.dbf
27 15000 CHARGEMANAGER NO /ARCMA/data2/chargemanager_13_ARCMA.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 10240 TEMP 10240 /ARCMA/data1/temp_01_ARCMA.dbf
Y comprobamos que el número de datafiles que componen la base de datos, es 27, más un archivo temporal, que no forma parte del backup.
Conclusión:
El backup realizado INCREMENTAL LEVEL 0 se realizó correctamente.
Pasos para verificar un backup realizado con RMAN por Gisela Velazco se encuentra bajo una Licencia Creative Commons Atribución-NoComercial-SinDerivadas 3.0 Unported.
Buen manual para revisar el estado de los respaldos con RMAN, soy nuevo en esta herramienta y este manual me ayudo bastante ¡gracias por el documento!