Database - RAC/Scalability (MOSC)

MOSC Banner

Stop active standby database

edited Mar 6, 2018 3:33AM in Database - RAC/Scalability (MOSC) 8 commentsAnswered ✓

Dear Experts,

Due to some prophylactic works we have  to shutdown active standby database  for 5 hrs.

According to backup policy, applied archived logs are deleted every 30 min on primary side.

First question is that, how would be better to disable log shipping before standby database goes down?

stop log transport for primary database by running

DGMGRL> edit database 'DB_PRIMARY' set state='LOG-TRANSPORT-OFF';

or disable log apply for standby database by running

DGMGRL>  EDIT DATABASE 'DB_STANDBY' SET STATE='APPLY-OFF';

And second question is: Is there any chance that backup policy would delete archived lods while standby is down?

Standby database is in maximum performance mode and RMAN is configured as "ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center