Warning in displaying configuration
parameters for Datagaurd Broker with ”ORA-16608”
PRIMARY DB (192.168.1.11)
[oraerp@rac1 dbs]$ dgmgrl
DGMGRL for Linux:
Version 11.1.0.7.0 - 64bit Production
Copyright (c) 2000,
2005, Oracle. All rights reserved.
Welcome to DGMGRL,
type "help" for information.
DGMGRL> connect
sl/sk
Connected.
DGMGRL> show
configuration
Configuration
Name: dell
Enabled: YES
Protection Mode: MaxPerformance
Databases:
dell_live - Primary database
dell_stby - Physical standby database
Fast-Start Failover:
DISABLED
Current status for
"dell":
Warning: ORA-16608: one or
more databases have warnings
DGMGRL>
SOLUTION:
|
STANDBY DB (192.168.1.12)
Restart the STANDBY DATABSE RECOVERY MODE with the following Sytntax.
[oraerp@rac2 dbs]$ sqlplus / as
sysdba
SQL*Plus: Release
11.1.0.7.0 - Production on Wed Apr 5 09:02:27 2017
Copyright (c) 1982,
2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g
Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning,
OLAP, Data Mining and Real Application Testing options
SQL>
SQL> alter
database recover managed standby database cancel;
Database altered.
SQL> ALTER
DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM
SESSION;
Database altered.
SQL>
PRIMARY DB (192.168.1.11)
DGMGRL> show
configuration
Configuration
Name: dell
Enabled: YES
Protection Mode: MaxPerformance
Databases:
dell_live - Primary database
dell_stby - Physical standby database
Fast-Start Failover:
DISABLED
Current status for
"dell":
SUCCESS
DGMGRL>
Thanks for Reading.
Regards,
Mohammed Areefuddin.
Suggested Topics :
Linux
|
DATABASE
|
RMAN
|
RAC
|
EBS
|
EBS DataGuard
| ||||
No comments:
Post a Comment