JAPANESE PICTURE DICTIONARY
Let's Learn Japanese picture dictionary là cuốn từ điển do nhà xuất bản McGraw-Hill ấn hành với khoảng 1500 từ tiếng Nhật thông dụng qua 32 chủ đề. Giới thiệu các từ vựng bằng hình ảnh, phiên âm, có giải nghĩa bằng tiếng Anh sẽ giúp người học tiếng Nhật dễ dàng ghi nhớ và phân biệt từ vựng. Với cuốn sách này, các bạn sẽ học từ vựng tiếng Nhật hết sức dễ dàng thông qua các hình ảnh sinh động
Link download : http://123link.pro/CkKelFu
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











