OraFAQ Forum: Data Guard » problem in opening standby database

Home » Server Options » Data Guard » problem in opening standby database (10.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in opening standby database [message #328641]

Sat, 21 June 2008 01:26

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.

Report message to a moderator

Re: problem in opening standby database [message #328661 is a reply to message #328641]

Sat, 21 June 2008 05:05

babuknb
Messages: 1734
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

Report message to a moderator

Re: problem in opening standby database [message #328668 is a reply to message #328661]

Sat, 21 June 2008 08:52

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

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

Report message to a moderator

Re: problem in opening standby database [message #328669 is a reply to message #328668]

Sat, 21 June 2008 09:03

babuknb
Messages: 1734
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

Report message to a moderator

Re: problem in opening standby database [message #328963 is a reply to message #328669]

Mon, 23 June 2008 10:12

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>

Report message to a moderator

Re: problem in opening standby database [message #328972 is a reply to message #328963]

Mon, 23 June 2008 10:34

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>

Report message to a moderator

Re: problem in opening standby database [message #339545 is a reply to message #328972]

Thu, 07 August 2008 16:55

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;

Report message to a moderator

Previous Topic:	dbstart script for standby database
Next Topic:	DGMGRL logon

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 18 12:19:28 CDT 2022