Ora-00257 when standby databse server faliled
edited Jan 20, 2012 5:39AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 2 commentsAnswered
Hello,
When connecting to a primary database and the standby database is out of order, we got error ora-00257 and no more activity is possible on the primary database. Our environment is quite simple:
• 1 Site is running the primary database in RAC (2 nodes)
• 1 site is running the standby database in RAC (1 single node)
The server running the standby database failed (hardware problem) and sometimes later (in our specific case is was 4 hours) it was no possible to connect to the database (ora-00257 ). Looking at the alertlog file, I saw that all online redo log files were used. As the standby database was not available, it was not possible to release this situation.
0