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.
http://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm#SBYDB00759
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 CURRENT_SCN FROM V$DATABASE;
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...
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
Hey Really Thanks for sharing the best information regarding category,hope you will write more great blogs.
Oracle Fusion Financial Online Training
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
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
Really very helpful article, Thank you for sharing such a nice and interesting blog
oracle fusion scm online training
Good blog, thanks for sharing this valuable information.
tirupati tour packages
tirupati tour
tirupati travels chennai
tirupati darshan package
tirupati balaji tour package
Tirupati Package from Chennai
Tirupati Packages from chennai
tirupati tour package from chennai
one day trip to tirupati from chennai
one day tirupati package from chennai
tirupati darshan package from chennai
one day tirupati tour package from chennai
tirupati one day tour package
tirupati one day trip from chennai
tirupati balaji tour package from chennai
one day tirupati darshan package from chennai
tirupati one day trip
one day tour package from chennai to tirupati
tirupati one day package
tirupati darshan from chennai
tirupati darshan from chennai
chennai to tirupati package tour with darshan
tirupati tour package
chennai to tirupati package
tirupati packages
tirupati package tour
tirupati car packages
tirupati package from chennai by car
tirupati one day package from chennai by car
Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article Oracle Fusion Financials Online Training
Thank you for sharing such a nice and interesting blog and really very helpful article Oracle Fusion Financials Online Training
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
Thanks for sharing this post.
Want to make your own website!!!
Contact ACIL the best web design company in Delhi.
WEB DESIGN COMPANY IN DELHI
Interested in Graphic Designing Course!!!
Contact ACIL for the best Graphic designing Institute in Gurgaon.
GRAPHIC DESIGNING INSTITUTE IN GURGAON
Interested in Python training!!!
Contact ACIL for the best Python Training Institute in Gurgaon.
PYTHON TRAINING INSTITUTE IN GURGAON
Its such a wonderful article. The above article is very helpful to study the technology and I gain my knowledge. Thanks for that and Keep posting.
Embedded System Course Chennai
Embedded Training in Chennai
Placement in Chennai
Soft Skills Training in Chennai
JMeter Training in Chennai
Appium Training in Chennai
Power BI Training in Chennai
Tableau Training in Chennai
Oracle Training in Chennai
Advanced Excel Training in Chennai
Really excellent information and thank you for giving your valuable information
Big Data Hadoop Course | Big Data Hadoop Certification Training
Big Data and Hadoop Online Training | Big Data Hadoop Training
Really excellent information and thank you for giving your valuable information..
Web Design and Development Bangalore | Web Designing Company In Bangalore | Web Development Company Bangalore | Web Design Company Bangalore
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
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.
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.
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
Very Informative blog thank you for sharing. Keep sharing.
Best software training institute in Chennai. Make your career development the best by learning software courses.
best azure training in chennai
informatica training in chennai
best blue prism training in chennai
cloud computing classes in chennai
power bi certification training
best msbi training institute in chennai
Docker Training in Chennai
android course in chennai
ios training in chennai
Xamarin Course in Chennai
Very Informative blog thank you for sharing. Keep sharing.
Best software training institute in Chennai. Make your career development the best by learning software courses.
power bi training in chennai
azure course in chennai
informatica training in chennai
best blue prism training in chennai
cloud computing classes in chennai
best msbi training institute in chennai
Docker Training in Chennai
android course in chennai
ios training in chennai
Xamarin Course in Chennai
Great Information .Wating for your next post.
JFK Airport Premier Limo Service
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
03/29/2024
Best Oracle Academy - Oracle Training Academy
Great blog post! Your insights are both informative and engaging. Fasteners Manufacturers In India