{"id":5259,"date":"2023-03-11T09:01:06","date_gmt":"2023-03-11T08:01:06","guid":{"rendered":"http:\/\/rootfan.com\/?p=5259"},"modified":"2023-09-17T11:37:55","modified_gmt":"2023-09-17T09:37:55","slug":"oracle-rman-recovery-database-until-time","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/oracle-rman-recover-database-until-time\/","title":{"rendered":"Oracle RMAN Recover Database Until Time (R\u00e9cup\u00e9rer la base de donn\u00e9es jusqu'\u00e0 l'heure)"},"content":{"rendered":"<p>Dans de nombreux cas, vous devez r\u00e9cup\u00e9rer une base de donn\u00e9es Oracle jusqu'\u00e0 un certain moment dans le pass\u00e9 ou une base de donn\u00e9es Oracle qui n'a pas encore \u00e9t\u00e9 r\u00e9cup\u00e9r\u00e9e. <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/bradv\/rman-performing-flashback-dbpitr.html#GUID-7D3EE2F7-77A2-4264-8875-CC0AEC64ABE0\" rel=\"nofollow noopener\" target=\"_blank\">r\u00e9cup\u00e9ration ponctuelle<\/a> parce qu'il y a eu une erreur ou que quelqu'un s'est tromp\u00e9.<\/p>\n\n\n\n<p>Vous devez d'abord arr\u00eater la base de donn\u00e9es et la d\u00e9marrer en \u00e9tat de montage.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nshutdown immediate\nstartup mount\n<\/pre><\/div>\n\n\n<p>Vous pouvez ensuite ex\u00e9cuter cette commande dans RMAN apr\u00e8s vous \u00eatre connect\u00e9 avec rman target \/ ou avec un catalogue si vous en avez un.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nrun {\nset until time &quot;to_date(&#039;22-07-2019 16:30:00&#039;,&#039;DD-MM-YYYY HH24:MI:SS&#039;)&quot;;\nrestore database;\nrecover database;\nalter database open resetlogs;\n}\n<\/pre><\/div>\n\n\n<p>Ensuite, il est conseill\u00e9 d'effectuer une sauvegarde compl\u00e8te de la base de donn\u00e9es.<\/p>","protected":false},"excerpt":{"rendered":"<p>Dans de nombreux cas, il est n\u00e9cessaire de r\u00e9cup\u00e9rer une base de donn\u00e9es Oracle jusqu'\u00e0 une date ant\u00e9rieure ou \u00e0 un moment donn\u00e9, en raison d'une erreur quelconque ou d'une faute commise par quelqu'un. Tout d'abord, vous devez arr\u00eater la base de donn\u00e9es et la d\u00e9marrer en \u00e9tat de montage. Ensuite, vous pouvez ex\u00e9cuter cette commande dans RMAN... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/oracle-rman-recover-database-until-time\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Oracle RMAN Recover Database Until Time \"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":5270,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"oracle rman recover database until time","rank_math_title":"","rank_math_description":"Learn how to recover an Oracle database until a specific time using RMAN for precise data restoration.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[92],"class_list":["post-5259","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-rman"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-709552-1.jpeg?fit=1880%2C1253&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=5259"}],"version-history":[{"count":6,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5259\/revisions"}],"predecessor-version":[{"id":5266,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/5259\/revisions\/5266"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/5270"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=5259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=5259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=5259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}