"alter database mount clone database" is a statement that forces all datafiles to be put OFFLINE when mounting the target instance.
You'll see it's being used in the background when you run RMAN commands like:

"transport tablespace"
"recover tablespace .. auxiliary destination .."
"recover table"  (12c feature)

In my case, i was trying to recover an 11.2.0.4 dropped table using "Tablespace Point In Time Recovery" by following the MOS note "How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN (Doc ID 223543.1)". The basic steps are:

- create pfile
- restore controlfile
- mount with "alter database mount clone database;"
- restore and recover a subset of the database with an RMAN script similar to:

RMAN> connect target /
        run {
        allocate channel c1 device type DISK;
        set until time "to_date( '13-01-2016 13:50', 'DD-MM-YYYY HH24:MI')";
        set newname for datafile 1 to "+RECO";
        set newname for datafile 3 to "+RECO";
        set newname for datafile 4 to "+RECO";
        set newname for datafile 23 to "+RECO";
        restore tablespace SYSTEM, UNDOTBS01, UNDOTBS02, TOOLS;
        switch datafile all;
        sql "alter database datafile 1,3,4,23 online";
        recover database skip forever tablespace TEMP,INDX,USERS,etc.;
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_1.281.739547347'' to ''+RECO''";
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_2.282.739547353'' to ''+RECO''";
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_3.283.739547359'' to ''+RECO''";
        sql "alter database rename file ''+RECO/xxx/onlinelog/group_4.284.739547365'' to ''+RECO''";
release channel c1;
}

After completing the required steps, recovery raised the following error:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup

Of course i got the error when tried to open with resetlogs. After struggling with possible causes, i found an internal support note similar with my issue: "ORA-1547 After Recovery When Database Was Mounted As Clone (Doc ID 252181.1)". The interesting part was this note was published at Oct 23, 2003 for versions 8.1.7.4 to 9.2.0.4 and the fix was:

Use the following workaround until the bug gets resolved :
Do not mount the database as CLONE as in :
SQL> alter database mount clone database;
but mount is as normal database with :
SQL> alter database mount;

But there's no bug number stated in the note. Even i thought that mysterious bug must have been fixed many years ago, desperation made me try the workaround with mounting the instance with "alter database mount" and manually taking the required datafiles offline. Suprisingly it worked and i was able to open the database with resetlogs.

As a result, it's fine for me that RMAN uses "mount clone database" statement internally, however when i'll do TSPITR again you can be sure that i'll mount the instance with the way i used to :)

