Database Administration (MOSC)

MOSC Banner

I keep having to recopy the pswd file to physical standby location and restart db.

edited Apr 10, 2017 1:23PM in Database Administration (MOSC) 14 commentsAnswered

We have many Oracle 11.2.0.3 and 11.2.0.4 physical standbys on a windows server env.

and once  a month we have a server outage time when we restart our db servers (primary database servers and standbys).

this is starting to be very very time consuming for me because for some reason the replication of the logs will not start again until I

cancel recovery from standby,

shutdown the physical standby db,

delete the standby password file,

copy the primary pswd file to the standby location then on standby,

startup nomount,

alter database mount standby,

then alter database recover managed standby database disconnect using current logfile;

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