Re: Detecting Controlfile Type
Date: Tue, 10 Feb 2009 10:54:06 +0100
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
Cell +41 (0) 79 571 36 27
On Tue, Feb 10, 2009 at 10:43 AM, David Ballester <ballester.david_at_gmail.com
> 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...