JAKARTAPROJECT
JAKARTA TIPJSP TIPJSP Áú¹®&´äº¯DATABASE TIPJAVASCRIPT TIPWEBHACKING TIP±âŸ TIP
µ¥ÀÌÅͺ£À̽º ÆÁ
µ¥ÀÌÅͺ£À̽º ÆÁ
µ¥ÀÌÅͺ£À̽º ÆÁ °Ô½ÃÆÇ ÀÔ´Ï´Ù
¾ÆÄ«ÀÌºê ¼º´É Çâ»ó
GoodBug http://www.jakartaproject.com
À̹ÌÁö ½½¶óÀÌ´õ º¸±â

 

°³¿ä

·Î±× ½ºÀ§Ä¡°¡ ÀϾ¸é¼­ Çѱ׷쿡¼­ ´Ù¸¥ ±×·ìÀ¸·Î ÀüȯµÉ ¶§ DBWn ´Â üũÆ÷ÀÎÆ® ÇØ¾ß Çϸç,

ÇÑ ±×·ìÀº ¾ÆÄ«ÀÌºê µÇ¾î¾ß ÇÕ´Ï´Ù

LGWR°¡ ´Ù½Ã ·Î±× ½ºÀ§Ä¡ÀϾ ÇØ´çÆÄÀÏÀ» µ¤¾î¾²±â Àü¿¡ ¾ÆÄ«À̺갡 ¼öÇàµÉ ¼ö ÀÖµµ·Ï ½Ã°£Â÷¸¦ µÎ¾î¾ß ÇÕ´Ï´Ù

 

¾ÆÄ«ÀÌºê °ü·Ã µ¿Àûºä

-. v$archived_log

SQL>
SQL> select recid, name, blocks, first_time, completion_time
  2  from v$archived_log
  3  ;

     RECID  NAME                      BLOCKS FIRST_TIM COMPLETIO
---------- --------- ----------------------- --------- ----------
         1  /Archive/arch_1_1537.log     171 18-MAR-07 18-MAR-07

         2  /Archive/arch_1_1538.log       1 18-MAR-07 18-MAR-07

 

-. v$archive_dest

SQL>
SQL> select dest_id, dest_name, status, binding, name_space, schedule, destination, log_sequence
 2   from v$archive_dest;

 

DEST_ID DEST_NAME STATUS BINDING NAME_SPACE SCHEDULE DESTINATION LOG_SEQUENCE
-----------------------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID    MANDATORY SYSTEM ACTIVE    /Archive/ 5365
2 LOG_ARCHIVE_DEST_2 INACTIVE OPTIONAL  SYSTEM INACTIVE  0
3 LOG_ARCHIVE_DEST_3 INACTIVE OPTIONAL  SYSTEM INACTIVE  0
...

 

-. v$archive_processes

SQL>
SQL>
SQL> select *
  2  from v$archive_processes;

   PROCESS STATUS     LOG_SEQUENCE STAT
---------- ---------- ------------ ----
         0 ACTIVE                0 IDLE
         1 ACTIVE                0 IDLE
         2 STOPPED               0 IDLE
         3 STOPPED               0 IDLE
         4 STOPPED               0 IDLE
         5 STOPPED               0 IDLE
         6 STOPPED               0 IDLE
         7 STOPPED               0 IDLE
         8 STOPPED               0 IDLE
         9 STOPPED               0 IDLE

10 rows selected.

 

¼º´ÉÇâ»ó

-. ARCn ÇÁ·Î¼¼½º°¡ Àаí ÀÖ´Â µð½ºÅ©¿Í ´Ù¸¥ µð½ºÅ©¿¡ LGWR°¡ ¾²µµ·Ï ±¸¼º

-. ¾ÆÄ«À̺ê ÇÁ·Î¼¼½º ¼ö¸¦ Áõ°¡

    log_archive_max_processes ¼ö¸¦ ´Ã¸°´Ù

-. ¾ÆÄ«ÀÌºê ¼Óµµ º¯°æ

    log_archive_dest_n À» ¼³Á¤

    log_archive_dest_n ´Â ÀÌ ¼ö¸¦ ¸¹ÀÌ ´Ã¸®´Â°Íº¸´Ù ÀÌ ¼ö´Â Àû°ÔÇÏ°í µû·Î ¼öµ¿À¸·Î ¹Þ´Â°ÍÀÌ È¿À²¿¡ ÁÁÀ» ¼öµµ ÀÖ´Ù

SQL>
SQL>
SQL> show parameter log_archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string      /Archive/
log_archive_dest_1                   string
log_archive_dest_10                  string

