?
Solved

db

Posted on 2012-03-17
4
Medium Priority
?
268 Views
Last Modified: 2013-03-01
What we have to do if we want to cancel what we did?

Current log sequence           13
SQL> show parameter DG_BROKER_START;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dg_broker_start                      boolean     FALSE
SQL> alter system set DG_BROKER_START=true scope=both;


System altered.
0
Comment
Question by:b7dba
2 Comments
 
LVL 16

Accepted Solution

by:
Walter Ritzel earned 2000 total points
ID: 37733898
My understanding is that you need to run the command to put the value to the old one.
SQL> alter system set DG_BROKER_START=false scope=both;

Open in new window

0
 
LVL 16

Expert Comment

by:Wasim Akram Shaik
ID: 37734156
would agree with wpcortes,  alternatively, if you shutdown the db, the broker by default gets down...!!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: for this to work properly you need to use a Cross-Over network cable. 1. Connect both servers S1 and S2 on the second network slots respectively. Note that you can use the 1st slots but usually these would be occupied by the Service Provideā€¦
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month14 days, 7 hours left to enroll

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question