| ORA-00274: illegal recovery option SESSION physical stdby db [message #506000] |
Fri, 06 May 2011 00:47  |
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!
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
