1

Topic: Standby database switchover_status == not allowed

Hello!
Created standby database means RMAN.
At performance

 duplicate target database for standby nofilenamecheck dorecover; 

the message on usage previous  was some times deduced:
[spoiler]

ORA-19505: failed to identify file "C:\APP\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\E6T9FDRS_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
failover to previous backup

[/spoiler]
Mounted a DB as standby, switchover_status == recovery needed:
[spoiler]

SQL> alter database mount standby database;
Database altered.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
RECOVERY NEEDED

[/spoiler]
Rolled RMAN th on standby all , restarted a copy, mounted in standby, switchover_status == not allowed
[spoiler]

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1570009088 bytes
Fixed Size 2253528 bytes
Variable Size 922750248 bytes
Database Buffers 637534208 bytes
Redo Buffers 7471104 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select recovery_mode from v$archive_dest_status;
RECOVERY_MODE
-----------------------
MANAGED
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
NOT ALLOWED
SQL> select max (sequence#) from v$log_history;
MAX (SEQUENCE#)
--------------
43009

[/spoiler]
On Primary:

SQL> select max (sequence#) from v$log_history;
MAX (SEQUENCE#)
--------------
43012

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production.
How to recover standby?

2

Re: Standby database switchover_status == not allowed

After assembling standby to try
[quote =] recover standby database until cancel

After   - to launch