We have a DB in NFS storage with 5TB in size. As the DB size grows Application team started complaining poor performance on the queries. Also recently we had issues on NFS array due to which all the NFS storage on that array started giving poor performance. So we decided to move the DB from NFS to SAN storage.
Usually DB failover happens when Primary DB is completely unavailable. After the failover former primary DB is no longer needed.
Solution:
In order to setup Standby database we have got new host with SAN storage and then we have built physical Standby on the new host and make it SYNC with its primary DB.
At the time of failover, on the Primary DB disable the log shipping to standby DB and stop the listener service then bounce the DB. (this will make sure no changes happened on the DB)
Now switch the log files couple of times and manually transfer those newly generated archive logs to the standby database and recover it.
prod_host.mydomain.com {oracle}:PROD_DB>sqldba SQL*Plus: Release 11.2.0.4.0 Production on Sun Nov 16 22:14:15 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select max(sequence#) from v$archived_log where applied='YES'; MAX(SEQUENCE#) -------------- 28156 SQL> select max(sequence#) from v$archived_log where applied='YES'; MAX(SEQUENCE#) -------------- 28156 SQL> alter system set log_archive_dest_state_2='DEFER'; System altered.On Standby DB need to check if there is any gap.
SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference" FROM 2 (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, 3 (SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL 4 WHERE ARCH.THREAD# = APPL.THREAD# ORDER BY 1; Thread Last Sequence Received Last Sequence Applied Difference ---------- ---------------------- --------------------- ---------- 1 28156 28156 0If there is no gap we can then proceed with activating the Standby Database.
Since this is a planned activity, we need to ensure that all the archive logs are applied on the Standby DB before to activate the Standby DB
SQL> alter database recover managed standby database cancel; Database altered. SQL> alter database recover managed standby database finish; Database altered. SQL> alter database activate physical standby database; Database altered. SQL> alter database open; Database altered. SQL> select name, open_mode, database_role from v$database; NAME OPEN_MODE DATABASE_ROLE --------- -------------------- ---------------- PROD_DB READ WRITE PRIMARY
Thats it! we have now moved the entire DB to SAN storage also Standby Database is now converted into Primary Database.
Valuable information thanks for sharing Oracle DBA Online Training
ReplyDeleteGreat Article
DeleteIEEE Projects for CSE in Big Data
Java Training in Chennai
Final Year Project Centers in Chennai
Java Training in Chennai
Hi, I am really happy to found such a helpful and fascinating post that is written in well manner. Thanks for sharing such an informative post. keep update your blog. R Programming Online Training
ReplyDeletegreat post you can heck it out for information for PEGA Online Training
ReplyDeleteValuable information thanks for sharing Oracle DBA Online Training
ReplyDeleteThere will be a list of users that are authorized to access the data on the database and when this access is restricted, the data is all the more secured.oracle dashboards
ReplyDeleteValuable information thanks for sharing Oracle DBA Online Training
ReplyDeleteThanks a lot very much for the high your blog post quality and results-
ReplyDeleteoriented help. I won’t think twice to endorse to anybody who wants
and needs support about this area.
Oracle Training in chennai
Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.
ReplyDeletedigital marketing training in chennai
Needed to compose one little word thanks for the suggestion that you are contributed here.
ReplyDeleteBest Online Software Training Institute | Oracle DBA Training
I just needed to record a speedy word to express profound gratitude to you for those magnificent tips and clues you are appearing on this site.
ReplyDeleteOracle DBA training in Chennai
Oracle DBA Training
Thanks for the content loaded with lots of new info.
ReplyDeleteSelenium Training in Chennai
Selenium Training
iOS Training in Chennai
Digital Marketing Training in Chennai
Salesforce Training in Chennai
Salesforce Training
Salesforce Course in Adyar
Large-scale manufacturing, sewage treatment and power generation facilities are required to leverage increased process visibility which provides better and faster decisions, increased productivity and reduced costs for a sustainable competitive advantage.Database Diagram Tool
ReplyDeleteProbably, of all the preferences, this casino is my favorite. superb bonus slot machines I like everything in the casino, the roulette is excellent, I am glad that during the game you can also talk to people who also play at the same table! Muzychka great. With the conclusion there were no difficulties at all. Easily raised from $ 30 to $ 600, withdraw. Played, played, will play!
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHappy to read your blog and gained a lot of new information in detail. Thanks for sharing.
ReplyDeleteSpoken English in Velachery
Spoken English Class in Chrompet
Spoken English Classes in Navalur
Spoken English Class in Avadi
Spoken English Class in Chennai
Spoken English Classes in Chennai
In the beginning, I would like to thank you much about this great post. Its very useful and helpful for anyone looking for tips. I like your writing style and I hope you will keep doing this good working.
ReplyDeleteData Science Course in Chennai
Data Science Training in Chennai
Blue Prism Training Chennai
AWS Training in Chennai
Digital Marketing Course in Chennai
Data Science Training in Porur
Data Science Training in Adyar
Data Science Training in Velachery
It is very useful for me to learn and understand easily. Thanks for sharing your valuable information and time.
ReplyDeleteCEH Training In Hyderbad
Thank you so much for the basic details and code in oracle in detailed way.Very clear to understand even for the unknowns of the language.
ReplyDeleteoneplus mobile service centre in chennai
oneplus mobile service centre
oneplus service center near me
oneplus service
Great post. You have written a valuable content in a interesting way. Kindly share more updates.
ReplyDeleteSpoken English Classes in Chennai
IELTS Coaching in Chennai
Best Spoken English Classes in Chennai
Spoken English Class in Chennai
Spoken English in Chennai
English Classes in Chennai
I feel satisfied to read your blog, you have been delivering a useful & unique information to our vision.keep blogging.
ReplyDeleteRegards,
Certified Ethical Hacking Course in Chennai
Ethical Hacking Training in Chennai
Tally Course in Chennai
Salesforce Training in Chennai
Angularjs Training in Chennai
ui design course in chennai
ethical hacking course in chennai
hacking course in chennai
ReplyDeleteTruly well post and I must say it's really useful for us. I want to more unique ideas from your blog and Keep blogging...
Corporate Training in Chennai
Corporate Training institute in Chennai
Excel Training in Chennai
Social Media Marketing Courses in Chennai
Pega Training in Chennai
Oracle DBA Training in Chennai
Oracle Training in Chennai
Embedded System Course Chennai
Linux Training in Chennai
Power BI Training in Chennai
It was good explanation and wonderful content. Keep posting...
ReplyDeleteIELTS Coaching in Chennai
IELTS Training in Chennai
German Classes in Chennai
Japanese Classes in Chennai
Spoken English Classes in Chennai
TOEFL Coaching in Chennai
IELTS Coaching in Adyar
IELTS Coaching in Velachery
Thanks for the informative blog!Keep sharing like this information for future use.
ReplyDeletedigital marketing training in chennai
digital marketing course in chennai
seo training in chennai
Python Training in Chennai
AWS Training in Chennai
Data Science Course in Chennai
Selenium Training in Chennai
Salesforce Training in Chennai
digital marketing training in chennai
digital marketing course in chennai
Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
ReplyDeleteIf you are looking for any Big data Hadoop Related information please visit our website Big Data Training In Bangalore page!
I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
ReplyDeleteCyber Security Projects for Final Year
JavaScript Training in Chennai
Project Centers in Chennai
JavaScript Training in Chennai
https://testleaf.com
ReplyDeletehttps://testleaf.com/course/selenium-training-institute-in-chennai-weekends
https://testleaf.com/course/data-science-training-in-chennai-using-python
https://testleaf.com/course/rpa-training-in-chennai-using-uipath-blue-prism/
https://testleaf.com/course/rpa-training-in-chennai-using-uipath-blue-prism/
https://testleaf.com/course/loadrunner-training-in-chennai/
https://testleaf.com/course/apache-jmeter-training-in-chennai/
https://testleaf.com/course/protractor-training-in-chennai/
https://testleaf.com/course/python-training-institute-in-chennai/
https://testleaf.com/course/selenium-training-institute-in-chennai-weekends/
Nice...
ReplyDeletebitwise aptitude questions
how to hack flipkart legally
zenq interview questions
count ways to n'th stair(order does not matter)
zeus learning subjective test
ajax success redirect to another page with data
l&t type 2 coordination chart
html rollover image
hack android phone using cmd
how to hack internet speed upto 100mbps
Good..
ReplyDeleteinternships in chennai
winter internship mechanical engineering
internship for aeronautical engineering students in india 2019
kaashiv
list of architectural firms in chennai for internship
paid internships in pune for computer science students
diploma final year project topics for information technology
internship
data science internship report
inplant training
Thanks for sharing valuable information.
ReplyDeleteDigital Marketing training Course in Chennai
digital marketing training institute in Chennai
digital marketing training in Chennai
digital marketing course in Chennai
digital marketing course training in omr
digital marketing certification in omr
digital marketing course training in velachery
digital marketing training center in Chennai
digital marketing courses with placement in Chennai
digital marketing certification in Chennai
digital marketing institute in Chennai
digital marketing certification course in Chennai
digital marketing course training in Chennai
Digital Marketing course in Chennai with placement
digital marketing courses in Chennai
Great Article. Thank you for sharing! Really an awesome post for every one.
ReplyDeleteProject Centers in Chennai
JavaScript Training in Chennai
Final Year Project Domains for IT
JavaScript Training in Chennai
keep up the good work. this is an Assam post. this to helpful, i have reading here all post. i am impressed. thank you. this is our digital marketing training center. This is an online certificate course
ReplyDeletedigital marketing training in bangalore | https://www.excelr.com/digital-marketing-training-in-bangalore
Learned a lot of new things in this post. This post gives a piece of excellent information.
ReplyDeletespoken english classes in bangalore
Spoken English Classes in Chennai
spoken english class in coimbatore
spoken english class in madurai
devops training in bangalore
DOT NET Training in Bangalore
best spoken english classes in bangalore
Spoken English in Chennai
best spoken english institute in coimbatore
best spoken english center in madurai
Thanks for sharing this Valuable information.keep update like this..
ReplyDeleteGerman Classes in Chennai
German Classes in Bangalore
German Classes in Coimbatore
German Classes in Madurai
German Language Course in Hyderabad
German Courses in Chennai
German Courses in Bangalore
German Courses in Coimbatore
German classes in marathahalli
Tally Course in Coimbatore
Great Article. Thank you for sharing! Really an awesome post for every one.
ReplyDeleteIEEE Final Year projects Project Centers in Chennai are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. Final Year Project Domains for IT It gives you tips and rules that is progressively critical to consider while choosing any final year project point.
Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
Awesome nice post...
ReplyDeleteinternship report on python
free internship in chennai for ece students
free internship for bca
internship for computer science engineering students in india
internships in hyderabad for cse students 2018
electrical companies in hyderabad for internship
internships in chennai for cse students 2019
internships for ece students
inplant training in tcs chennai
internship at chennai
Nice Infromation....
ReplyDeleteinternship in chennai for ece students with stipend
internship for mechanical engineering students in chennai
inplant training in chennai
free internship in pune for computer engineering students
internship in chennai for mca
iot internships
internships for cse students in hyderabad
implant training in chennai
internship for aeronautical engineering students in bangalore
inplant training certificate
very nice post.........
ReplyDeleter programming training in chennai
internship in bangalore for ece students
inplant training for mechanical engineering students
summer internships in hyderabad for cse students 2019
final year project ideas for information technology
bba internship certificate
internship in bangalore for ece
internship for cse students in hyderabad
summer training for ece students after second year
robotics courses in chennai
Nice post...
ReplyDelete3d-modeler-resume-samples
3d modeler resume samples
accounting-assistant-resume-sample
accounting-clerk-resume-sample
accounting-manager-resume-samples
account-manager-resume-examples
accounts-payable-resume-sample
admin-manager-resume-samples
advocate-resume-sample
advocate-resume-sample
it is good blogs!!!
ReplyDeletepaid internships in pune for computer science students
machine learning training in chennai
data science internship in chennai
dot net training in chennai
kaashiv infotech chennai
internship for aeronautical engineering students in india
internship in automobile industry
big data internship in chennai
machine learning internship in chennai
internship in chennai for it students
branch-operations-manager-resume-samples
ReplyDeletebusiness-executive-resume-samples
business-owner-resume-samples
business-to-business-sales-resume-sample-sales-resumes
cad-design-engineer-resume-samples
call-centre-jobs-resume-sample
ca-resume-samples-chartered-accountant-resume-format
cassandra-database-administrator-resume
category/accountant-resume
category/admin-resume
good....nice
ReplyDeletecategory/advocate-resume
category/agriculture-forestry-fishing
category/android-developer-resume
category/assistant-professor-resume
category/chartered-accountant-resume
category/database-resume
category/design-engineer-resume
category/developer-resume
category/engineer-resume
category/entrepreneur-and-financial-services-resume
good..nice..
ReplyDeleteassistant-director-resume-format
assistant-director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
good ....nice...
ReplyDeleteresume/category/software-testing-resume
resume/category/sslc-resume
resume/category/storekeeper-resume
resume/category/stylist-resume
resume/category/teachers-resume
resume/category/technical-architect-resume
resume/category/web-developer-resume
cics-system-programmer-resume-example
resume/cisco-network-engineer-resume
resume/cisco-network-engineer-resume-sample
good... nice... very useful..
ReplyDeleteassistant-director-resume-format
director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
good.....nice..
ReplyDeletecategory/maintenance-resume
category/manager-resume
category/mechanical-engineering-resume
category/network-engineer-resume
category/officer-resume
category/operations-resume
category/process-associate-resume
category/quality-control-resumes
category/software-engineer-resume
Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Courses in Bangalore
digital marketing training in marathahalli
Digital Marketing Course in Coimbatore
Digital Marketing Course in Madurai
digital marketing training in btm
ReplyDeletefilm-director-resume
finance-and-accounting-manager-resume-samples
finance-director-resume-examples
fire-safety-officer-resume-sample
fleet-maintenance-manager-resume-samples
format-for-resume-writing
fresher-computer-engineers-resume-sample
fresher-hr-resume-sample
fresher-hr-resume-sample-2
fresher-lecturer-resume
This comment has been removed by the author.
ReplyDeleteExcellent and very cool idea and great content of different kinds of the valuable information's.
ReplyDeleteTOEFL Coaching in Chennai
TOEFL Classes in Chennai
German Classes in Chennai
IELTS Coaching in Chennai
Japanese Classes in Chennai
Spoken English Classes in Chennai
spanish classes in chennai
content writing course in chennai
TOEFL Coaching in OMR
TOEFL Coaching in Porur
ReplyDeleteThis content of information has
helped me a lot. It is very well explained and easy to understand.
seo training classes
seo training course
seo training institute in chennai
seo training institutes
seo courses in chennai
seo institutes in chennai
seo classes in chennai
seo training center in chennai
ReplyDeleteYou write this post very carefully I think, which is easily understandable to me. Not only this, but another post is also good. As a newbie, this info is really helpful for me. Thanks to you.
Tally ERP 9 Training
tally classes
Tally Training institute in Chennai
Tally course in Chennai
Nice post. Thanks for sharing! I want people to know just how good this information is in your article. It’s interesting content and Great work.
ReplyDeleteDigital Marketing Course In Kolkata
Web Design Course In Kolkata
Top technologies to learn
ReplyDeleteI am glad that I have visited this blog. Really helpful, eagerly waiting for more updates.
ReplyDeleteValuable one...thanks for sharing...
DOT NET Training in Chennai
.net coaching centre in chennai
.Net training in chennai
DOT NET Course in Chennai
dot net training in anna nagar
Html5 Training in Chennai
Spring Training in Chennai
Struts Training in Chennai
Wordpress Training in Chennai
SAS Training in Chennai
Very informative blog. Got more information about this technology.
ReplyDeleteFrench Classes in Chennai
french classes
German Courses in Chennai
pearson vue exam centers in chennai
Informatica MDM Training in Chennai
ielts exam coaching in chennai
best spoken english institute in chennai
Hadoop Admin Training in Chennai
content writing training in chennai
spanish language classes in chennai
French Classes in Porur
French Classes in Velachery
ReplyDeleteCan you explain real time ETL scenarios and how to test those scenarios. it will helpfull for me.share more.
C and C++ Training Institute in chennai | C and C++ Training Institute in anna nagar | C and C++ Training Institute in omr | C and C++ Training Institute in porur | C and C++ Training Institute in tambaram | C and C++ Training Institute in velachery
"Very good post!!! Thanks for sharing with us. It is more useful for us...
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
"
I ‘d mention that most of us visitors are endowed to exist in a fabulous place with very many wonderful individuals with very helpful things.
ReplyDeleteOracle Training | Online Course | Certification in chennai | Oracle Training | Online Course | Certification in bangalore | Oracle Training | Online Course | Certification in hyderabad | Oracle Training | Online Course | Certification in pune | Oracle Training | Online Course | Certification in coimbatore
Nice! you are sharing such helpful and easy to understandable blog. i have no words for say i just say thanks because it is helpful for me
ReplyDeleteDot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery
Thank You for Sharing Valuable Information. I like this blog and this is very informative.
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
ReplyDeleteWeb Designing Course Training in Chennai | Web Designing Course Training in annanagar | Web Designing Course Training in omr | Web Designing Course Training in porur | Web Designing Course Training in tambaram | Web Designing Course Training in velachery
Your site is amazing and your blogs are informative and knowledgeable to my websites.This is one of the best tips in my life. I have in quite some time.Nicely written and great info.Thanks to share the more information's.
ReplyDeleteSalesforce Training in Chennai | Certification | Online Course | Salesforce Training in Bangalore | Certification | Online Course | Salesforce Training in Hyderabad | Certification | Online Course | Salesforce Training in Pune | Certification | Online Course | Salesforce Online Training | Salesforce Training
I’m really happy to say it was an interesting post to read. I learned new information from your article. You are doing a great job.
ReplyDeleteSalesforce Training in Chennai
Salesforce Online Training in Chennai
Salesforce Training in Bangalore
Salesforce Training in Hyderabad
Salesforce training in ameerpet
Salesforce Training in Pune
Salesforce Online Training
Salesforce Training
I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place
ReplyDelete360digitmg
selenium interview questions and answers for experienced
ReplyDeleteGet here for Selenium Interview Questions and Answers for freshers and experienced person those who want to explore more on testing selenium interview questions and answers for experienced
devops interview questions and answers for freshers
ReplyDeleteImportant DevOps Interview Questions and Answers for freshers and experienced to start your career in DevOps! 101 DevOps Basic Interview Questions for Freshers.devops interview questions and answers for experienced
GOOD ARTICLE
ReplyDeletefinal year project
mini projects for cse
final year projects for cse
final year projects for cse students
final year projects for cse domains
final year projects for cse in data mining
final year projects for cse with source code
final year project for ece
final year project in mechanical engineering
final year project for eee
Thank you for sharing the article. The data that you provided in the blog is informative and effective.
ReplyDeleteTableau Training in Hyderabad
Wow! Such an amazing and helpful post this is. I really really love it. It's so good and so awesome. I am just amazed. I hope that you continue to do your work like this in the future also studio de personal trainer asa sul
ReplyDeleteYour blog is so impressive to us. Thanks for sharing this post. Good content delivery.
ReplyDeletedevops culture
java mobile app development
adwords campaign
is web design a good career
seo interview questions and answers