-
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.
-
1. Recreate the standby control file from the primary database.
2. Shutdown the Standby database.
3. Transfer the new standby control and mount the standby database with new control file.
4. recover standby database.
5. open in READ ONLY.
-
I have done this but again it is showing the same 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> recover standby database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PRIMARY\SYSTEM01.DBF'
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination f:\oracle\standbyarch
Oldest online log sequence 38
Next log sequence to archive 40
Current log sequence 40
On primary the log sequence is:
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination f:\oracle\primaryarch
Oldest online log sequence 39
Next log sequence to archive 41
Current log sequence 41
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|