Doing a repeated rman database time based recovery<\/p>\n
RMAN>
\nrun{
\n…
\nalter database mount;
\n…
\nset until time “to_date(‘27.10.2008 23:30:00′,’DD.MM.YYYY HH24:MI:SS’)”;
\n…
\nrestore database;
\nrecover database delete archivelog;
\nalter database open resetlogs;
\n}<\/p>\n
without rman catalog repository can fail with error:<\/p>\n
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time<\/p>\n
To solve the issue<\/p>\n
RMAN> list incarnation;<\/p>\n
using target database control file instead of recovery catalog<\/p>\n
List of Database Incarnations<\/p>\n
1 1 ORAV10 76765624 PARENT 1 22.11.2007 16:44:40 Be careful: Do not restore controlfile. If you do so, incarnation is set the latest id and you run into same error.<\/p>\n RMAN> list incarnation;<\/p>\n List of Database Incarnations<\/p>\n 1 1 ORAV10 76765624 PARENT 1 22.11.2007 16:44:40 In some cases you get errors during recovery In this case you have to restore an adequate controlfile created in selected recovery time frame and that has the same incarnation as the datafiles (see also oracle support Note:378273.1)<\/p>\n","protected":false},"excerpt":{"rendered":" Doing a repeated rman database time based recovery RMAN> run{ … alter database mount; … set until time “to_date(‘27.10.2008 23:30:00′,’DD.MM.YYYY HH24:MI:SS’)”; … restore database; recover database delete archivelog; alter database open resetlogs; } without rman catalog repository can fail with error: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time To solve the issue […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[260,3,5,31],"tags":[203,202,204,200,43,201],"class_list":["post-219","post","type-post","status-publish","format-standard","hentry","category-backup","category-database","category-oracle","category-tipsntricks","tag-controlfile","tag-list-incarnation","tag-ora-00600","tag-recovery","tag-rman","tag-time-based"],"_links":{"self":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/219","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=219"}],"version-history":[{"count":8,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/219\/revisions"}],"predecessor-version":[{"id":359,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=\/wp\/v2\/posts\/219\/revisions\/359"}],"wp:attachment":[{"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askthegerman.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n2 2 ORAV10 76765624 PARENT 4921103 09.04.2008 11:38:07
\n3 3 ORAV10 76765624 ORPHAN 15854298 27.11.2008 11:43:33
\n4 4 ORAV10 76765624 CURRENT 15854298 27.11.2008 17:38:11<\/font><\/p>\n\n
\nRMAN> shutdown immediate;
\nRMAN> startup mount;
\nRMAN> reset database to incarnation 2;<\/p>\n\n
\nKey Key
\n<\/font><\/div>\n
\n2 2 ORAV10 76765624 PARENT 4921103 09.04.2008 11:38:07
\n5 5 ORAV10 76765624 CURRENT 15783824 10.12.2008 16:03:56
\n4 4 ORAV10 76765624 ORPHAN 15854298 27.11.2008 17:38:11
\n3 3 ORAV10 76765624 ORPHAN 15854298 27.11.2008 11:43:33
\n<\/font><\/p>\n
\nORA-00283: recovery session canceled due to errors
\nORA-00081: address range [0x60000000000A7D70, 0x60000000000A7D74) is not readable
\nORA-00600: internal error code, arguments: [kcvsor_current_inc_rdfail], [0], [], [], [], [], [], []<\/p>\n