DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, October 24, 2016

Solved " ORA-16057: server not in Data Guard configuration " , in oracle dataguard environment



We faced the error ORA-16057 while building a standby database.archives were not shipping to the DR site

Now in the production database,

Select dest_id,error from v$archive_dest;

   DEST_ID ERROR
---------- --------------------------------------------------------------------------
         1
         2
         3
         4  ORA-16057: server not in Data Guard configuration
         5
         6
         7
         8
         9
        10
        11



In our case ,this error is due to wrong configuration in "log_archive_config" parameter in the DR side .
Once we the fixed the parameter "log_archive_config"

sql > alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,standby)' scope=both;

Now defer and enable the "log_archive_dest_state_4" paramter in production DB.and the logs started shipping to DR without any issues


sql > alter system set log_archive_dest_state_4=DEFER;

sql > alter system set log_archive_dest_state_4=ENABLE;


Now checking again for the error,

Select dest_id,error from v$archive_dest;

   DEST_ID ERROR
---------- -------------------------------------------------------------------------
         1
         2
         3
         4
         5
         6
         7
         8
         9
        10
        11


Hope this helps.. 

23 comments:

kiran G said...

Appreciate your work, very informative blog on Oracle Apps. I just wanted to share information about Oracle EBS Training. Hope it helps community here.

Praveen Kumar said...

Valuable information thanks for sharing Oracle DBA Online Training

dushyant sharma said...

Tent house in Noida

Tent house in greater noida

Sunil Dubey said...

SAS training in noida
php training in noida
linux training in noida
cloud computing training in noida
hadoop training in noida
web designing training in noida
Python training in noida

dushyant sharma said...

hadoop training institute in Indirapuram

JAVA Training Institute in indirapuram

dushyant sharma said...

SEO company in Wakefield

SEO company in Virginia

SEO company in Utah

SEO company in USA

Unknown said...

Webtrackker is Noida's best
digital marketing training institute in noida, with the best infrastructure and lab facilities.
Sap Training Institute in Noida
Sas Training Institute in Noida
PHP Training Institute in Noida
Hadoop Training Institute in Noida
Oracle Training Institute in Noida
Linux Training Institute in Noida
Dot net Training Institute in Noida
Salesforce training institute in noida
Java training institute in noida

dushyant sharma said...

seo company in jamaica
seo company in italy
seo company in isreal
seo company in indonesia
seo company in hungary
seo company in hong kong
seo company in greece

dushyant sharma said...

seo company in switzerland
seo company in south africa
seo company in singapore
seo company in sheffield
seo company in saudi arabia

dushyant sharma said...

kenya safari masai mara

kenya luxury safari lodges

dushyant sharma said...

sky infotech noida reviews

sky infotech noida reviews

sky infotech noida reviews

aashutosh webtrackker said...

Web Designing training institute in Ghaziabad
AngularJS Training Institute in Ghaziabad
Java training Institute In Ghaziabad

aashutosh webtrackker said...

SAP training institute in Ghaziabad
SAS training institute in Ghaziabad
ccna training Institute In Ghaziabad
Android apps training Institute In Ghaziabad
Oracle DBA training institute in Ghaziabad

aashutosh webtrackker said...

Software Testing Training Institute in Ghaziabad
Dot Net training institute in Ghaziabad
Oracle DBA training institute in Ghaziabad
Digital Marketing training institute in Ghaziabad
Php training institute in Ghaziabad

ciit noida said...

CIITN Noida provides Best Big Data Training Institute in Noida & big Data Hadoop Training Institute in Noida. based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. CIITN Provides Best Big Data Training in Noida. CIITN is one of the most credible Big Data training institutes in Noida offering hands on practical knowledge and full job assistance with basic as well as advanced level Big Data training courses. At CIITN Big Data training in noida is conducted by subject specialist corporate professionals with 7+ years of experience in managing real-time Big Data projects. CIITN implements a blend of academic learning and practical sessions to give the student optimum exposure that aids in the transformation of naïve students into thorough professionals that are easily recruited within the industry.
CIITN is the best Hadoop training center in Noida with a very high level infrastructure and laboratory facility. The most attractive thing is that candidates can opt multiple Institute.
Best Big Data Training Institute in Noida

CIIT Noida said...

CIITN is the best SAP training and placement Institute in noida. Contestant will analyze in keeping with modern-day enterprise trends by way of certified and industry experts & SAP training Institute in Noida. They provide a 100% placement help with the best training of IT cousrses.

If you are looking best sap training in Noida then you can join CIITN. One of the premier training and development institute for SAP Training Program in Noida. The company provides 6 weeks/ 6 Months Training for SAP. They provide training in all SAP Modules like SAP HANA,SAP B1, SAP FICO etc. Just come for free demo class and then join SAP and move up in your career .

SAP Training Institute in Noida
sap training in noida
sap institute in noida
sap course in noida
best sap training institute in noida

ciit noida said...

CIITN provides Best Linux training in noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. CIITN Provides Best Linux Training in Noida. CIITN is one of the most credible offering hands on practical knowledge and full job assistance with basic as well as advanced level.

Linux Training in Noida

ciit noida said...

CIITN provides Best Linux training in noida based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. CIITN Provides Best Linux Training in Noida. CIITN is one of the most credible offering hands on practical knowledge and full job assistance with basic as well as advanced level.

