Re: standby database

From: Antoine BRUNEL <antoinebrunel/yahoo.fr>
Date: Sat, 26 Jul 2003 16:11:30 +0200
Message-ID: <3f228c12$0$11117$79c14f64@nan-newsreader-03.noos.net>

Hi from Paris

view V$DATABASE, column CONTROLFILE_TYPE:

      CONTROLFILE_TYPE
     VARCHAR2(7)
     The type of control file:

        a.. STANDBY indicates database is in standby mode.

        b.. CLONE indicates a clone database.

        c.. BACKUP | CREATED indicates database is being recovered using a

backup or created control file.

        d.. CURRENT: The control file changes to this type following a standby database activate or database open after recovery.

"freCho" <svenson1_at_libero.it> a écrit dans le message de news:pan.2003.07.25.10.10.22.514532_at_libero.it...
> I all,
> what I have to check to know if a oracle server was created as a standby
database?
> We have an 8.1.7 that do not appears to be a stanby database but when we
> change init.ora setting up archive log mode (uncommenting the interessed
> lines) we receive an error saying that the feature is not supported by
> stanby database. I have not the ORA -... error code and I cannot duplicate
the
> scenario (I cannot shutdown and restart the instance).
>
> Thanks
> S.
Received on Sat Jul 26 2003 - 09:11:30 CDT