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

671 Responses so far.

«Oldest   ‹Older   601 – 671 of 671   Newer›   Newest»
  1. Thank you for taking the time to write this informative post on your blog. I'd like to congratulate you on your work. Have a great rest of your day and keep up the posts.
    Dentist Philadelphia

  2. OpenTeQ says:

    Your blog has wonderful information regarding software Development, I also have some valuable information regarding the Best Guidewire Development Services in USA, Canada and India hopefully, this will be very helpful for you.

  3. Oliver says:

    Is There A Link That You Could Share That Would Give Us A More Detailed Rundown On How VT MARKET LOGIN Works?

  4. wethink says:

    hi thanku this information thanku so much
    valueking

  5. Adnan says:

    Nice,
    For Download Subway Surfers Mod Apk Very nice post here thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.

  6. Thanks for sharing this amazing post. Keep posting and sharing with us.
    IELTS test
    IELTS online requirements
    English speaking classes

  7. HI THANKU SO MUCH THIS INFORMATION THANKU GRATEFUL INFORMATION
    vattalks

  8. wethink says:

    THANKU SO MUCH THIS INFROMATION
    Wethinksolution

  9. Anonymous says:

    Amazing Articles ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.If you are Searching for info click on given link
    Data science course in pune

  10. پنکک says:

    کدوم برند پنکک بهتره؟ به نظر من قیمت پنکک مک اصل خیلی گرونه.

  11. Become a Data Science expert with us. study Data Science Course in Hyderabad with Innomatics where you get a great experience and better knowledge.

  12. best says:


    diwali offers amazon is online store offering most popular Mobile phones, Cameras, Electronic Gadgets, Home Appliances, Apparels, Helmets, Car Accessories etc
    online shopping

  13. skillbee says:

    hi thanku so much
    please take some time and visit to our sites if anybody is searching for jobs .
    Skillbee is the best quest for new employment application.
    skillbee
    all job fujairah

  14. I read blogs on a similar topic, but I never visited your blog. I added it to favorites and I’ll be your constant reader. RPD Vest

  15. Join our Online Data Science Course program to analyze data, make effective predictions and gain a better understanding of market trends. Create disruptive business models for the topmost industries as we equip you with a sound business analytical & entrepreneurial ideology, alongside an excellent grasp of marketing strategies and trends.

  16. Thanks for sharing this blog with us. Really awesome blog, information, and knowledgeable content. Keep sharing more.
    Online Data Science Training in Hyderabad

  17. Devi says:

    Infycle Technology, the finest Software Training Institutes in Chennai Offering technical courses like Big Data, Cyber Security, Artificial Intelligence, Oracle, Java, Hadoop, Selenium, Android, and iOS Development, Data Science etc. It is the Best place to take Hadoop Training in Chennai for freshers, students, and tech professionals. For more enquiry and the free demo classes, Contact 7504633633.

  18. en iyi ambalaj bayi, angun store , focus peçete :)

  19. Maridev says:

    Grab the best AWS Training in Chennai from Infycle Technologies, the best software training institute, and Placement centre in Chennai. We also provide technical courses like Power BI, Cyber Security, Graphic Design and Animation, Block Security, Java, Oracle, Python etc. For free demo class and enquiry call 7504633633.

  20. I read this article. I think You put a lot of effort to create this article. I appreciate your work. Hells Angels Vest

  21. a fantastic article Thank you for sharing. Everyone seeking a software agency should read this post.
    Brisk logic is a Mohali-based software design, app development, and web design firm.software development agency

  22. Thanks for the best blog. it was very useful for me.keep sharing such ideas in the future as well. Love Hard Leather Jacket

  23. Statistics students and professor are worried to find the deviation calculator because their work depends on it. Love Hard Leather Jacket

  24. Nice article and a great way of learning about the topic in an easy language.
    Get all info on Quickbooks or regarding any error that might happen in system like Print Bank Reconciliation QuickBooks from the link in one place.

  25. Are you preparing yourself for the GRE or GMAT exam? Or have you already given the tests and looking for ways to improve your scores? Is your target a score of 2100 or 700+ ? Then there is a blog for you which is about GRE or GMAT and you can visit the website trickytests.com and start preparation now.

  26. Anonymous says:

    I want the world to know about where to invest their hard earned money and get fruitful returns. If one is looking forward of investing he can go into investment of crypto coins.
    You can invest in Fudxcoin company that deals in the selling and purchasing of Crypto Currency. It is a reliable company. One need not doubt in investing in it as i have also bought crypto currency from it and feeling very satisfied with their services.
    crypto currency block chain technology

  27. Amazon code: Enter the amazon activation code/amazon myTV code shown on your smart TV screen at Amzaon.com/mytv to register your compatible
    device with Amazon Prime. Enjoy unlimited movies and other web shows
    amazon com code
    venmo login
    aol login
    amazon/code
    amex login
    amazon code
    hbomax.com/tvsignin

  28. ed says:

    Having an Ice Maker is amazing, isn’t it? You can have ice at any time you want. You know the importance of ice that’s why you’re here looking for the Best Portable Ice Maker with a freezer compartment., don’t you? Well, don’t worry, your research ends here because you’re on the website which will tell you all about the best Portable Ice Maker with freezer compartment.

  29. ed says:

    From kids to old, everyone loves long rides in the RVs and vacations with their families. During summer, to make this enjoyable moment over the moon, you’re going to need some cold place to relax and chilled drinks to enjoy the weather. Isn’t it? We bet it is. That’s why you’re going to need the best portable ice maker for RV.

  30. QuickBooks Error 16026 usually occurs when you are trying to update your QuickBooks applications. This particular article is all about the QuickBooks Error 16026, its principle originating factors and the debugging practices for your help

  31. automind says:

    As you have now understood the usage of ‘Record and Playback’ tool, the following are the different posts using which you can explore the functioning of ‘Selenium IDE’
    selenium Training in chennai

  32. automind says:

    SQream Technologies provides you with a state of the art software which combines modern GPU technology (Graphic Processing Units) with the best practices in today’s Big Data platforms, providing up to 100x faster insights from data.
    Bigdata Training in Chennai OMR

  33. This is a nice post and I am also add some Information about important Apps Grocery App Development and Laundry application development. Thank you.

  34. Unknown says:

    Contact the customer service number or visit the Lowe's website to see the balance of the Lowe's gift card. Do you need to purchase another Gift card from Lowe's?
    lowes.com/giftcards
    Sephora gift card balance
    vanilla gift card balance
    Amazon code

  35. Unknown says:

    Balance of the gift card at Lowe's check online. First, go on the Gift Card Balance page. There, enter your card's number and PIN number to checkAppstore.com/redeem
    Play.google.com/redeem
    macy's gift card balance
    Apple gift card balance

  36. Unknown says:

    Begin by looking at the back of the gift card. In most cases, you'll find an unreliable number which you can dial to check the balance. You can also verify the balance of your account using visiting the website of the issuer and entering your card's 16-digit code along with the security code.
    sephora gift card balance
    Best Buy Gift Card Balance
    Mastercard gift card balance
    Target.com/checkbalance


  37. Activation of amazon Prime video can be done from either link amazon com code or www.primevideo.com/mytv. Both links amazon prime allow for activation and sign in to Amazon. Before logging in to amazon.com/mytv, the user must have a 6 Digit Amazon Activation Code. Amazon prime video subscription can start after you login to these link primevideo.com/mytv.

  38. This is a really nice article

  39. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. Great work
    data science course in malaysia

  40. Anne says:

    Very good article! Your post is really supportive for me thanks for delightful post. I am very pleased to read your post Home Lifts in Nigeria.
    a lift home
    elevator or lift

  41. Emi says:

    We are pleased by the details you have posted on your blog, and I have enjoyed reading this information for future reference. Contribute a great deal! Learn something about Lifts Companies in Dubai. home elevator | lifts for home

  42. Instagram video download serivce by MyInstaSave.com, allows to download Instagram videos and photos, reels online. It is a really simple Instagram video downloader, story saver etc.

    instagram video download
    instagram reels download
    instagram video downloader
    instagram story download

  43. Anonymous says:

    Thanks for this amazing Post

  44. Anonymous says:

    hey

  45. Thanks for sharing this amazing and informative post. keep sharing with us.
    B3 Men Shearling Aviator Bomber Leather Jackets

  46. SwarnApp says:

    Billing Software
    best jewellery management software

«Oldest ‹Older   601 – 671 of 671   Newer› Newest»
Powered by Blogger.

Page Views

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