Re: Detecting Controlfile Type

They changed the default behaviour. An 11g database may open read only automatically, and turn on log-apply thereafter if you issue "STARTUP". Kinda naughty by Oracle me thinks, as this functionality requries additional licensing (active data guard option).

Cheers

Stefan

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

On Tue, Feb 10, 2009 at 10:43 AM, David Ballester <ballester.david_at_gmail.com
> wrote:

> El mar, 10-02-2009 a las 10:24 +0100, Stefan Knecht escribió:
> > I believe that feature was introduced with 10g, that Oracle
> > automatically detects wether it's a standby controlfile or not, and
> > mounts it accordingly after a standard "ALTER DATABASE MOUNT;"
> >
> > Cheers
> >
> > Stefan
>
>
> Well who knows if it's a bug, but yesterday due a mistake I executed
> 'startup' in a standby database ( synchronized via logwriter async ) and
> the startup process mounted it and opened it (?)
>
> Without executing nothing more, I did shutdown immediate and
>
> startup nomount;
> alter database mount standby database;
> recover managed standby database disconnect from session;
>
>
> And was applying archives and redo log syncing happily...
>
>
>
> D.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l