...

log_archive_format                   string      arch_%t_%s.log
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     TRUE
log_archive_trace                    integer     0

    log_archive_dest_n(Enterprise Edition ¼³Ä¡ ÀÌ»ó)°ú log_archive_dest´Â µÑÁß Çϳª¸¸ »ç¿ëÇÒ ¼ö ÀÖ´Ù

 

2007-10-02 10:09:02
211.189.124.***

 

ÁÁÀº»ý°¢ ^^

0Á¡ (0¸í)
µ¡±Û 0°³ | ÅÂ±× 1°³ | °ü·Ã±Ûº¸±â
ű×ÀÔ·Â
½±Ç¥(,)±¸ºÐÀ¸·Î Çѹø¿¡ ¿©·¯ ű׸¦ ÀÔ·ÂÇÒ¼ö ÀÖ½À´Ï´Ù
archive (1)
À̸§ ºñ¹Ð¹øÈ£
µ¥ÀÌÅͺ£À̽º ÆÁ
µ¥ÀÌÅͺ£À̽º ÆÁ °Ô½ÃÆÇ ÀÔ´Ï´Ù
! ¹øÈ£ Á¦¸ñ ±Û¾´ÀÌ ÀÏÀÚ Á¶È¸
181 import DB ºÎºÐÀûÀÎ µ¥ÀÌÅÍ export / import ¹æ¹ý 2 kaiser 2008-12-29 7,795
180 NOT IN NOT EXISTS not in °ú not existsÀÇ °³³ä ÀÌÇØ 1 kaiser 2008-12-17 19,574
179 IP Á¢¼ÓÀÚ ¾ÆÀÌÇÇ º¸±â 1 GoodBug 2008-06-27 9,451
178 meta ¿À¶óŬ ½ºÅ°¸¶ ½ºÅ©¸³Æ® ¹Þ±â 1 GoodBug 2008-06-05 19,843
177 ORA-00054 ORA-00054: resource busy and acquire with NOWAIT specified 1 GoodBug 2007-10-27 13,058
176 ÇÑ±Û MYSQL ¼­¹ö ij¸¯¼ÂÀÌ EUCKRÀÌ ¾Æ´Ò°æ¿ì Ŭ¶óÀ̾ðÆ® ¼³Á¤ 1 GoodBug 2007-10-09 8,344
archive ¾ÆÄ«ÀÌºê ¼º´É Çâ»ó 1 GoodBug 2007-10-02 7,939
174 Dictionary Dict table 1 GoodBug 2007-10-02 7,224
173 ¿À¶óŬƩ´× redo log file ±¸¼º ¸ð´ÏÅÍ 1 GoodBug 2007-09-20 7,905
172 dictionary ÀÚÁÖ¾²´Â µñ¼Å³Ê¸® Á¤º¸ 1 1 GoodBug 2007-09-20 8,352
171 TableSpace Tablespace º° »ç¿ë·® È®ÀÎ 1 GoodBug 2007-09-20 8,766
170 ¿À¶óŬ üũÆ÷ÀÎÆ® °ü·Ã ÆĶó¹ÌÅÍ 2 GoodBug 2007-09-20 7,420
169 ¿À¶óŬƩ´× Å×ÀÌºí ½ºÄµ Åë°è 1 GoodBug 2007-09-19 7,265
168 ¿À¶óŬƩ´× v$filestat·Î µð½ºÅ© I/O ¸¦ È®ÀÎÇغ¸ÀÚ 1 GoodBug 2007-09-19 10,248
167 ¿À¶óŬƩ´× ORA-04031 ¿¡·¯ ´ëó¹ý ¹× ¿¹¹æ¹ý 1 GoodBug 2007-09-17 13,717
166 ¿À¶óŬƩ´× DB_FILE_MULTIBLOCK_READ_COUNT 1 GoodBug 2007-09-17 7,272
165 TableSpace TableSpace °ü¸® (Dictionary, Locally) 1 GoodBug 2007-09-16 7,774
164 ¿À¶óŬƩ´× ¹®Á¦ÇØ°á ¹× Æ©´× °ü·Ã ºä 2 GoodBug 2007-09-16 7,698
163 segment ¿À¶óŬ SEGMENT 1 GoodBug 2007-09-16 8,628
162 startup ¿À¶óŬ startup½Ã ´Ü°èº° ¿ÀÇ ÆÄÀÏ 1 GoodBug 2007-09-16 7,531
copyright 2005-2024 by Unicorn