| |
 |
|
Oracle standby archive_lag_target tips
Server Tips by Burleson Consulting
February 5, 2008
|
Question: I have implemented Data Guard
successfully with the help of the people on this website! Thanks. I have set the
archive_lag_target = 600 (10 minutes) and everything seems fine, except I
get the follow error on the data guard screen in Grid Control.
ORA-16792: configuration property value is
inconsistent with database setting
It seems to function fine, but if I press the “Verify Configuration” button in
Grid Control on the Data Guard screen, it goes though the verification process,
sets the archive_lag_target to zero, and clears the ORA-16792 error. I
set the value like this.
alter system set archive_lag_target = 600;
I tried using this command
alter system set archive_lag_target = 600
scope=spfile;
and the message said “system altered” but the value was still zero. The
value also sets itself back to zero during a shutdown/restart when I do nightly
backups. What am I doing wrong? I used the alter system set
archive_lag_target = 600 scope=both; and it sets the value correctly, but it
still sets things back to Zero during a shutdown/startup and I'm still getting
the ORA-16792 error.
Answer: On the data guard verification wizard
in Grid control I found a Broker Managed option and a DB option for fixing the
problem. I'd been using the Broker option, so I used the other one which I
believe wrote the value to the init.ora file, and this seems to have fixed the
problem.
 |
If you like Oracle tuning, you
might enjoy my book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get instant
access to the code depot of Oracle tuning scripts. |
 |
|
Need Oracle training?
- Get Oracle training from a practicing Oracle
expert
- Get custom training designed to
fit your needs
- Conveniently offered at your
workplace, anywhere in the USA
BC Oracle training offers some of the
USA's most respected Oracle experts and authors. Why spend
thousands on cookie cutter Oracle classes when you can have the
personalized attention of a real Oracle
guru? Just call now: |
|
|
