Home » Server Options » Data Guard » standby not open in read only mode
standby not open in read only mode [message #320135] Wed, 14 May 2008 03:05 Go to next message
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 Go to previous messageGo to next message
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.
Re: standby not open in read only mode [message #320198 is a reply to message #320194] Wed, 14 May 2008 05:11 Go to previous messageGo to next message
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
Re: standby not open in read only mode [message #320218 is a reply to message #320198] Wed, 14 May 2008 05:56 Go to previous messageGo to next message
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;
Re: standby not open in read only mode [message #320221 is a reply to message #320218] Wed, 14 May 2008 06:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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'

Re: standby not open in read only mode [message #328239 is a reply to message #320954] Thu, 19 June 2008 08:14 Go to previous messageGo to next message
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
Re: standby not open in read only mode [message #328285 is a reply to message #320135] Thu, 19 June 2008 10:48 Go to previous messageGo to next message
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



Re: standby not open in read only mode [message #328450 is a reply to message #328285] Fri, 20 June 2008 04:14 Go to previous messageGo 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.


Re: standby not open in read only mode [message #328566 is a reply to message #320135] Fri, 20 June 2008 08:42 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: failover steps when primary DB server problem occurs
Next Topic: Problem with Dataguard
Goto Forum:
  


Current Time: Thu Mar 28 18:18:33 CDT 2024