{"id":17382,"date":"2020-10-22T11:30:27","date_gmt":"2020-10-22T11:30:27","guid":{"rendered":"https:\/\/dbtut.com\/?p=17382"},"modified":"2020-10-22T11:30:27","modified_gmt":"2020-10-22T11:30:27","slug":"table-point-in-time-recovery-in-12cpitr","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/","title":{"rendered":"Table Point In Time Recovery in 12c(PITR)"},"content":{"rendered":"<p>This article contains information about table point in time recovery in 12c and later versions and examples.<\/p>\n<p>As database administrators, we used to do a lot of superfluous work when it was necessary to return a deleted table. With Table Point In Time Recovery in 12C, we had the chance to return the table from the backup with a single action. Yes it is an automatic table recovery in oracle 12c.<\/p>\n<p>In today&#8217;s article, we will recognize this feature that can be used in Oracle Database 12C and above versions.<\/p>\n<p>The process works as follows; It opens a new instance for you and registers a database with your table on that instance. After registration, the table is taken out and imported into your existing database. You can do this by going to a certain date or according to the SCN or Sequence number, but there are some things you should pay attention to.<\/p>\n<p>When you use the RECOVER command to recover tables or table partitions contained in an RMAN backup, the following limitations exist.<\/p>\n<ul>\n<li>The database must be in archivemode.<\/li>\n<li>Tables and table partitions belonging to the SYS scheme cannot be recovered.<\/li>\n<li>Tables and table partitions cannot be recovered from SYSTEM and SYSAUX tablespaces.<\/li>\n<li>Tables and table partitions in standyby databases cannot be recovered.<\/li>\n<li>Tables with NOT NULL constraints cannot be recovered with the REMAP option.<\/li>\n<\/ul>\n<h3>Table Point in Time Recovery Example<\/h3>\n<p>Let&#8217;s explain with a small example. Since I am working on the test database, I will take a fresh backup and perform the process. If you have a backup available, you can skip this step.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@node1 ~]$ rman target \/\r\nRMAN&gt; backup database plus archivelog;\r\n\r\nStarting backup at 16-SEP-20\r\ncurrent log archived\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=406 instance=BUGRADB1 device type=DISK\r\nchannel ORA_DISK_1: starting archived log backup set\r\nchannel ORA_DISK_1: specifying archived log(s) in backup set\r\ninput archived log thread=1 sequence=19 RECID=1 STAMP=1051267492\r\nchannel ORA_DISK_1: starting piece 1 at 16-SEP-20\r\nchannel ORA_DISK_1: finished piece 1 at 16-SEP-20\r\npiece handle=+FRA\/BUGRADB\/BACKUPSET\/2020_09_16\/annnf0_tag20200916t104453_0.261.1051267493 tag=TAG20200916T104453 comment=NONE\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 16-SEP-20\r\n.\r\n.\r\n.\r\n.\r\n.\r\n.\r\nStarting Control File and SPFILE Autobackup at 16-SEP-20\r\npiece handle=+FRA\/BUGRADB\/AUTOBACKUP\/2020_09_16\/s_1051267503.265.1051267505 comment=NONE\r\nFinished Control File and SPFILE Autobackup at 16-SEP-20\r\nRMAN&gt;\r\n\r\nRecovery Manager complete.<\/pre>\n<p>Now let&#8217;s prepare a suitable environment for recovery. For the example, I will recover according to the date. I will check my database time and delete a sample table.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@node1 ~]$ !sql\r\nsqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Wed Sep 16 10:45:58 2020\r\nVersion 19.3.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.3.0.0.0\r\n\r\nSQL&gt; alter session set nls_date_format = 'dd\/mm\/yyyy hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\n\r\nSQL&gt; select sysdate from dual;\r\n\r\nSYSDATE\r\n-------------------\r\n16\/09\/2020 10:59:12<\/pre>\n<p>My database time is &#8220;16\/09\/2020 10:59:12&#8221;. I want to return to this hour. There is a directory named &#8220;\/ u01 \/ tempdata \/ bgrdb&#8221; on file system. The database will temporarily use this location.<\/p>\n<p>First of all, I delete my table according to the scenario.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; drop table bugra.personel;\r\n\r\nTable dropped.\r\n\r\nSQL&gt; commit;\r\n\r\nCommit complete.<\/pre>\n<h3>How To Recover Dropped Table in Oracle 12c<\/h3>\n<p>Now we deleted our test table. Lets start to recover dropped table in oracle 12c with <strong>date<\/strong>.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; recover table \"BUGRA\".\"PERSONEL\" until time \"to_date('16\/09\/2020 10:59:12','dd\/mm\/yyyy hh24:mi:ss')\" AUXILIARY DESTINATION '\/u01\/tempdata\/bgrdb';<\/pre>\n<p>If you want to do it with <strong>SCN<\/strong>;<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; recover table \"BUGRA\".\"PERSONEL\" UNTIL SCN 238107 AUXILIARY DESTINATION '\/u01\/tempdata\/bgrdb';<\/pre>\n<p>Recovery begins.<\/p>\n<pre class=\"lang:default decode:true \">Starting recover at 16-SEP-20\r\ncurrent log archived\r\nusing channel ORA_DISK_1\r\nRMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time\r\n\r\nList of tablespaces expected to have UNDO segments\r\nTablespace SYSTEM\r\nTablespace UNDOTBS1\r\n\r\nCreating automatic instance, with SID='Aglq'\r\n\r\ninitialization parameters used for automatic instance:\r\ndb_name=BUGRADB\r\ndb_unique_name=Aglq_pitr_BUGRADB\r\ncompatible=19.0.0\r\ndb_block_size=8192\r\ndb_files=200\r\ndiagnostic_dest=\/u01\/app\/oracle\/database\/19.3.0\r\n_system_trig_enabled=FALSE\r\nsga_target=3536M\r\nprocesses=200\r\ndb_create_file_dest=\/u01\/tempdata\/bgrdb\r\nlog_archive_dest_1='location=\/u01\/tempdata\/bgrdb'\r\n#No auxiliary parameter file used\r\n\r\n\r\nstarting up automatic instance BUGRADB\r\n\r\nOracle instance started\r\n\r\nTotal System Global Area    3707763120 bytes\r\n\r\nFixed Size                     8903088 bytes\r\nVariable Size                721420288 bytes\r\nDatabase Buffers            2969567232 bytes\r\nRedo Buffers                   7872512 bytes\r\nAutomatic instance created\r\n\r\ncontents of Memory Script:\r\n{\r\n# set requested point in time\r\nset until  time \"to_date('16\/09\/2020 10:59:12','dd\/mm\/yyyy hh24:mi:ss')\";\r\n# restore the controlfile\r\nrestore clone controlfile;\r\n.\r\n.\r\n.\r\n.\r\n.\r\n.\r\n   IMPDP&gt; . . imported \"BUGRA\".\"PERSONEL\":\"SYS_P317\"               9.890 KB       5 rows\r\n   IMPDP&gt; . . imported \"BUGRA\".\"PERSONEL\":\"SYS_P318\"               9.968 KB       6 rows\r\n   IMPDP&gt; . . imported \"BUGRA\".\"PERSONEL\":\"SYS_P319\"               9.906 KB       5 rows\r\n   IMPDP&gt; . . imported \"BUGRA\".\"PERSONEL\":\"SYS_P320\"               10.03 KB       7 rows\r\n   IMPDP&gt; Processing object type TABLE_EXPORT\/TABLE\/INDEX\/INDEX\r\n   IMPDP&gt; Processing object type TABLE_EXPORT\/TABLE\/CONSTRAINT\/CONSTRAINT\r\n   IMPDP&gt; Processing object type TABLE_EXPORT\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\r\n   IMPDP&gt; Processing object type TABLE_EXPORT\/TABLE\/STATISTICS\/TABLE_STATISTICS\r\n   IMPDP&gt; Processing object type TABLE_EXPORT\/TABLE\/STATISTICS\/MARKER\r\n   IMPDP&gt; Job \"SYS\".\"TSPITR_IMP_Aglq_spDm\" successfully completed at Wed Sep 16 11:04:59 2020 elapsed 0 00:00:49\r\nImport completed\r\n\r\nRemoving automatic instance\r\nAutomatic instance removed\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/BUGRADB\/datafile\/o1_mf_temp_hp3qqmch_.tmp deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/FGVT_PITR_BUGRADB\/onlinelog\/o1_mf_3_hp3qtobf_.log deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/FGVT_PITR_BUGRADB\/onlinelog\/o1_mf_2_hp3qto97_.log deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/FGVT_PITR_BUGRADB\/onlinelog\/o1_mf_1_hp3qto86_.log deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/FGVT_PITR_BUGRADB\/datafile\/o1_mf_users_hp3qtgm4_.dbf deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/BUGRADB\/datafile\/o1_mf_sysaux_hp3qq94b_.dbf deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/BUGRADB\/datafile\/o1_mf_undotbs1_hp3qq948_.dbf deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/BUGRADB\/datafile\/o1_mf_system_hp3qq945_.dbf deleted\r\nauxiliary instance file \/u01\/tempdata\/bgrdb\/BUGRADB\/controlfile\/o1_mf_hp3qq29q_.ctl deleted\r\nauxiliary instance file tspitr_fgvt_61116.dmp deleted\r\nFinished recover at 16-SEP-20<\/pre>\n<p>The whole process is complete. As you can see, Oracle itself handles what we used to do manually. And with IMPDP, which we don&#8217;t like :))<\/p>\n<p>As an example, the instance added while processing;<\/p>\n<p id=\"MGYTBPU\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-17383  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/img_5f916a4456558.png\" alt=\"\" width=\"681\" height=\"235\" \/><\/p>\n<p>Our table has been successfully recovered with the two examples we have given. If you want, you can export for this table instead of performing recovery.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; recover table \"BUGRA\".\"PERSONEL\" UNTIL SCN 238107 AUXILIARY DESTINATION '\/u01\/tempdata\/bgrdb' DATAPUMP DESTINATION '\/tempdata\/export'   DUMP FILE 'personel_yedek.dmp'   NOTABLEIMPORT;<\/pre>\n<p>Or you can recover the table with a different name.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; recover table \"BUGRA\".\"PERSONEL\" until time \"to_date('16\/09\/2020 10:59:12','dd\/mm\/yyyy hh24:mi:ss')\" AUXILIARY DESTINATION '\/u01\/tempdata\/bgrdb' REMAP TABLE 'BUGRA'.'PERSONEL':'PERSONEL_BCK';<\/pre>\n<p>We have come to the end of this article where we discuss the issue of recovering a table in Oracle Database with the help of RMAN.<\/p>\n<p>Hope to see you again,<\/p>\n<p>Source :<\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/database\/121\/BRADV\/rcmresind.htm#BRADV859\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.oracle.com\/database\/121\/BRADV\/rcmresind.htm#BRADV859<\/a><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_17382\" class=\"pvc_stats all  \" data-element-id=\"17382\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article contains information about table point in time recovery in 12c and later versions and examples. As database administrators, we used to do a lot of superfluous work when it was necessary to return a deleted table. With Table Point In Time Recovery in 12C, we had the chance to return the table from &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_17382\" class=\"pvc_stats all  \" data-element-id=\"17382\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":574,"featured_media":17384,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[10226,10224,10222,10223,10225],"class_list":["post-17382","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-automatic-table-recovery-in-oracle-12c","tag-how-to-recover-deleted-table-data-in-oracle-12c","tag-how-to-recover-dropped-table-in-oracle-12c","tag-recover-dropped-table-oracle-12c","tag-table-point-in-time-recovery"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Table Point In Time Recovery in 12c(PITR) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This article contains information about table point in time recovery in 12c and later versions and examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Table Point In Time Recovery in 12c(PITR) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This article contains information about table point in time recovery in 12c and later versions and examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-22T11:30:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"907\" \/>\n\t<meta property=\"og:image:height\" content=\"465\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"Table Point In Time Recovery in 12c(PITR)\",\"datePublished\":\"2020-10-22T11:30:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\"},\"wordCount\":489,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg\",\"keywords\":[\"automatic table recovery in oracle 12c\",\"how to recover deleted table data in oracle 12c\",\"how to recover dropped table in oracle 12c\",\"recover dropped table oracle 12c\",\"Table Point In Time Recovery\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\",\"name\":\"Table Point In Time Recovery in 12c(PITR) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg\",\"datePublished\":\"2020-10-22T11:30:27+00:00\",\"description\":\"This article contains information about table point in time recovery in 12c and later versions and examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg\",\"width\":907,\"height\":465},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Table Point In Time Recovery in 12c(PITR)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Table Point In Time Recovery in 12c(PITR) - Database Tutorials","description":"This article contains information about table point in time recovery in 12c and later versions and examples.","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:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/","og_locale":"en_US","og_type":"article","og_title":"Table Point In Time Recovery in 12c(PITR) - Database Tutorials","og_description":"This article contains information about table point in time recovery in 12c and later versions and examples.","og_url":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/","og_site_name":"Database Tutorials","article_published_time":"2020-10-22T11:30:27+00:00","og_image":[{"width":907,"height":465,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg","type":"image\/jpeg"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"Table Point In Time Recovery in 12c(PITR)","datePublished":"2020-10-22T11:30:27+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/"},"wordCount":489,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg","keywords":["automatic table recovery in oracle 12c","how to recover deleted table data in oracle 12c","how to recover dropped table in oracle 12c","recover dropped table oracle 12c","Table Point In Time Recovery"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/","url":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/","name":"Table Point In Time Recovery in 12c(PITR) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg","datePublished":"2020-10-22T11:30:27+00:00","description":"This article contains information about table point in time recovery in 12c and later versions and examples.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/10\/pointintimerecovery12c.jpg","width":907,"height":465},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/10\/22\/table-point-in-time-recovery-in-12cpitr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Table Point In Time Recovery in 12c(PITR)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=17382"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/17382\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/17384"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=17382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=17382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=17382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}