Re: Detecting Controlfile Type

From: Fuad Arshad <>
Date: Tue, 10 Feb 2009 07:23:45 -0800 (PST)
Message-ID: <>

in 10g this work with dg_brker =true since the broker configuration  knows what the standby state should be.

From: Stefan Knecht <>
Cc: oracle-l <>
Sent: Tuesday, February 10, 2009 3:54:06 AM
Subject: Re: Detecting Controlfile Type

Was that 11g ? 

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).



Stefan P Knecht
CEO & Founder

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27


On Tue, Feb 10, 2009 at 10:43 AM, David Ballester <> 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...


Received on Tue Feb 10 2009 - 09:23:45 CST

Original text of this message