"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 :)

40 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. 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. jayashree 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

DOAG 2016

Powered by Blogger.

Page Views

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