Home » Server Options » Data Guard » ORA-00274: illegal recovery option SESSION physical stdby db (Oracle version 10gr2, windows 32)
ORA-00274: illegal recovery option SESSION physical stdby db [message #506000] Fri, 06 May 2011 00:47 Go to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
Hi

oracle version: 10gr2
os:windows 32

I have configured a physical standby database.

I have set the physical standby database to open read mode for a short while.

according to http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1014482, in order to set db in for from open read-only to applying redo data

Quote:


To change the standby database from being open for read-only access to performing Redo Apply:

Terminate all active user sessions on the standby database.

Restart Redo Apply. To start Redo Apply, issue the following statement:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
2> DISCONNECT FROM SESSION;

To enable real-time apply, include the USING CURRENT LOGFILE clause:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
2> USING CURRENT LOGFILE;




this is what happen

SYS@ngdr> alter database recover managed standby database disconnect session;
alter database recover managed standby database disconnect session
*
ERROR at line 1:
ORA-00274: illegal recovery option SESSION


SYS@ngdr> alter database recover managed standby database using current logfile;



okay since I encountered the illegal recovery options session, I decided to use

alter database recover managed standby database using current logfile;


now the session seems to be hanging forever, is there a solution?

thanks a lot!
Re: ORA-00274: illegal recovery option SESSION physical stdby db [message #506034 is a reply to message #506000] Fri, 06 May 2011 04:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
alter database recover managed standby database disconnect session *
You've missed out one key word.
Re: ORA-00274: illegal recovery option SESSION physical stdby db [message #506132 is a reply to message #506034] Fri, 06 May 2011 11:09 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

yes.

it was

alter database recover managed standby database disconnect FROM session


Babu

[Updated on: Fri, 06 May 2011 11:10]

Report message to a moderator

Re: ORA-00274: illegal recovery option SESSION physical stdby db [message #506142 is a reply to message #506132] Fri, 06 May 2011 11:50 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good you are here to put the point on the "i".

Regards
Michel
Previous Topic: DG
Next Topic: client failure failover/switchover standby configuration
Goto Forum:
  


Current Time: Thu Mar 28 13:14:19 CDT 2024