Business English Everywhere link http://123link.pro/F8wvTmS
Bridge to IELTS
Bridge to IELTS: đây là 1 bước đệm tốt để các bạn tự học ở nhà vừa cung cấp kiến thức mới và từ vựng cơ bản
http://123link.pro/lEjo
Resize redo log Oracle
Here is steps to resize redo log on Oracle Database
1.
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 79 50 2 CURRENT
2 1 77 50 2 INACTIVE
3 1 78 50 2 INACTIVE
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
1 /u01/app/oracle/oradata/TEST01/redo01.log
2 /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
2 /u01/app/oracle/oradata/TEST01/redo02.log
3 /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
3 /u01/app/oracle/oradata/TEST01/redo03.log
2.
SQL> alter database drop logfile group 2;
SQL> !rm /u01/app/oracle/oradata/TEST01/redo02.log
SQL> !rm /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 79 50 2 CURRENT
3 1 78 50 2 INACTIVE
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
1 /u01/app/oracle/oradata/TEST01/redo01.log
3 /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
3 /u01/app/oracle/oradata/TEST01/redo03.log
SQL> alter database add logfile group 2 (
'/u01/app/oracle/oradata/TEST01/redo02.log' ,
'/u01/app/oracle/fast_recovery_area/TEST01/redo02.log'
) size 100M;
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 79 50 2 CURRENT
2 1 0 100 2 UNUSED
3 1 78 50 2 INACTIVE
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
1 /u01/app/oracle/oradata/TEST01/redo01.log
2 /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
2 /u01/app/oracle/oradata/TEST01/redo02.log
3 /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
3 /u01/app/oracle/oradata/TEST01/redo03.log
3.
SQL> alter system archive log current;
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 79 50 2 ACTIVE
2 1 80 100 2 CURRENT
3 1 78 50 2 INACTIVE
SQL> alter system checkpoint;
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 79 50 2 INACTIVE
2 1 80 100 2 CURRENT
3 1 78 50 2 INACTIVE
GROUP#1
SQL> alter database drop logfile group 1;
SQL> !rm /u01/app/oracle/oradata/TEST01/redo01.log
SQL> !rm /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
2 1 80 100 2 CURRENT
3 1 78 50 2 INACTIVE
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
2 /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
2 /u01/app/oracle/oradata/TEST01/redo02.log
3 /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
3 /u01/app/oracle/oradata/TEST01/redo03.log
SQL> alter database add logfile group 1 (
'/u01/app/oracle/oradata/TEST01/redo01.log' ,
'/u01/app/oracle/fast_recovery_area/TEST01/redo01.log'
) size 100M;
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 0 100 2 UNUSED
2 1 80 100 2 CURRENT
3 1 78 50 2 INACTIVE
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
1 /u01/app/oracle/oradata/TEST01/redo01.log
2 /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
2 /u01/app/oracle/oradata/TEST01/redo02.log
3 /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
3 /u01/app/oracle/oradata/TEST01/redo03.log
GROUP#3
SQL> alter database drop logfile group 3;
!rm /u01/app/oracle/oradata/TEST01/redo03.log
!rm /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 0 100 2 UNUSED
2 1 80 100 2 CURRENT
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
1 /u01/app/oracle/oradata/TEST01/redo01.log
2 /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
2 /u01/app/oracle/oradata/TEST01/redo02.log
SQL> alter database add logfile group 3 (
'/u01/app/oracle/oradata/TEST01/redo03.log' ,
'/u01/app/oracle/fast_recovery_area/TEST01/redo03.log'
) size 100M;
SQL> select group#, thread#, sequence#, bytes/1024/1024 M_bytes, members, status
from v$log order by 1,2;
GROUP# THREAD# SEQUENCE# M_BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ---------- ---------------
1 1 0 100 2 UNUSED
2 1 80 100 2 CURRENT
3 1 0 100 2 UNUSED
SQL> select group#, member from v$logfile order by 1,2;
GROUP# MEMBER
---------- ------------------------------------------------------------
1 /u01/app/oracle/fast_recovery_area/TEST01/redo01.log
1 /u01/app/oracle/oradata/TEST01/redo01.log
2 /u01/app/oracle/fast_recovery_area/TEST01/redo02.log
2 /u01/app/oracle/oradata/TEST01/redo02.log
3 /u01/app/oracle/fast_recovery_area/TEST01/redo03.log
3 /u01/app/oracle/oradata/TEST01/redo03.log
