The “alter system flush redo” command, which is used to transfer operations in the redo log files in the primary database to the standby database during the failover process, will terminate with ORA-01105 error if the primary database is not in mount mode.
The error message will be as follows.
1 2 3 4 5 | SQL> alter system flush redo to 'ORCLDG'; alter system flush redo to 'ORCLDG' * ERROR at line 1: ORA-01105: mount is incompatible with mounts by other instances |
The primary database must be in mount mode for the flush redo operation. If you want to learn to “What is mount mode?”, you should read the following article.
“Oracle Database Startup and Shutdown Modes”
You can take your database into mount mode as follows.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | -bash-4.3$ srvctl stop database -d ORCL -bash-4.3$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 8 11:17:29 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 2.1379E+10 bytes Fixed Size 2255784 bytes Variable Size 1.2415E+10 bytes Database Buffers 8791261184 bytes Redo Buffers 170299392 bytes Database mounted. |
Then flush redo operation can be performed successfully.
1 2 3 | SQL> alter system flush redo to 'ORCLDG'; System altered. |