Re: Oracle Dataguard issue
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: jack@xxxxxxxxxxxx
- Date: Thu, 13 May 2010 09:07:46 +0100
On Thu, May 13, 2010 at 2:14 AM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote:
>
...
> When we try to activate the standby database:
>
> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH (completes
> succesfully)
> Tried to activate Standby, gets error, ORA-01194, file needs recovery.
>
> We tried several things but other than making sure the standby controlfile
> is created after the end backup commands have been issued we have not been
> able to open this database up.
>
Hi,
If you use DATABASE FINISH your recovery process on standby has been stopped.
Did you try to start it again ?
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
or
RECOVER STANDBY DATABASE;
regards,
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
