This content has been marked as final. Show 9 replies
First, disable the Data Guard Broker fast_start failover (if you have it enabled).
Second, shutdown the primary database.
Third, reboot the primary database server.
That's all. The standbys will wait for the primary to come up again, no problem.
Edited by: JohnWatson on Apr 18, 2013 12:57 PM
I see that you do not have fast_start failover enabled, so no problem there.
I need to reboot my Primary DB Server.Hi,
How I must reboot my Primary Server correctly?
Do I need to shutdown my Physical and Logical Standby Servers till Primary Server be not available?
Do I need to do some things with Data Guard?
Please, I would want mini-instruction how I must do this correctly.
Thanks a Lot!
You can do following steps on primary.
DGMGRL> show configuration verbose;DGMGRL> edit database physical1 set state = 'APPLY-OFF'; DGMGRL> edit database physical2 set state = 'APPLY-OFF'; DGMGRL> shutdown immediate; DGMGRL> statup; DGMGRL> edit database physical1 set state = 'APPLY-ON'; DGMGRL> edit database physical2 set state = 'APPLY-ON'; Regards Mahir M. Quluzade http://www.mahir-quluzade.com
Configuration - work_DataGuardConfig
Protection Mode: MaxAvailability
primary - Primary database
physical1 - Physical standby database
physical2 - Physical standby database
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
Fast-Start Failover: DISABLED
thanks a lot for your answers. It helped me in the previous weekends!
And I have an other question about a Primary and Standby databases and Data Guard:
How to properly setup UTL_MAIL package in my configuration (Primary and Standby Servers), e.g.:
1. If I execute @$ORACLE_HOME/rdbms/admin/utlmail.sql on Primary, it will replicate to Standby?
2. If I execute alter system set smtp_out_server='smtp.server.local' scope=both, it will replicate to Standby?
Edited by: user12024575 on 23.04.2013 6:25