Saturday, February 8, 2014

standby logfile groups on SE

not sure what I will be able to do with it but just saw that on SE 12c.


BANNER       CON_ID
-------------------------------------------------- ----------
Oracle Database 12c Release 12.1.0.1.0 - 64bit Pro     0
duction

PL/SQL Release 12.1.0.1.0 - Production     0
CORE 12.1.0.1.0 Production     0
TNS for Linux: Version 12.1.0.1.0 - Production     0

NLSRTL Version 12.1.0.1.0 - Production     0


you can add standby logfile groups


SQL> alter database add standby logfile group 101 ;




SQL> select group#,thread#,sequence#,bytes/1024/1024 from v$standby_log;

    GROUP#    THREAD#  SEQUENCE# BYTES/1024/1024
---------- ---------- ---------- ---------------
       100     0       0     100
       101     0       0     100


not sure what you can do with it anyway as data guard is not possible on SE

Not sure if this was already possible on versions prior to 12c? 

No comments: