{"id":1160,"date":"2015-10-29T13:58:46","date_gmt":"2015-10-29T12:58:46","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=1160"},"modified":"2015-10-29T13:58:46","modified_gmt":"2015-10-29T12:58:46","slug":"rman-y-a-t-il-eu-une-hot-backup","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/10\/29\/rman-y-a-t-il-eu-une-hot-backup\/","title":{"rendered":"RMAN : y-a-t-il eu un Hot backup ?"},"content":{"rendered":"<p>se connecter\u00a0<span style=\"color: #ff0000;\"><strong>ora102<\/strong><\/span><br \/>\nse positionner sur la database<\/p>\n<pre>[ora102@pdtb2 KTP ~]$ export ORACLE_SID=HYPPROD\n[ora102@pdtb2 HYPPROD ~]$ <span style=\"color: #ff0000;\">rman target \/<\/span><\/pre>\n<p><span style=\"font-size: 18px;\">pour voir les backups effectu\u00e9s (mais l\u00e0 on ne sait pas si ils sont complets !)<\/span><a href=\"https:\/\/easytracking.faiveleytransport.com\/issues\/136490#pour-voir-les-backups-effectu\u00e9s-mais-l\u00e0-on-ne-sait-pas-si-ils-sont-complets-\">\u00b6<\/a><\/p>\n<pre><span style=\"color: #ff0000;\">RMAN&gt; list backup summary;<\/span>\n\nusing target database control file instead of recovery catalog\n\nList of Backups\n===============\nKey     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag\n------- -- -- - ----------- --------------- ------- ------- ---------- ---\n29975   B  0  A DISK        27-OCT-15       1       1       YES        DATABASE LEVEL 0\n29976   B  A  A DISK        27-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29977   B  F  A DISK        27-OCT-15       1       1       NO         TAG20151027T072645\n29978   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29979   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29980   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29981   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29982   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29983   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29984   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29985   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29991   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29992   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29995   B  0  A DISK        28-OCT-15       1       1       YES        DATABASE LEVEL 0\n29996   B  A  A DISK        28-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29997   B  F  A DISK        28-OCT-15       1       1       NO         TAG20151028T035123\n29998   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n29999   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30000   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30001   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30002   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30003   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30004   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30005   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30006   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30007   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30008   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30009   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30010   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0\n30011   B  A  A DISK        29-OCT-15       1       1       YES        ARCHIVES LEVEL 0<\/pre>\n<h3>list des derniers FULL backup complet (l\u00e0 tu as toutes les infos, size, date, dur\u00e9e, d\u00e9tails des fichiers&#8230;)<\/h3>\n<pre><span style=\"color: #ff0000;\">RMAN&gt; LIST BACKUP OF DATABASE;<\/span>\n\nList of Backup Sets\n===================\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n29975   Incr 0  17.57G     DISK        03:14:27     27-OCT-15\n        BP Key: 29975   Status: AVAILABLE  Compressed: YES  Tag: DATABASE LEVEL 0\n        Piece Name: \/data\/backups\/20151027_HYPPROD_90qknrkl_1_1\n  List of Datafiles in backup set 29975\n  File LV Type Ckp SCN    Ckp Time  Name\n  ---- -- ---- ---------- --------- ----\n  1    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/system01.dbf\n  2    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/undotbs01.dbf\n  3    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/sysaux01.dbf\n  4    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm01.dbf\n  5    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hss01.dbf\n  6    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hbi01.dbf\n  7    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/idx_hss01.dbf\n  8    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/idx_hbi01.dbf\n  9    0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/idx_hfm01.dbf\n  10   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm02.dbf\n  11   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm03.dbf\n  12   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm04.dbf\n  13   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm05.dbf\n  14   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm06.dbf\n  15   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/idx_hfm02.dbf\n  16   0  Incr 644379976  27-OCT-15 \/data\/oracle\/HYPPROD\/idx_hfm03.dbf\n\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\n------- ---- -- ---------- ----------- ------------ ---------------\n29995   Incr 0  17.58G     DISK        03:26:55     28-OCT-15\n        BP Key: 29995   Status: AVAILABLE  Compressed: YES  Tag: DATABASE LEVEL 0\n        Piece Name: \/data\/backups\/20151028_HYPPROD_9kqkq2ll_1_1\n  List of Datafiles in backup set 29995\n  File LV Type Ckp SCN    Ckp Time  Name\n  ---- -- ---- ---------- --------- ----\n  1    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/system01.dbf\n  2    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/undotbs01.dbf\n  3    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/sysaux01.dbf\n  4    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm01.dbf\n  5    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hss01.dbf\n  6    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hbi01.dbf\n  7    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/idx_hss01.dbf\n  8    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/idx_hbi01.dbf\n  9    0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/idx_hfm01.dbf\n  10   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm02.dbf\n  11   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm03.dbf\n  12   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm04.dbf\n  13   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm05.dbf\n  14   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/data_hfm06.dbf\n  15   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/idx_hfm02.dbf\n  16   0  Incr 644705605  28-OCT-15 \/data\/oracle\/HYPPROD\/idx_hfm03.dbf<\/pre>\n<h3><strong>conclusion factuelle<\/strong><\/h3>\n<p>Pas de backup complet en date du 29\/10<\/p>\n","protected":false},"excerpt":{"rendered":"<p>se connecter\u00a0ora102 se positionner sur la database [ora102@pdtb2 KTP ~]$ export ORACLE_SID=HYPPROD [ora102@pdtb2 HYPPROD ~]$ rman target \/ pour voir les backups effectu\u00e9s (mais l\u00e0 on ne sait pas si ils sont complets !)\u00b6 RMAN&gt; list backup summary; using target database control file instead of recovery catalog List of Backups =============== Key TY LV S &hellip; <a href=\"http:\/\/les-fougs.com\/wordpress\/2015\/10\/29\/rman-y-a-t-il-eu-une-hot-backup\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de &laquo;&nbsp;RMAN : y-a-t-il eu un Hot backup ?&nbsp;&raquo;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1160"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1160"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1160\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1160"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}