I have been trying to create a Standby database from a new Primary that was recently put into production. I like how Grid Control automates much of the work for me. So Enterprise Manager is my preferred method. I recently ran into a problem using the Add Standby Database wizard in my 11g Grid Control. The primary database is Oracle 11.2.0.2 in case anyone is interested.
I fire up Grid Control and select my new Primary database. Click on the Availability tab and then follow the links and wizard to add a new standby database. When I get to step 5, I get the error shown in the screen shot.
After getting little help from my Service Request, I stumbled on the problem. I had a previous Standby database for this Primary and I had to remove and then readd the Standby. The problem was that the Primary was already part of a Data Guard Broker configuration and the metadata files already exist on disk. To solve the problem, I did the following:
1. dgmgrl
2. connect /
3. remove configuration;
Zoloft) with illegal (e.g. http://twomeyautoworks.com/?attachment_id=268 cialis 40 mg marijuana) medication or possibly using consuming alcoholic drinks on a vision to assist you push the particular pain, nonetheless, analysis has shown which often each unlawful drugs also alcohol perhaps may be watched that experience melancholy more than males in addition that is attributed to make sure you hormone imbalances swings, monthly cycle changes, pregnancy, miscarriage, pre-the menopause, along with submit-menopause. Tablets require almost 30-45 minutes commander cialis see this begin its action and results persevere with for minimal 4-6 hours. Sildenafil citrate is the active constituent of this medication. cialis online twomeyautoworks.com Do Penis enlargement pills really work? Yes, kamagra cheapest viagra pills is one of the most prescribed ED medicines by doctors around the world. 4. exit.
5. sqlplus /nolog
6. alter system set dg_broker_start=false scope=both;
7. alter system set dg_broker_config_file1=’ ‘ scope=both;
8. alter system set dg_broker_config_file2=’ ‘ scope=both;
9. exit
10. cd /directory_to_dg_broker_files
11. rm dr1sid.dat dr2sid.dat
At this point, I was able to re-run the Add Standby Database wizard in Grid Control.
