Home » Server Options » Data Guard » problem in opening standby database (10.2.0.1.0)
problem in opening standby database [message #328641] Sat, 21 June 2008 01:26 Go to next message
ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore
Member
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.

Re: problem in opening standby database [message #328661 is a reply to message #328641] Sat, 21 June 2008 05:05 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Please read below links before posting any query's

http://www.orafaq.com/forum/t/88153/0/


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


Database need more recovery I mean ARCHIVELOG file. You don't have sufficient ARCHIVELOG.

Babu
Re: problem in opening standby database [message #328668 is a reply to message #328661] Sat, 21 June 2008 08:52 Go to previous messageGo to next message
ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore
Member
I have checked archive log on primary and standby everything is ok.

Re: problem in opening standby database [message #328669 is a reply to message #328668] Sat, 21 June 2008 09:03 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
I have checked archive log on primary and standby everything is ok.


Can you teach me. How you checked archive log?

Babu
Re: problem in opening standby database [message #328963 is a reply to message #328669] Mon, 23 June 2008 10:12 Go to previous messageGo to next message
ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore
Member
I have checked archive log sequence using this command:

standby:

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination f:\oracle\standbyarch
Oldest online log sequence 29
Next log sequence to archive 0
Current log sequence 37
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'

primary:

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination f:\oracle\primaryarch
Oldest online log sequence 35
Next log sequence to archive 37
Current log sequence 37
SQL>
Re: problem in opening standby database [message #328972 is a reply to message #328963] Mon, 23 June 2008 10:34 Go to previous messageGo to next message
ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore
Member
[quote title=ranvijaidba wrote on Mon, 23 June 2008 20:42]I have checked archive log sequence using this command:

standby:


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

SQL>

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
SQL>
Re: problem in opening standby database [message #339545 is a reply to message #328972] Thu, 07 August 2008 16:55 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
In read only mode , redo logs are archived but are not applied

Do this

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

then

SQL> ALTER DATABASE OPEN READ ONLY;
Previous Topic: dbstart script for standby database
Next Topic: DGMGRL logon
Goto Forum:
  


Current Time: Mon Nov 04 06:31:12 CST 2024