best linux training institute in noida

linux training in noida

ciit noida said...

CIITN is the pioneer of education providing the best PHP training in Noida as per the current industry requirement that enables candidates to land on their dream jobs in companies worldwide. CIITN Provides best PHP training course in Noida. CIITN is a renowned training company providing the best training service and also being the best PHP training institute in Noida rendering practical knowledge through training on projects and a dedicated placement assistance for all. The course curriculum for PHP training course is designed to provide in-depth knowledge that covers all the modules for the training ranging from basic to advanced level. At CIITN PHP training in Noida is supervised and managed by industrial experts having more than 10 years of experience in handling PHP projects. CIITN training comprises of both classroom as well as practical sessions to deliver an ideal environment for students that will enable them to handle difficult and complex situation when they would step into the reality of IT sector.CIITN is an excellent PHP training center in Noida with superior integrated infrastructure and newly designed labs for students to practice and pursue training for multiple courses at Noida. CIITN institute in Noida train thousands of students around the globe every year for the PHP training at an affordable price which is customised as per each candidate’s requirement of modules and content.


PHP training in Noida

CIIT Noida said...

CIITN is the Best Php training institute in Noida and delhi Ncr. You will get Live Project Training on PHP by our PHP expert who have 5+ year industrial experience.Focus on practical and live project training. In our PHP training, we you will learn core PHP, advance PHP, HTML, CSS, JavaScript, jQuery, Bootstrap, Cake PHP and Wordpress.CIITN provides 100% job assistance in PHP training. CIITN is well known PHP coaching center because our 100% PHP students are placed now.


Ciitnoida provides Core and java training institute in noida. We have a team of experienced Java professionals who help our students learn Java with the help of Live Base Projects. The object-oriented, class-based build of Java has made it one of most popular programming languages and the demand of professionals with certification in Advance Java training is at an all-time high not just in India but foreign countries too.

By helping our students understand the fundamentals and Advance concepts of Java, we prepare them for a successful programming career. With over 13 years of sound experience, we have successfully trained hundreds of students in Noida and have been able to turn ourselves into an institute for best Java training in Noida.


java training institute in noida
php training in noida
linux training in noida
linux institute in noida
java course in noida

CIIT Noida said...

CIIT Noida provides Best MCA Courses in Noida based on the current

IT industry standards that help students to get high paying jobs in Top MNCs. CIIT provides Best MCA Training in Noida, Greater Noida, and Ghaziabad.

CIIT is one of the trusted MCA training institutes in Noida providing practical knowledge and 100% job assistance with basic as well as advanced

level MCA subjects. CIITN is the best MCA college in Noida, greater noida, ghaziabad, delhi, gurgaon regoin.

At CIIT MCA classes in Noida is conducted by subject experts corporate professionals with 9+ years of experience in managing real-time and live

projects. Sofracle Nano Specialized MCA classes Noida is the perfect blend of academic learning and practical sessions to provide maximum exposure to

students that transform an average student into a corporate professional whom companies prefer to hire.

Best MCA College in Noida

CIIT Noida said...

CIITN is located in Prime location in Noida having best connectivity via all modes of public transport. CIITN offer both

weekend and weekdays courses to facilitate Hadoop aspirants. Among all Hadoop Training Institute in Noida , CIITN's Big Data and Hadoop Certification course is designed to prepare you to match

all required knowledge for real time job assignment in the Big Data world with top level companies. CIITN puts more focus in project based training

and facilitated with Hadoop 2.7 with Cloud Lab—a cloud-based Hadoop environment lab setup for hands-on experience.

CIITNOIDA is the good choice for Big Data Hadoop

Training in NOIDA
in the final year. I have also completed my summer training from here. It provides high quality Hadoop training with Live

projects. The best thing about CIITNOIDA is its experienced trainers and updated course content. They even provide you placement guidance and have

their own development cell. You can attend their free demo class and then decide.

Hadoop Training in Noida
Big Data Hadoop Training in Noida

ciit noida said...

HADOOP TRAINING INSTITUTE IN NOIDA

CIITN provides Big data hadoop training in Noida in Noida as per the current industry standards. Our training programs will enable professionals to secure placements in MNCs. CIITN is one of the most recommended Hadoop Training Institute in Noida that offers hands on practical knowledge/practical implementation on live projects and will ensure the job with the help of advance level Hadoop Training Courses. At CIITN Hadoop Training in Noida is conducted by specialist working certified corporate professionals having 8+ years of experience in implementing real-time Hadoop projects.CIITN is the best Hadoop training center in Noida with a very high level infrastructure and laboratory facility. The most attractive thing is that candidates can opt multiple IT training course at Noida location. We feel proud by announce that CIITN prepares thousands of candidates for Hadoop training at sensible fees structure which is sufficient for best Hadoop training in Noida to attend the Hadoop classes.Hadoop training course includes “Knowledge by Experiments” strategy to get Hadoop training and performing real-time practices and real-time modulation. This extra ordinary practices with live environment experience in Hadoop Training certifies that you are ready to apply your Hadoop knowledge in big corporations after the Hadoop training in Noida completed.


Big data hadoop training in Noida

B-12, Sector - 2, Noida, U.P
State - Uttar Pradesh U.P
Country - India
Pin Code - 201301

Phone - +917290926565
Mon - Sun: 10am - 6pm