Labels

Pasos para verificar un backup realizado con RMAN




Pasos

1. Conectar a RMAN

Connect target

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:



126262 B F A SBT_TAPE 29-AUG-11 1 1 NO TAG20110829T221050
126334 B 1 A SBT_TAPE 29-AUG-11 1 1 NO TAG20110829T190434
126345 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110829T235930
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
127028 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127047 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T140011
127077 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T141457
127150 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127178 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T155951
127211 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127212 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T161427
127297 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127324 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T180000
127358 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T182638
127442 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127468 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T200009
127505 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T201344
127605 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127606 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127639 B A A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T215929
127678 B F A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T221215
127779 B 0 A SBT_TAPE 30-AUG-11 1 1 NO TAG20110830T121816
127809 B A A SBT_TAPE 31-AUG-11 1 1 NO TAG20110830T235947
127850 B F A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T001222
127951 B 0 A SBT_TAPE 31-AUG-11 1 1 NO TAG20110830T121816
127964 B A A SBT_TAPE 31-AUG-11 1 1 NO TAG20110831T015957
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:

RMAN> list backup tag='TAG20110830T121816';

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

RMAN> REPORT SCHEMA;

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.


Licencia Creative Commons


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.



1 comentario:

Anónimo dijo...

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!

Publicar un comentario