OraFAQ Forum: Data Guard » standby not open in read only mode

Home » Server Options » Data Guard » standby not open in read only mode

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

standby not open in read only mode [message #320135]

Wed, 14 May 2008 03:05

malvika
Messages: 55
Registered: May 2008
Location: india

Member

SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG_PS/system01.dbf'

on EASTLEG database...........

>alter system switch logfile;

and again try on EASTLEG_PS

>alter database open read only;

but errr0rrrrrrrrrrr..........

[Updated on: Wed, 14 May 2008 03:16]

Report message to a moderator

Re: standby not open in read only mode [message #320194 is a reply to message #320135]

Wed, 14 May 2008 05:05

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You need to ensure the controlfile_change# of v$database is the same as the checkpoint_change# of v$datafile_header.

Try to issue recover database using backup controlfile until cancel; and apply any necessary logs; issue cancel when there is nothing else to apply. Then try to open read only.

Report message to a moderator

Re: standby not open in read only mode [message #320198 is a reply to message #320194]

Wed, 14 May 2008 05:11

malvika
Messages: 55
Registered: May 2008
Location: india

Member

SQL> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01666: controlfile is for a standby database

this error i get
what i can do next

Report message to a moderator

Re: standby not open in read only mode [message #320218 is a reply to message #320198]

Wed, 14 May 2008 05:56

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What do you get if you cancel media recovery, then shutdown the database and then go into READ ONLY via:

SQL> STARTUP NOMOUNT;
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER DATABASE OPEN READ ONLY;

Report message to a moderator

Re: standby not open in read only mode [message #320221 is a reply to message #320218]

Wed, 14 May 2008 06:02

malvika
Messages: 55
Registered: May 2008
Location: india

Member

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG_PS/system01.dbf'

SQL> recover database using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-01666: controlfile is for a standby database

SQL> recover standby database;
ORA-00279: change 114732 generated at 05/14/2008 14:14:45 needed for thread 1
ORA-00289: suggestion :
/u02/app/oracle/admin/EASTLEG_PS/arch/arch_EASTLEG_PS_5.log
ORA-00280: change 114732 for thread 1 is in sequence #5

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/u02/app/oracle/admin/EASTLEG_PS/arch/arch_EASTLEG_PS_5.log
ORA-00308: cannot open archived log
'/u02/app/oracle/admin/EASTLEG_PS/arch/arch_EASTLEG_PS_5.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'/u02/app/oracle/admin/EASTLEG_PS/arch/arch_EASTLEG_PS_5.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/u02/app/oracle/admin/EASTLEG_PS/arch/arch_EASTLEG_PS_5.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG_PS/system01.dbf'

[Updated on: Wed, 14 May 2008 06:05]

Report message to a moderator

Re: standby not open in read only mode [message #320954 is a reply to message #320221]

Fri, 16 May 2008 23:17

malvika
Messages: 55
Registered: May 2008
Location: india

Member

SQL> recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active

SQL> recover managed standby database;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG_PS/system01.dbf'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/newdata/app/oracle/oradata/EASTLEG_PS/system01.dbf'

Report message to a moderator

Re: standby not open in read only mode [message #328239 is a reply to message #320954]

Thu, 19 June 2008 08:14

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

Please Provide the solution because i am getting the same problem not able to open the standby database in read only mode

Report message to a moderator

Re: standby not open in read only mode [message #328285 is a reply to message #320135]

Thu, 19 June 2008 10:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

> i am getting the same problem
Same problem as what exactly

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Report message to a moderator

Re: standby not open in read only mode [message #328450 is a reply to message #328285]

Fri, 20 June 2008 04:14

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.

Report message to a moderator

Re: standby not open in read only mode [message #328566 is a reply to message #320135]

Fri, 20 June 2008 08:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ranvijaidba,
You insist on hijacking other's threads & reporting different symptoms.

http://www.orafaq.com/forum/m/328565/74940/#msg_328565

You're On Your Own (YOYO)!

[Updated on: Fri, 20 June 2008 08:43] by Moderator

Report message to a moderator

Re: standby not open in read only mode [message #328634 is a reply to message #328566]

Sat, 21 June 2008 00:47

ranvijaidba
Messages: 71
Registered: May 2008
Location: Bangalore

Member

I have used this thread because the same problem is adressed in this thread so thats why i used this thread.If you wamt to raised new thread then i do that.Sorry for that.

Report message to a moderator

Previous Topic:	failover steps when primary DB server problem occurs
Next Topic:	Problem with Dataguard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 22:49:19 CST 2024