Monday , September 25 2023

ORA-01105 error in alter system flush redo operation


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.

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.

Then flush redo operation can be performed successfully.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *