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