Solved

db

Posted on 2012-03-17
4
254 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 16

Accepted Solution

by:
Walter Ritzel earned 500 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

Containers and Docker for Everyone

Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

724 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