Proble in opening standby database in read only mode
Database version 10.2.0.1.0
When i am trying to open the standby database in read only mode it is showing error:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 369098752 bytes
Fixed Size 1249056 bytes
Variable Size 113246432 bytes
Database Buffers 251658240 bytes
Redo Buffers 2945024 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'
When i am trying to recover standby database it showing error:
SQL> recover standby database
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'
There is no problem with archive log.Log are archived in both primary location and standby location.
The error shows that primary standby system file is locked by DBWR.but why it is checking primary database files.
