ORA-01665 Transferring standbyctlfile.ctl to standby
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.