_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 襴襦蠏誤殊伎
Describe 襴襦蠏誤殊伎 here
SQL> -- 襴襦蠏 殊 伎 
SQL> set linesize 150 pagesize 999
SQL> connect internal
郁屋給.
SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TI
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------
         1          1        658    1048576          1 NO  INACTIVE                472248 03/10/30
         2          1        659    1048576          1 NO  CURRENT                 472305 03/10/30
         3          1        657    1048576          1 NO  INACTIVE                452040 03/10/24

SQL> select 1024*1024 from dual;

 1024*1024
----------
   1048576

SQL> -- 1MB ″  蟆 覲伎碁.... 蟆 ′ ..
SQL> select * from tab
  2  where tname like '%FILE%';

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
C_FILE#_BLOCK#                 CLUSTER
DBA_DATA_FILES                 VIEW
DBA_EXP_FILES                  VIEW
DBA_PROFILES                   VIEW
DBA_TEMP_FILES                 VIEW
FILE$                          TABLE
FILEXT$                        VIEW
GV_$BACKUP_DATAFILE            VIEW
GV_$CONTROLFILE                VIEW
GV_$CONTROLFILE_RECORD_SECTION VIEW
GV_$DATAFILE                   VIEW
GV_$DATAFILE_COPY              VIEW
GV_$DATAFILE_HEADER            VIEW
GV_$DBFILE                     VIEW
GV_$FILESTAT                   VIEW
GV_$FILE_PING                  VIEW
GV_$LOGFILE                    VIEW
GV_$PROXY_DATAFILE             VIEW
GV_$PWFILE_USERS               VIEW
GV_$RECOVERY_FILE_STATUS       VIEW
GV_$RECOVER_FILE               VIEW
GV_$TEMPFILE                   VIEW
LOADER_FILE_TS                 VIEW
PROFILE$                       TABLE
SYSFILES                       VIEW
V_$BACKUP_DATAFILE             VIEW
V_$CONTROLFILE                 VIEW
V_$CONTROLFILE_RECORD_SECTION  VIEW
V_$DATAFILE                    VIEW
V_$DATAFILE_COPY               VIEW
V_$DATAFILE_HEADER             VIEW
V_$DBFILE                      VIEW
V_$FILESTAT                    VIEW
V_$FILE_PING                   VIEW
V_$LOGFILE                     VIEW
V_$PROXY_DATAFILE              VIEW
V_$PWFILE_USERS                VIEW
V_$RECOVERY_FILE_STATUS        VIEW
V_$RECOVER_FILE                VIEW
V_$TEMPFILE                    VIEW

40 螳  給.

SQL> select * from v$logfile;

    GROUP# STATUS  MEMBER
---------- ------- -----------------------------------
         1 STALE   E:\ORACLE\ORADATA\ORA816\REDO03.LOG
         3 STALE   E:\ORACLE\ORADATA\ORA816\REDO01.LOG
         2         E:\ORACLE\ORADATA\ORA816\REDO02.LOG
SQL> -- 蠍一 螳 ろ 讌襷 れ襦 覿磯伎 . 
SQL> --   襦蠏 殊 覃伎 螻 り 覲企 螻, 蠏碁9朱 り
SQL> -- 螳伎 . 
SQL> -- 襦蠏  蠏碁9 豢螳
SQL> alter database add logfile group 4
  2  ('E:\ORACLE\ORADATA\ORA816\REDO04.LOG') size 1M;

一危覯伎り 覲蟆暑給.

SQL> -- れ螻 螳 螳襯 襷企蟾讌 螳 豢螳  . 
SQL> alter database add logfile group 5
  2  ('E:\ORACLE\ORADATA\ORA816\REDO05.LOG',
  3   'E:\ORACLE\ORADATA\ORA816\REDO05_2.LOG') size 1M;

一危覯伎り 覲蟆暑給.

SQL> --襷企襷 豢螳
SQL> --襷企 size れ . 覃 襷企朱Μ  蠍郁 螳 伎螳   蠍 覓語企.
SQL> alter database add logfile member 'E:\ORACLE\ORADATA\ORA816\REDO01_2.LOG'
  2  to group 1;

一危覯伎り 覲蟆暑給.

SQL> alter database add logfile member 'E:\ORACLE\ORADATA\ORA816\REDO02_2.LOG'
  2  to group 2;

一危覯伎り 覲蟆暑給.

SQL> alter database add logfile member 'E:\ORACLE\ORADATA\ORA816\REDO03_2.LOG'
  2  to group 3;

一危覯伎り 覲蟆暑給.

SQL> alter database add logfile member 'E:\ORACLE\ORADATA\ORA816\REDO04_2.LOG'
  2  to group 4;

一危覯伎り 覲蟆暑給.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TI
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------
         1          1        658    1048576          2 NO  INACTIVE                472248 03/10/30
         2          1        659    1048576          2 NO  CURRENT                 472305 03/10/30
         3          1        657    1048576          2 NO  INACTIVE                452040 03/10/24
         4          1          0    1048576          2 YES UNUSED                       0
         5          1          0    1048576          2 YES UNUSED                       0

SQL> col group# format 999
SQL> col status format a20
SQL> col member format a50
SQL> select * from v$logfile;

GROUP# STATUS               MEMBER
------ -------------------- --------------------------------------------------
     1 STALE                E:\ORACLE\ORADATA\ORA816\REDO03.LOG
     3 STALE                E:\ORACLE\ORADATA\ORA816\REDO01.LOG
     2                      E:\ORACLE\ORADATA\ORA816\REDO02.LOG
     4                      E:\ORACLE\ORADATA\ORA816\REDO04.LOG
     5                      E:\ORACLE\ORADATA\ORA816\REDO05.LOG
     5                      E:\ORACLE\ORADATA\ORA816\REDO05_2.LOG
     1 INVALID              E:\ORACLE\ORADATA\ORA816\REDO01_2.LOG
     2 INVALID              E:\ORACLE\ORADATA\ORA816\REDO02_2.LOG
     3 INVALID              E:\ORACLE\ORADATA\ORA816\REDO03_2.LOG
     4 INVALID              E:\ORACLE\ORADATA\ORA816\REDO04_2.LOG

10 螳  給.

SQL> 

襴襦蠏 殊 襦 るジ ろ 覿 る 蟆 譯 譴. 覃 襦 LGWR螳
郁鍵 覓語 蟆渚 譴企 蟆 譴螻, 襦蠏 郁鍵朱 DBMS  殊 觜れ 
レ 豕   蠍 覓語企. 

襴襦蠏 殊 伎 焔伎  譯朱 讌襷  れ旧   襦蠏碁ゼ 郁鍵
伎 LGWR 襦語る  伎 狩伎  蟆企. 讀, CPU螳  螻  蟆企朱 襴.          



蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

企れ 蟆語. 伎 . ル 螻旧. 伎 譴.