{"id":32505,"date":"2020-12-15T19:13:45","date_gmt":"2020-12-15T19:13:45","guid":{"rendered":"https:\/\/ittutorial.org\/?p=32505"},"modified":"2020-12-15T19:13:45","modified_gmt":"2020-12-15T19:13:45","slug":"rman-06571-datafile-1-does-not-have-recoverable-copy","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/rman-06571-datafile-1-does-not-have-recoverable-copy\/","title":{"rendered":"RMAN-06571: datafile 1 does not have recoverable copy"},"content":{"rendered":"

I got ” RMAN-06571: datafile 1 does not have recoverable copy\u00a0<\/strong>” error in Oracle database during restore database.<\/p>\n

<\/p>\n

 <\/p>\n

RMAN-06571: datafile 1 does not have recoverable copy<\/span><\/h2>\n

 <\/p>\n

Details of error are as follows.<\/p>\n

 <\/p>\n

RMAN> switch database to copy;<\/strong><\/pre>\n
\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of switch to copy command at 12\/10\/2020 14:23:30\r\nRMAN-06571: datafile 1 does not have recoverable copy\r\n\r\nRMAN><\/pre>\n\n
 <\/p>\n
 <\/p>\n
List Incarnation & Reset Incarnation<\/span><\/h3>\n
The RMAN-06571\u00a0<\/strong><\/span>error is related with the Incarnation of database.<\/p>\n
RMAN> list incarnation;\r\n\r\nusing target database control file instead of recovery catalog\r\n\r\nList of Database Incarnations\r\nDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time\r\n------- ------- -------- ---------------- --- ---------- ----------\r\n1 1 MSDB 2054866743 PARENT 1 31-MAY-18\r\n2 2 MSDB 2054866743 CURRENT 16874766827308 26-NOV-20<\/pre>\n
 <\/p>\n
To solve this error, Reset database to right incarnation as follows.<\/p>\n
RMAN> reset database to incarnation 1;\r\n\r\ndatabase reset to incarnation 1\r\n\r\nRMAN> list incarnation;\r\n\r\n\r\nList of Database Incarnations\r\nDB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time\r\n------- ------- -------- ---------------- --- ---------- ----------\r\n1 1 MSDB 2054866743 CURRENT 1 31-MAY-18\r\n2 2 MSDB 2054866743 ORPHAN 16874766827308 26-NOV-20\r\n\r\nRMAN><\/pre>\n
 <\/p>\n
The other scenario is as follows.<\/p>\n
RMAN> RECOVER DATABASE NOREDO;\r\n\r\nStarting recover at 18 JUL 2011 18:12:10\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: sid=267 devtype=DISK\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-03002: failure of recover command at 07\/18\/2011 18:12:11\r\nRMAN-06094: datafile 1 must be restored<\/pre>\n
 <\/p>\n
Often the datafiles do actually reside on disk in either a different directory or filename. So you just need to tell RMAN where they are.<\/p>\n
1) If the datafiles are all in the same directory path, you can catalog them all with one command:<\/p>\n
\r\nRMAN> catalog start with 'full pathname';<\/pre>\n
<\/p>\n
<\/span>Otherwise, to catalog an individual datafile:<\/p>\n
\r\nRMAN> catalog datafilecopy 'full path filename';<\/pre>\n
2) Confirm that RMAN knows about the newly cataloged datafile copies:<\/p>\n
RMAN> list copy of database;\r\n\r\nRMAN> list copy of datafile n;\r\neg.\r\nRMAN> list copy of datafile 1;\r\n\r\nOR to list multiple copies:\r\nRMAN> list copy of datafile 1,2,3,4;<\/pre>\n
<\/span><\/span><\/span><\/p>\n
3) Rename the datafiles to the correct copy on disk<\/p>\n
a) If all datafiles needs to be renamed:<\/p>\n
\r\nRMAN> switch database to copy;<\/pre>\n
<\/p>\n
<\/span>b) If only renaming a single datafile:<\/p>\n
\r\nRMAN> switch datafile n to copy;\r\neg.\r\nRMAN> switch datafile 1 to copy;<\/pre>\n

\n<\/span><\/span>c) If renaming a list of files:<\/span><\/p>\n
\r\nRMAN> switch datafile n,o,p,q to copy;\r\neg.\r\nRMAN> switch datafile 1,2,3,4 to copy;<\/pre>\n
 <\/p>\n
\u00a0\u00a0<\/span>d) to rename to a specific copy:<\/span><\/p>\n
RMAN> run {\r\nswitch datafile 'old datafile path and name' to datafilecopy 'new datafile path and name';\r\n}<\/span><\/pre>\n
\u00a0\u00a0<\/span>
\n4)\u00a0<\/span>The controlfile should now reflect the real datafiles on disk, with their correct size and names.<\/p>\n
\r\nRMAN> report schema;\r\n\r\n<\/span>File Size(MB) Tablespace \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 RB segs Datafile Name\r\n---- -------- ----------------- ------- ------------------------\r\n<\/span>1 \u00a0\u00a0 500 \u00a0 \u00a0\u00a0\u00a0 SYSTEM \u00a0\u00a0 \u00a0 \u00a0 \u00a0\u00a0 *** \u00a0 \u00a0 <ASM PATH>\/system.423.756840583\r\n<\/span>2 \u00a0\u00a0 200\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 UNDOTBS1\u00a0 \u00a0 \u00a0 \u00a0\u00a0 ***\u00a0 \u00a0 \u00a0<ASM PATH>\/undotbs1.258.667475049\r\n3 \u00a0\u00a0 350\u00a0 \u00a0 \u00a0\u00a0 SYSAUX \u00a0\u00a0 \u00a0 \u00a0 \u00a0\u00a0 ***\u00a0 \u00a0 \u00a0<ASM PATH>\/sysaux.257.756996199\r\n4 \u00a0\u00a0 545\u00a0 \u00a0\u00a0\u00a0\u00a0 USERS\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ***\u00a0 \u00a0 \u00a0<ASM PATH>\/users.259.756996261<\/span><\/span><\/pre>\n
 <\/p>\n
Do you want to learn Oracle Database for Beginners, then Click and read the following articles.<\/span><\/a><\/h5>\n
Oracle Database Tutorials for Beginners ( Junior Oracle DBA )<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
I got ” RMAN-06571: datafile 1 does not have recoverable copy\u00a0” error in Oracle database during restore database.<\/p>\n","protected":false},"author":1,"featured_media":3446,"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,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2111],"tags":[16145,16148,16147,16146,16144],"class_list":["post-32505","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-ora-errors","tag-datafile-1-does-not-have-recoverable-copy","tag-datafile-does-not-have-recoverable-copy","tag-rman-6571","tag-rman-06571","tag-rman-06571-datafile-1-does-not-have-recoverable-copy"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/10\/oracle-rman.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/32505","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=32505"}],"version-history":[{"count":1,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/32505\/revisions"}],"predecessor-version":[{"id":32506,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/32505\/revisions\/32506"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/3446"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=32505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=32505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=32505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}