High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

ORA-01665 Transferring standbyctlfile.ctl to standby

The data guard processes are not running. I discovered that the primary and standby databases are out of sync.

Primary

THREAD#   SEQUENCE#   ARCHIVED    STATUS

1                 197                 NO                CURRENT

1                 194               YES                 INACTIVE

1                 195               YES                INACTIVE

1                 196               YES                INACTIVE

Secondary

THREAD#   SEQUENCE#   ARCHIVED    STATUS

1                 149                YES              INACTIVE

1                 150               NO                ICURRENT

1                 147               YES                INACTIVE

1                 148               YES                INACTIVE

I was on the standby and did an alter database recover managed standby database disconnect from session;

I got an ORA-01665: control file is not a standby control file

I googled and found on the primary do an alter database create standby controlfile as 'standbyctlfile.ctl';

So I performed that successfully.

The the instructions indicate to transfer the file to the standby. However, I grepped for the file and I can not locate it.

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