{"id":6881,"date":"2019-01-10T11:00:36","date_gmt":"2019-01-10T10:00:36","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=6881"},"modified":"2019-01-07T10:51:53","modified_gmt":"2019-01-07T09:51:53","slug":"oracle-rds-recuperer-les-tracefiles-comment-faire","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/","title":{"rendered":"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ?"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6881&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6881&#038;title=Oracle%20RDS%20%3A%20r%C3%A9cup%C3%A9rer%20les%20tracefiles%2C%20comment%20faire%20%3F\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Oracle%20RDS%20%3A%20r%C3%A9cup%C3%A9rer%20les%20tracefiles%2C%20comment%20faire%20%3F&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6881\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6906\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/aws-database-1.png\" alt=\"\" width=\"171\" height=\"126\" \/><\/figure>\r\n\r\n\r\n\r\n<p>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Comme nous le savons, l&#8217;utilisation de Oracle RDS sur AWS est une solution Platform As A Service (PaaS). Il n&#8217;y a donc aucune possibilit\u00e9 de se connecter directement sur le(s) seveur(s) ou sont h\u00e9berg\u00e9es les bases de donn\u00e9es Oracle, et d&#8217;aller lire ou r\u00e9cup\u00e9rer via scp ces fichiers .<\/p>\r\n\r\n\r\n\r\n<p><br \/>Nos seules informations connues sont les points d&#8217;entr\u00e9e ainsi que le port li\u00e9s \u00e0 une base et qui constituent les informations qui nous permettront de construire notre entr\u00e9e dans TNSNAMES.ORA :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"241\" class=\"wp-image-6882\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-67.png\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Sur le fichier TNSNAMES.ORA, notre entr\u00e9e base capdatadb :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"198\" class=\"wp-image-6883\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-68.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-68.png 878w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-68-300x68.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-68-768x173.png 768w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/>\r\n<figcaption><br \/><br \/><br \/><\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Un client Oracle install\u00e9, avec l&#8217;outil SqlPlus, sera utilis\u00e9 afin d&#8217;interroger les packages relatifs \u00e0 RDS , &#8220;RDSADMIN&#8221;.<\/p>\r\n\r\n\r\n\r\n<p>Comme on le sait, l&#8217;utilisation d&#8217;ordre de type &#8220;ALTER SYSTEM&#8221; est proscrit sur Oracle RDS, nous pourrons en revanche, user des &#8220;ALTER SESSION&#8221; :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6884\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-69.png\" alt=\"\" width=\"426\" height=\"43\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-69.png 545w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-69-300x30.png 300w\" sizes=\"auto, (max-width: 426px) 100vw, 426px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\">Voir les fichiers de trace<\/h4>\r\n\r\n\r\n\r\n<p>Nous aurons la possibilit\u00e9, gr\u00e2ce \u00e0 des commandes SQL, de voir l&#8217;ensemble des fichiers de trace g\u00e9n\u00e9r\u00e9s dans l&#8217;espace &#8220;bdump&#8221; configur\u00e9 en base et d\u00e9di\u00e9 \u00e0 ceux ci.<br \/>On sait qu&#8217;ils sont dans un filesystem \/rdsdbdata, mais qui est propre au serveur d\u00e9fini par Amazon.\u00a0<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6885\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-70.png\" alt=\"\" width=\"538\" height=\"140\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-70.png 668w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-70-300x79.png 300w\" sizes=\"auto, (max-width: 538px) 100vw, 538px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Avant de pouvoir lire ce qu&#8217;il y&#8217;a dans le r\u00e9pertoire, on doit, tout d&#8217;abord, actualiser les informations:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6886\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-71.png\" alt=\"\" width=\"459\" height=\"55\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-71.png 543w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-71-300x36.png 300w\" sizes=\"auto, (max-width: 459px) 100vw, 459px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>A partir de la, on pourra lire son contenu,\u00a0 par exemple s&#8217;il l&#8217;on souhaite lire les fichiers trace du jour\u00a0 :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6887\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-72-1024x335.png\" alt=\"\" width=\"791\" height=\"258\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-72-1024x335.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-72-300x98.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-72-768x251.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-72.png 1057w\" sizes=\"auto, (max-width: 791px) 100vw, 791px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\">G\u00e9n\u00e9rer et r\u00e9cup\u00e9rer des traces\u00a0<\/h4>\r\n\r\n\r\n\r\n<p>Il sera possible d&#8217;interfacer avec le package &#8220;rdsadmin&#8221;, des ordres de trace de type &#8216;oradebug&#8217;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6888\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-73.png\" alt=\"\" width=\"532\" height=\"65\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-73.png 434w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-73-300x37.png 300w\" sizes=\"auto, (max-width: 532px) 100vw, 532px\" \/>\r\n<figcaption>G\u00e9n\u00e9rer un hanganalyze<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6889\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-74.png\" alt=\"\" width=\"528\" height=\"58\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-74.png 455w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-74-300x33.png 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/>\r\n<figcaption>G\u00e9n\u00e9rer un systemstate dump<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Afin de tracer une session pr\u00e9cise, on utilisera les m\u00eames proc\u00e9d\u00e9s que ce qui se fait sur une base on-premise. Par exemple, on pourra utiliser DBMS_MONITOR comme package r\u00e9f\u00e9rence pour tracer une session utilisateur :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6890\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-75.png\" alt=\"\" width=\"750\" height=\"93\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-75.png 942w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-75-300x37.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-75-768x95.png 768w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/>\r\n<figcaption>La session utilisateur \u00e0 tracer est port\u00e9e par le user MANUELO<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Soit\u00a0<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6891\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-76.png\" alt=\"\" width=\"811\" height=\"49\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-76.png 941w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-76-300x18.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-76-768x47.png 768w\" sizes=\"auto, (max-width: 811px) 100vw, 811px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Une fois connect\u00e9 avec le sch\u00e9ma utilisateur concern\u00e9, on g\u00e9n\u00e8re un peu d&#8217;activit\u00e9 :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6892\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-77.png\" alt=\"\" width=\"728\" height=\"58\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-77.png 705w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-77-300x24.png 300w\" sizes=\"auto, (max-width: 728px) 100vw, 728px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"520\" height=\"307\" class=\"wp-image-6893\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-78.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-78.png 520w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-78-300x177.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>On stoppe la trace , connect\u00e9 via un sch\u00e9ma ayant des droit execute sur dbms_monitor.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"70\" class=\"wp-image-6894\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-79.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-79.png 693w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-79-300x30.png 300w\" sizes=\"auto, (max-width: 693px) 100vw, 693px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>On rep\u00e8re le num\u00e9ro du process OS g\u00e9n\u00e9r\u00e9 par cette session utilisateur :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6896\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-81.png\" alt=\"\" width=\"754\" height=\"87\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-81.png 917w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-81-300x35.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-81-768x89.png 768w\" sizes=\"auto, (max-width: 754px) 100vw, 754px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Et on interroge, via RDSADMIN la trace g\u00e9n\u00e9r\u00e9 par le processus 20019 :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6897\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-82-1024x455.png\" alt=\"\" width=\"767\" height=\"340\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-82-1024x455.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-82-300x133.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-82-768x341.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-82.png 1053w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/>\r\n<figcaption>On retrouve notre trace parmi le r\u00e9pertoire<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Puis, pour lire son contenu, on inscrira ce fichier au sein d&#8217;une vue appel\u00e9 &#8220;tracefile_table&#8221;.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6898\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-83.png\" alt=\"\" width=\"671\" height=\"59\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-83.png 769w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-83-300x27.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-83-768x68.png 768w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/>\r\n<figcaption>G\u00e9n\u00e9ration de la vue tracefile_table \u00e0 partir de ce fichier<\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>On interroge la vue tracefile_table tout en ayant pris soin de faire un spool dans un fichier auparavant :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6899\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-84.png\" alt=\"\" width=\"475\" height=\"53\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-84.png 394w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-84-300x34.png 300w\" sizes=\"auto, (max-width: 475px) 100vw, 475px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Notre trace ainsi g\u00e9n\u00e9r\u00e9 sur un disque local.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"416\" class=\"wp-image-6900\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-85.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-85.png 659w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-85-300x189.png 300w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/>\r\n<figcaption><br \/><br \/><br \/><\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>On pourra utiliser TKPROF pour g\u00e9n\u00e9rer et analyser cette trace\u00a0<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"736\" height=\"125\" class=\"wp-image-6901\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-86.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-86.png 736w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-86-300x51.png 300w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"610\" height=\"260\" class=\"wp-image-6902\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-87.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-87.png 610w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-87-300x128.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"849\" height=\"717\" class=\"wp-image-6903\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-88.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-88.png 849w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-88-300x253.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-88-768x649.png 768w\" sizes=\"auto, (max-width: 849px) 100vw, 849px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\">Purge des fichiers trace\u00a0<\/h4>\r\n\r\n\r\n\r\n<p>Afin de purger cette trace, et d&#8217;autres \u00e9galement, c&#8217;est la proc\u00e9dure\u00a0<br \/>&#8220;<strong><em>manage_tracefiles.purge_tracefiles<\/em><\/strong>&#8221; du package rdsadmin qui sera propos\u00e9 :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"56\" class=\"wp-image-6911\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-89.png\" alt=\"\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-89.png 620w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-89-300x27.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/>\r\n\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Par d\u00e9faut, les fichiers trace g\u00e9n\u00e9r\u00e9s par Oracle sous ce r\u00e9pertoire sont conserv\u00e9s 7 jours. Pensez donc \u00e0 conserver vos traces en local si besoin.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6912\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-90.png\" alt=\"\" width=\"853\" height=\"103\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-90.png 988w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-90-300x36.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-90-768x93.png 768w\" sizes=\"auto, (max-width: 853px) 100vw, 853px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Il sera possible, cependant, de changer cette r\u00e9tention via &#8220;<strong><em>rdsadmin_util.set_configuration(&#8216;tracefile retention&#8217;,&lt;number&gt;)<\/em><\/strong>&#8220;<\/p>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<h4 class=\"wp-block-heading\">Utilisation via AWS CLI<\/h4>\r\n\r\n\r\n\r\n<p>Pour la gestion de ses nombreux services, AWS met \u00e0 diposition une API nomm\u00e9 AWS CLI afin de pouvoir effectuer en mode &#8220;scripting&#8221; de nombreuses op\u00e9rations sur les composants (ec2, s3, rds&#8230;.).<\/p>\r\n\r\n\r\n\r\n<p>Dans notre cas pr\u00e9cis, nous pourrons r\u00e9cup\u00e9rer les logs bases de donn\u00e9es Oracle via cette API \u00e0 partir de simples commandes.<\/p>\r\n\r\n\r\n\r\n<p>Par exemple, si nous souhaitons r\u00e9cup\u00e9rer le fichier &#8220;alert.log&#8221; de la base, nous pourrions utiliser le package &#8216;rdsamin&#8217; et la proc\u00e9dure :<\/p>\r\n\r\n\r\n\r\n<p><em><strong>exec rdsadmin.manage_tracefiles.set_tracefile_table_location();<\/strong><\/em><\/p>\r\n\r\n\r\n\r\n<p>Mais avec aws cli, on \u00e9crira directement via une commande cmd. Les options sont\u00a0<strong>describe-db-log-files <\/strong>pour chercher le fichier log selon le crit\u00e8re choisi. Puis\u00a0<strong>download-db-log-file-portion<\/strong>\u00a0pour r\u00e9cup\u00e9rer tout ou une partie de la trace.<\/p>\r\n\r\n\r\n\r\n<p>Ainsi, l&#8217;op\u00e9ration de recherche de l&#8217;alert.log se fera via la m\u00e9thode suivante :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6920\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-91.png\" alt=\"\" width=\"812\" height=\"154\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-91.png 1005w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-91-300x57.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-91-768x146.png 768w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>On notera que le r\u00e9sultat de l&#8217;option <strong>describe-db-log-files<\/strong> apparait sous un format JSON. Les autres param\u00e8tres sont<strong> &#8211;db-instance-identifier<\/strong> pour le nom de la base et <strong>&#8211;filename-contains<\/strong> pour le crit\u00e8re li\u00e9 au nom de la trace \u00e0 rechercher. La r\u00e9gion devra \u00eatre d\u00e9fini si celle ci n&#8217;a pas \u00e9t\u00e9 configur\u00e9e lors de la commande &#8220;<strong>aws configure<\/strong>&#8220;.<\/p>\r\n\r\n\r\n\r\n<p>Nous irons chercher le fichier &#8220;trace\/alert_CAPDATA.log&#8221;.\u00a0 On prendra soit les derni\u00e8res lignes du fichier via la commande :<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6921\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-92-1024x36.png\" alt=\"\" width=\"1122\" height=\"39\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-92-1024x36.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-92-300x10.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-92-768x27.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-92.png 1121w\" sizes=\"auto, (max-width: 1122px) 100vw, 1122px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Soit le fichier int\u00e9gral:<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6922\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-93-1024x38.png\" alt=\"\" width=\"1121\" height=\"41\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-93-1024x38.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-93-300x11.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-93-768x29.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-93.png 1123w\" sizes=\"auto, (max-width: 1121px) 100vw, 1121px\" \/>\r\n<figcaption><br \/><br \/><br \/><\/figcaption>\r\n<\/figure>\r\n\r\n\r\n\r\n<p>Dans le cas du fichier int\u00e9gral, nous avons ajouter l&#8217;option<strong> &#8211;starting-token 0<\/strong> afin de d\u00e9buter \u00e0 la toute premi\u00e8re ligne du fichier. Le param\u00e8tre <strong>&#8211;output <\/strong>permet de choisir le format pour le fichier, ici format texte.<\/p>\r\n\r\n\r\n\r\n<p>Le fichier <strong>&#8220;CAPDATA_alert_log_FULL.trc&#8221;<\/strong> est maintenant pr\u00e9sent sur le disque local, et \u00e9ditable via un traitement de texte classique.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-6923\" src=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-94-1024x286.png\" alt=\"\" width=\"687\" height=\"191\" srcset=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-94-1024x286.png 1024w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-94-300x84.png 300w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-94-768x215.png 768w, https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/image-94.png 1141w\" sizes=\"auto, (max-width: 687px) 100vw, 687px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>&nbsp;<\/p>\r\n\r\n\r\n\r\n<p>Emmanuel RAMI<\/p>\r\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6881&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6881&#038;title=Oracle%20RDS%20%3A%20r%C3%A9cup%C3%A9rer%20les%20tracefiles%2C%20comment%20faire%20%3F\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=Oracle%20RDS%20%3A%20r%C3%A9cup%C3%A9rer%20les%20tracefiles%2C%20comment%20faire%20%3F&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F6881\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>R\u00e9cup\u00e9rer les tracefiles sous Oracle RDS <a href=\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":32,"featured_media":6905,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[295,3],"tags":[303],"class_list":["post-6881","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws","category-oracle","tag-rds"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ? - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ? - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"R\u00e9cup\u00e9rer les tracefiles sous Oracle RDS Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-10T10:00:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-07T09:51:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/aws-database.png\" \/>\n\t<meta property=\"og:image:width\" content=\"259\" \/>\n\t<meta property=\"og:image:height\" content=\"191\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Emmanuel RAMI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emmanuel RAMI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\"},\"author\":{\"name\":\"Emmanuel RAMI\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/797b9b6698fa35f7ce3e9a70a8b102ae\"},\"headline\":\"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ?\",\"datePublished\":\"2019-01-10T10:00:36+00:00\",\"dateModified\":\"2019-01-07T09:51:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\"},\"wordCount\":839,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"RDS\"],\"articleSection\":[\"AWS\",\"Oracle\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\",\"name\":\"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ? - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2019-01-10T10:00:36+00:00\",\"dateModified\":\"2019-01-07T09:51:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/797b9b6698fa35f7ce3e9a70a8b102ae\",\"name\":\"Emmanuel RAMI\",\"sameAs\":[\"https:\/\/blog.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/erami\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ? - Capdata TECH BLOG","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/","og_locale":"fr_FR","og_type":"article","og_title":"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ? - Capdata TECH BLOG","og_description":"R\u00e9cup\u00e9rer les tracefiles sous Oracle RDS Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2019-01-10T10:00:36+00:00","article_modified_time":"2019-01-07T09:51:53+00:00","og_image":[{"width":259,"height":191,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2018\/12\/aws-database.png","type":"image\/png"}],"author":"Emmanuel RAMI","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Emmanuel RAMI","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/"},"author":{"name":"Emmanuel RAMI","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/797b9b6698fa35f7ce3e9a70a8b102ae"},"headline":"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ?","datePublished":"2019-01-10T10:00:36+00:00","dateModified":"2019-01-07T09:51:53+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/"},"wordCount":839,"commentCount":0,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["RDS"],"articleSection":["AWS","Oracle"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/","url":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/","name":"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ? - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2019-01-10T10:00:36+00:00","dateModified":"2019-01-07T09:51:53+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/oracle-rds-recuperer-les-tracefiles-comment-faire\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"Oracle RDS : r\u00e9cup\u00e9rer les tracefiles, comment faire ?"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/797b9b6698fa35f7ce3e9a70a8b102ae","name":"Emmanuel RAMI","sameAs":["https:\/\/blog.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/erami\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/6881","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/32"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=6881"}],"version-history":[{"count":18,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/6881\/revisions"}],"predecessor-version":[{"id":6993,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/6881\/revisions\/6993"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/6905"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=6881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=6881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=6881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}