Re: Detecting Controlfile Type

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




________________________________
From: Stefan Knecht <knecht.stefan_at_gmail.com>
To: ballester.david_at_gmail.com
Cc: oracle-l <oracle-l_at_freelists.org>
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).

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