BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡

±Û¾´ÀÌ: À϶óŬ Archive log¿¡ ÀÇÇÑ Backup Á¶È¸¼ö: 7845



OS backupÀ̳ª exp À¸·Î ¹é¾÷À» ¹ÞÀº °æ¿ì¿¡ º¹±¸´Â backup¹ÞÀº ½ÃÁ¡
À¸·Î ¹Û¿¡ º¹±¸ ÇÒ¼ö ¾ø´Ù.
ÃÖ±Ù¿¡ Á¤º¸±îÁö À¯½ÇµÇÁö ¾ÊÀº »óÅ·Πº¹±¸ÇÏ·Á¸é ÁÖ±âÀûÀÎ OS ¹é¾÷°ú
ÇÔ²² archive log¸ðµå·Î µ¥ÀÌÅͺ£À̽º¸¦ ¿î¿µÇϸéµÈ´Ù.

Archive log ¿î¿µ¹æ¹ý

1.ÆĶó¸ÞÅÍ È­ÀÏ ¼öÁ¤
parameter file $ORACLE_HOME/dbs/initRUSH.ora

log_archive_start = true
log_archive_dest = /home/oracle/admin/RUSH/arch
log_archive_format = arch_%t_%s.arc

ù¶óÀÎ:Archive ¸ðµå Àüȯ
µÎ¹ø°¶óÀÎ:Archive log ÆÄÀϵéÀÌ ÀúÀåµÇ´Â À§Ä¡
¼¼¹ø°¶óÀÎ:·Î±×ÆÄÀϵéÀÇ ½×ÀÌ´Â Çü½ÄÁöÁ¤

2.ÆĶó¸ÞÅÍ È­ÀϼöÁ¤ÈÄ shutdown ÈÄ Àç½Ãµ¿ startup

SVRMGR> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> startup mount
ORACLE instance started.
Total System Global Area 420126880 bytes
Fixed Size 73888 bytes
Variable Size 340041728 bytes
Database Buffers 79839232 bytes
Redo Buffers 172032 bytes
Database mounted.
SVRMGR> alter database archivelog; <--¾ÆÄ«À̺ê¸ðµåÀο¡À̺í
Statement processed.
SVRMGR> alter database open; <--µ¥ÀÌŸº£À̽º¿ÀÇÂ
Statement processed.
SVRMGR> select log_mode from V$database; <--·Î±×¸ðµåÈ®ÀÎ
LOG_MODE
------------
ARCHIVELOG
1 row selected.
SVRMGR>

SVRMGR> alter system switch logfile; <--·Î±×½×ÀÌ°Ô ÇÔ
Statement processed.
SVRMGR>

(23)[stone]/home/oracle/admin/RUSH/arch > ls
arch_1_107.arc <-¾ÆÄ«À̺êÁ¤»óÀÛµ¿È®ÀÎ
(24)[stone]/home/oracle/admin/RUSH/arch >

¾ÆÄ«À̺êÆÄÀÏÀº °è¼Ó »ý¼ºÀ̵ǰԵǴµ¥ ÀÌ´Â OSµð½ºÅ©¸¦ ¸¹ÀÌ Â÷Áö ÇÏ°Ô
µÇ°í ¼ö¸¹Àº ¾ÆÄ«À̺êÆÄÀÏÀÌ »ý¼ºÀ̵Ǵµ¥ ÀÌ´Â º¹±¸½Ã°£ÀÌ ¸¹ÀÌ ¼ÒºñÇϰԵȴÙ.
±×·¯¹Ç·Î Archive log¸ðµå·Î ¿î¿µ½Ã Á¤±âÀûÀ¸·Î Äݵå¹é¾÷À» ÇÑÈÄ
¾ÆÄ«À̺êÆÄÀÏÀ» ÀüºÎ »èÁ¦ÇÑÈÄ ´Ù½Ã ¿À¶óŬÀ» Àç½Ãµ¿ÇؾßÇÑ´Ù.






°ü·Ã±Û : ¾øÀ½ ±Û¾´½Ã°£ : 2003/04/30 11:51 from 218.38.148.150

  [FAQ]linux(x86)¿ë ¿À¶óŬ -> ¼Ö¶ó¸®½º(x86)¿¡ ¼³Ä¡ ¸ñ·Ïº¸±â »õ±Û ¾²±â Áö¿ì±â ÀÀ´ä±Û ¾²±â ±Û ¼öÁ¤ ¿Â¶óÀλóÅ¿¡¼­ ¹é¾÷[export]  
BACKRUSH  À¯´Ð½º¸í·É  ´ÙÀ½  ÀÚ·á½Ç  Ascii Table   ¿ø°ÝÁ¢¼Ó  ´Þ·Â,½Ã°£   ÇÁ·Î¼¼½º   ½©
ÁöÇÏö³ë¼±   RFC¹®¼­   SUN FAQ   SUN FAQ1   C¸Þ´º¾ó   PHP¸Þ´º¾ó   ³Ê±¸¸®   ¾Æ½ºÅ°¿ùµå ¾ÆÀÌÇǼ­Ä¡