88 Responses so far.

  1. TGA says:

    Hello,
    I thought you should use auxiliary and not target if you want to use clone database .
    Regards
    Thierry

  2. Hi,
    Yes it make sense, because mount clone is being used by RMAN in aux. databases. However i think it's not mandatory because the method in the note 223543.1 worked for me previously in another cases which i used "connect target". But yes i may have tried using auxiliary as a workaround.
    Thanks

  3. This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds and need to be patiently wait till it blossoms.

    Online Training in Chennai


  4. Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!

    Online Training in Chennai

  5. keerthi says:

    I read a weblog, I hope that it doesnt sadden me as much as this one. I’m talking about, I know it was my selection to read, but I actually thought youd have something interesting to say. Great work admin..

    Corporate Training in Chennai

  6. Sathya G says:

    thanks for shared wonderful information of giving best information.its more useful and more helpful. great doing keep sharing
    Digital Marketing Company in Chennai

  7. sindhu says:

    I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.

    SMO Services Chennai

  8. aashi says:


    I’ve been browsing on-line greater than three hours today, but I never discovered any attention-grabbing article like yours. It is beautiful worth sufficient for me. Personally, if all webmasters and bloggers made good content material as you did, the net will be a lot more helpful than ever before.


    DotNet Training in Chennai


  9. I read a weblog, I hope that it doesnt sadden me as much as this one. I’m talking about, I know it was my selection to read, but I actually thought youd have something interesting to say. Great work admin..

    Online Training in Chennai

  10. Anonymous says:

    This blog provides useful information about new techniques and concepts.very impressive lines are given which is very attractive.
    sharepoint-training-in-chennai

  11. aashi says:

    Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!

    Corporate Training in Chennai

  12. arul says:

    I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.


    SEO Training in Chennai

  13. Geetha says:

    Great information shared in this blog. Helps in gaining concepts about new information and concepts.Awsome information provided.Very useful for the beginners.
    dot net Training in Chennai

  14. This blog explains the details about what happened after the expressions. This
    gives the details of the thinking next what to do. All that are discussed and
    provide a grateful talk.
    Web Designing Training in Chennai

  15. Great... Excellent sharing.. This is very helpful for beginers. Read that provide me more enthusiastic. This helps me get a more knowledge about this topic. Thanks for this.
    Digital Marketing Company in Chennai

  16. This blog is having the general information. Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog. This is very interesting and useful.

    Salesforce Training in Chennai

  17. deeksha says:

    your blog is very well done and it is interesting too , thanks for intimating these kind of information.

    Best Informatica Training Institute in Chennai

  18. You made some decent factors there. I looked on the internet for the difficulty and found most individuals will associate with along with your website.
    Dental Hospital In Chennai

  19. I like it your blog. I have read your blog its very attractive and impressive.
    corporate training in chennai corporate training companies in chennai corporate training companies in india corporate training companies in india corporate training in chennai corporate training companies in chennai corporate training in chennai | Angular 2 Corporate Training Angular 2 Corporate Training

  20. I have own car so now I am back out there trying to show him how to do car repairs. Your blog is an excellent source of info, thanks.

    home spa services in mumbai

  21. Shalini says:

    Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India

  22. Jeffy says:

    Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..!!
    seo company in india
    Digital Marketing Company in india

  23. I read a weblog, I hope that it doesn't sadden me as much as this one. I’m talking about, I know it was my selection to read, but I actually thought you'd have something interesting to say. Great work admin..
    Back to original

  24. kami says:

    Awesome content thank you for sharing

    from

    oracle training in ameerpet

  25. Sathya G says:

    This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.
    VMwareTraining in Chennai

  26. Shalini says:

    Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India

  27. Anonymous says:

    I read you blog, your general information is really creative and innovative too. thus i need to know more things, it is really very well helpful too.

    Web Design Company in Chennai

  28. This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds and need to be patiently wait till it blossoms.
    PTE Training in Chennai
    PTE Coaching in Chennai

  29. This blog is having the general information. Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog. This is very interesting and useful.

    Software Testing Training Institute in Chennai

  30. your information is really awesome as well as it is very excellent and i got more interesting information from your blog.

    Android Training in Chennai

  31. Nandhini says:

    That was a great message in my carrier, and It's wonderful commands like mind relaxes with understand words of knowledge by information's.
    Facility Management Companies in Chennai

  32. Helpful as always. Every post you write produce a massive value to your readers that is the only reason it is so popular and has great authority.

    Painless Dental Treatment In Chennai

    Best Dental Clinic In Adyar

  33. sathya says:

    There are lots of information about latest technology and how to get trained in them, like this have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies. By the way you are running a great blog. Thanks for sharing this.

    Hadoop Training in Chennai

    Base SAS Training in Chennai

  34. Thanks for sharing this informative content which provided me the required information about the latest oracle financials online coaching,we provide low price of fee for on-line coaching.
    further information visit our site.

  35. I simply couldn’t depart your site before suggesting that I really enjoyed the usual information an individual supply in your visitors? Is going to be again steadily to check out new posts.
    Office Interiors in Chennai
    Interior Decorators in Chennai

  36. I have read your blog its very attractive and impressive. I like it your blog.


    SEO Services in India SEO Company in India SEO Company in India SEO Services in India

    SEO Company in India SEO Services in India

  37. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us
    Java Training in Chennai

  38. What you have written in this post is exactly what I have experience when I first started my blog.I’m happy that I came across with your site this article is on point,thanks again and have a great day.Keep update more information.
    Home Interiors in Chennai

  39. sindhu says:

    Really, these quotes are the holistic approach towards mindfulness. In fact, all of your posts are. Proudly saying I’m getting fruitfulness out of it what you write and share. Thank you so much to both of you.
    Digital Marketing Company in Chennai


  40. You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...

    Android App Development Company

  41. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

  42. This article is very much helpful and i hope this will be an useful information for the needed one.Keep on updating these kinds of informative things...

    iOS App Development Company
    iOS App Development Company

  43. This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...
    Fitness SMS
    Fitness Text
    Salon SMS
    Salon Text
    Investor Relation SMS
    Investor Relation Text

  44. it is really amazing...thanks for sharing....provide more useful information...
    Mobile app development company

  45. Thanks emerebaransel for sharing this article, really helpful
    Web Design Company in Hyderabad
    SEO Company in Hyderabad

  46. Ahkansha says:

    This blog is very informative and it is very exclusive it is really nice and thanks for sharing those information.This helps me get a more knowledge about this topic.
    seo training in chennai

  47. Ahkansha says:

    This blog is very informative and it is very exclusive it is really nice and thanks for sharing those information.This helps me get a more knowledge about this topic.
    seo training in chennai

  48. Shalini says:


    Really Good blog post.provided a helpful information.I hope that you will post more updates like this.
    Digital marketing company in Chennai

  49. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    web design Company
    web development Company
    web design Company in chennai
    web development Company in chennai
    web design Company in India
    web development Company in India

  50. sandhosh says:

    Thank you for this great article which conveyed a good information.keep more updates.
    SEO Company in India
    SEO Services in India
    SEO Companies in India
    SEO Company India
    SEO Services India

  51. oracle34 says:

    thanks for the shared wonderful information about giving the best information.it's more useful and more helpful. great doing keep sharing

    Oracle Fusion Financials Online Training

  52. This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...
    Texting API
    Text message marketing
    Digital Mobile Marketing
    Sms API
    Sms marketing

  53. Wow, this blog is very nice I really like your blog and Impressive thank you very much for posting this blog.....................Get More Information about Oracle Fusion Financials Training click here.

  54. I simply want to tell you that I’m all new to blogs and truly liked you’re blog site. Very likely I’m likely to bookmark your site .You surely come with remarkable articles. Cheers for sharing your website page.
    Logistic ERP
    Transport ERP
    Manufacturing ERP
    ERP software companies
    Best ERP software
    ERP for the manufacturing industry

  55. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted.

    Hadoop Training in Chennai

  56. Vishal says:

    Thanks for sharing, Really Good blog post.provided a useful information.I hope that you will post more updates like this

    Oracle fusion financials online training

  57. This blog is having the general information.Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog.This is very interesting and useful.

    Bigdata Training in Chennai

  58. Vishal says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

  59. Found your post interesting to read. I cant wait to see your post soon. Good Luck for the upcoming update.This article is really very interesting and effective.

    PSD to Wordpress
    wordpress website development

  60. Nikitha says:


    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    oracle fusion scm online training

    oracle fusion financials online training

  61. India's One of The Best Online Mobile Recharge Software Development Company, Using Our All in One Mobile Recharge Software You Can Recharge All India Operator via Single SIM Card. Free Distributor or Retailer ID. B2B or B2C Multi Recharge or Domestic Money Transfer Software Provider in India.
    Bulk SMS Provider in India, Promotional Bulk SMS Provider

  62. The Car featured content undergoes a thorough review process to ensure that it meets the highest standards in order to serve as the best car spare parts and fit the goals.

    Car Accessories in OMR

  63. Sravani says:

    Awesome post……. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion HCM Online Training

  64. raju says:

    Thank you for sharing such a nice and interesting blog.
    Oracle Fusion Financials Online Training

  65. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion SCM Online Training

  66. harsha says:

    Thanks for sharing such a wonderful blog.
    Oracle Fusion Taleo Online Training

  67. rani says:

    Nice blog continue posting such interesting blogs.

    Oracle Fusion HCM Online Training

  68. Awata SEO says:

    very useful information.
    Thanks,
    Home and Beyond is the best kitchen interior designer in India.
    modular kitchen designs
    kitchen interior designs
    modular kitchen showrooms in chennai

  69. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  70. leela says:

    Really very helpful article, Thank you for sharing interesting blogs.

    Oracle Fusion Technical Online Training

  71. Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.

    Restaurant in OMR
    Apartments in OMR
    Villas in OMR
    Resorts in OMR

  72. Anonymous says:

    I gathered some needful information from your blog.
    Weblogic Admin Training

  73. Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.

    Herbalife in Chennai
    Wellnesscentres in Chennai
    Weight loss in Chennai
    Weight gain in Chennai

  74. What you have written in this post is exactly what I have experience when I first started my blog.I’m happy that I came across with your site this article is on point,thanks again and have a great day.Keep update more information.
    3D printing companies in Chennai
    3D printing service Chennai
    3D printing service in Chennai

  75. Really excellent information and thank you for giving your valuable information

    Oracle Fusion Financials Online Training

  76. Awesome post. your article is really informative and helpful for me and other bloggers too

    oracle fusion scm online training

  77. Thanks for the informative article.This is one of the best resources I have found in quite some time.Nicely written and great info.I really cannot thank you enough for sharing.

    Herbalife in Chennai
    Subamwellness in Chennai
    Weight loss in Chennai
    Weight gain in Chennai

  78. The information which you have provided is very good. It is very useful who is looking for
    Java online training Bangalore

  79. Thank you for providing and sharing good information with the students it will be very helpful to them for Choosing the best course in future.

    Oracle Fusion Financials Training In Hyderabad | Rainbow Training Institute

  80. Usually I do not read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been surprised me. Thanks, very nice article.
    Peer Reviewed Journals
    Journal Of Mathematics
    Conference publication
    Journal Of Physics
    Journal Of Education

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -