The case was to roll forward a physical standby with an RMAN SCN incremental backup taken from primary. The standby database was just restored and necessary archived logs was missing somehow (That's another story). It was something i already did in the past so we set to work with my previous notes. Took the backup, copied files to standby server and recovered standby database. But the problem was, RECOVER DATABASE NOREDO statement was doing nothing so media recovery was asking for the same archived logs. 

Cross-checked the steps with Data Guard Concepts and Administration Guide there was nothing we were missing.

And then after the warning of my team-mate, checked the note on MyOracle Support "Steps to perform for Rolling forward a standby database using RMAN Incremental Backup. (Doc ID 836986.1)" and voila! My note and Administration Guide said "check the SCN on the standby database using V$DATABASE" and support note was saying:

"You need to use the 'lowest SCN' from the the 3 queries below"
SQL> select min(fhscn) from x$kcvfh;
SQL> select min(f.fhscn) from x$kcvfh f, v$datafile d where f.hxfil =d.file# and d.enabled != 'READ ONLY';

Again, in my case no media recovery was run on the standby and the control file was not sync with datafile headers.V$DATABASE gives information about the database from the control file and it was not the SCN i need on the incremental backup. I need the minimum SCN information on the datafile headers and that information is on x$kcvfh(Kernel Cache Recovery Component File Headers). Each row returned from this view is populated by reading the header off files on disk. While searching more on this view i realized it gives important information specially on problematic recovery cases. 
Happy recovering...

25 Responses so far.

  1. Unknown says:

    Interesting blog post.This blog shows that you have a great future as a content writer.waiting for more updates...
    Digital Marketing Company in India

    Digital Marketing Services in India

    Digital Marketing Agency in India

    Digital Marketing Companies in India

  2. This comment has been removed by the author.
  3. This comment has been removed by the author.
  4. sushma says:

    Hey Really Thanks for sharing the best information regarding category,hope you will write more great blogs.
    Oracle Fusion Financial Online Training

  5. Mahesh says:

    Really very informative and creative contents. This concept is a good way to enhance the knowledge.
    thanks for sharing. please keep it up.

    MATLAB training in gurgaon

  6. Thank you for sharing such a nice and interesting blog and very useful details with me. Thanks for your great effort.

    oracle fusion financials online training

  7. Really very helpful article, Thank you for sharing such a nice and interesting blog

    oracle fusion scm online training

  8. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article Oracle Fusion Financials Online Training

  9. Thank you for sharing such a nice and interesting blog and really very helpful article Oracle Fusion Financials Online Training

  10. I am really enjoying reading your well-written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.
    Hadoop Training in Chennai
    Big Data Training in Chennai
    German Classes in Chennai
    hadoop training in OMR
    hadoop training in Tambaram
    big data course in chennai
    Hadoop course in chennai

  11. Acil says:

    Thanks for sharing this post.

    Want to make your own website!!!
    Contact ACIL the best web design company in Delhi.

    Interested in Graphic Designing Course!!!
    Contact ACIL for the best Graphic designing Institute in Gurgaon.

    Interested in Python training!!!
    Contact ACIL for the best Python Training Institute in Gurgaon.

  12. subha says:

    I am not sure where you’re getting your info, but good topic. I needs to spend some time learning more or understanding more. Thanks for great info I was looking for this info for my mission keep it up
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

  13. Susan says:

    This is a great high resolution screen which you have shared for the users. Making a website is not an easy task but managing a good website is really a hard work. If you are looking for the best Things to do around the world, this list has something for everybody from food to history and culture.

  14. Our knowledge is truly enhanced after reading th8is. It was quite useful. We are truly glad that you shared this with us. Here is a referred link same as yours   oracle fusion financials training. While browsing, I came across this one, it's useful and will be providing necessary knowledge too.

  15. sri says:

    Thanks for sharing this informative content.,
    Leanpitch provides online training in Scrum Master Certification during this lockdown period everyone can use it wisely.
    Join Leanpitch 2 Days CSM Certification Workshop in different cities.
    CSM training online

    Scrum master training online

  16. says:

    Great Information .Wating for your next post.
    JFK Airport Premier Limo Service

  17. AH Group says:

    Peshawar is the capital of Khyber Pakhtunkhwa (KP) province of Pakistan. Peshawar is the city of Pakistan that is known because of its hospitality and delicious food. Peshawar has developed a lot of modern restaurants and tried to provide the best taste in all kinds of cuisines. Peshawar’s food is listed as one of the best foods worldwide. Check out my blog on best restaurants in peshawar

  18. This comment has been removed by the author.
Powered by Blogger.

Page Views

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