ORA-01186, ORA-01122, ORA-01110, ORA-01209 when opening standby as Read Only
Recently a site experienced ORA-1209 errors when opening the standby database read-only. A call was logged with Oracle Support and a summary of the solution is provided below:
When you open a standby database as read only, you notice the following in the database alert log.
< ORA-01186: file 5 failed verification tests
< ORA-01122: database file 5 failed verification check
< ORA-01110: data file 5: '/u02/oracle/oradata/prod/data01.dbf'
< ORA-01209: data file is from before the last RESETLOGS
< File 5 not verified due to error ORA-01122
< ORA-16004 signalled during: alter database open read only...
After investigation the following was noted:
To resolve the ORA-01209 to allow you to open the standby database read-only, follow these steps:
On the Primary Database:
Example Steps on Primary Database:
sql> alter tablespace DATA read write;
sql> alter database datafile 5 offline;
sql> recover datafile 5;
sql> alter tablesapce DATA read only;
sql> alter system archive log current;
sql> alter system checkpoint;
Now run dbvisit on the Primary then Standby database.
You should now be able to open the standby database read only.
|"read only", ora-01110, ora-01122, ora-01186, ora-01209|
|Thread Tools||Search this Thread|