Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Standby Recovery Fails With "ORA-00905: missing keyword"

1422807Dec 4 2014 — edited Jan 20 2015

Hi,

I'm trying to run a general/full database recovery of a standby using FROM 'location' coupled with DISCONNECT FROM SESSION and it fails:

ALTER DATABASE RECOVER AUTOMATIC FROM '/MYDB/forstandby' STANDBY DATABASE DISCONNECT FROM SESSION

*

ERROR at line 1:

ORA-00905: missing keyword

This statement works if I omit DISCONNECT FROM SESSION.  It appears that this feature only works with RECOVER MANAGED STANDBY.  For example:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

or

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

We use these last two examples for Data Guard.  I'm trying to run a manual recovery without tying up a terminal.  Does anyone know a solution to this problem?

Thanks,

Walter Nirenberg

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 17 2015
Added on Dec 4 2014
2 comments
788 views