askMLabs

SQL> select group#,thread#,MEMBERS,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS BYTES/1024/1024
---------- ---------- ---------- ---------------
         1          1          1              50
         2          1          1              50
         3          1          1              50
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/home/apps/oem12c/oradata/oem12c/redo03.log
/home/apps/oem12c/oradata/oem12c/redo02.log
/home/apps/oem12c/oradata/oem12c/redo01.log
SQL> alter database add logfile thread 1 group 4 ('/home/apps/oem12c/oradata/oem12c/redo04.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 5 ('/home/apps/oem12c/oradata/oem12c/redo05.log') size 300M;
Database altered.
SQL> alter database add logfile thread 1 group 6 ('/home/apps/oem12c/oradata/oem12c/redo06.log') size 300M;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         1          1          1 INACTIVE                      50
         2          1          1 CURRENT                       50
         3          1          1 INACTIVE                      50
         4          1          1 UNUSED                       300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
6 rows selected.
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system checkpoint;
System altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         2          1          1 INACTIVE                      50
         4          1          1 CURRENT                      300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
SQL> alter database drop logfile group 2;
Database altered.
SQL> select group#,thread#,MEMBERS,status,bytes/1024/1024 from v$log;
    GROUP#    THREAD#    MEMBERS STATUS           BYTES/1024/1024
---------- ---------- ---------- ---------------- ---------------
         4          1          1 CURRENT                      300
         5          1          1 UNUSED                       300
         6          1          1 UNUSED                       300
SQL> 

• We offer corporate trainings on oracle technologies in various formats. The biggest challenge in today's IT enabled industry is the lack of good technical skills and we fill the gap by providing technical skills to resources to meet the industry standard.


• We offer online trainings and virtual labs facility. You can attend the trainings at your convinience and practice the labs from your home. We provide virtual lab from our cloud setup.


• We offer the ready to use virtual machines as products. You can spend your time in practicing the technology rather than setting up the environment. All these virtual machines are provided at a very low cost. Please visit our site http://askmlabs.com/ for more information or contact us at info@askmlabs.com


• We offer PaaS and SaaS from our cloud setup. We will provide the IT infrastructure needs as per your requirements at a very low cost with high availability. Please visit our site http://askmlabs.com/ for more information or contact us at info@askmlabs.com