|
|
[ÀϹÝ] ¿À¶óŬ ¹é¾÷ ¹æ¹ý ( cold ¹é¾÷, hot¹é¾÷, export ¹é¾÷ ) |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:3457 |
|
|
¿À¶óŬ ¹é¾÷¿¡´Â Å©°Ô ÇÇÁöÄà ¹é¾÷(Physical Backup) ¹æ½Ä°ú ·ÎÁöÄà ¹é¾÷(Logical Backup) ¹æ½ÄÀÌ ÀÖ´Ù.
ÇÇÁöÄà ¹é¾÷ ¹æ½ÄÀ̶õ µ¥ÀÌŸ ÆÄÀÏ ÀÚü¸¦ Ä«ÇÇÇÏ´Â ¹æ½ÄÀ» ¸»Çϴµ¥, ÀÌ°ÍÀº ´Ù½Ã µ¥ÀÌŸº£À̽º¸¦ ¼Ë´Ù¿îÇÏ°í ¹é¾÷ÇÏ´Â ¹æ½Ä°ú ¿ÀÇÂµÈ »óÅ¿¡¼ ¹é¾÷ÇÏ´Â ¹æ½ÄÀ¸·Î ³ª´¶´Ù. ¹Ý¸é, ·ÎÁöÄà ¹é¾÷ ¹æ½ÄÀ̶õ ¿À¶óŬ¿¡¼ Á¦°øÇÏ´Â À¯Æ¿¸®Æ¼ ÁßÀÇ ÇϳªÀÎ Export/Import¸¦ ÀÌ¿ëÇÏ¿© ¹é¾÷ÇÏ´Â Çü½ÄÀ¸·Î, ÀÌ ¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÏ¿© ¸®Ä¿¹ö¸®¸¦ ½ÇÇàÇϸé Create Object ¹®ÀåÀ» ÀÌ¿ëÇØ Å×ÀÌºí½ºÆäÀ̽º¿Í À¯Àú, Å×À̺íÀ» »ý¼ºÇÏ°í, Insert Statement¸¦ ÀÌ¿ëÇØ Æ¯Á¤ Å×ÀÌºí¿¡ Insert ÀÛ¾÷ÀÌ ÀÌ·ç¾îÁö±â ¶§¹®¿¡ ÀÌó·³ ÀÏÄ´ °ÍÀÌ´Ù.
¸ÕÀú À̵鿡 ´ëÇØ °¢°¢ ¾Ë¾Æº¸°í, µ¥ÀÌŸ º¹±¸(Recovery)¸¦ À§ÇÑ ±âº» °³³äµéÀ» ´Ù·ç°íÀÚ ÇÑ´Ù. ±×¸®°í ¸®Ä¿¹ö¸®¿¡ ´ëÇÑ ´õ ±¸Ã¼ÀûÀÎ ¼³¸íÀº ´ÙÀ½ È£¿¡¼ ´Ù·ê ¿¹Á¤ÀÌ´Ù.
Cold Backup ¹Þ´Â ¹æ¹ý
ÄÝµå ¹é¾÷(Cold Backup)Àº µ¥ÀÌŸº£À̽º°¡ Á¤»óÀûÀ¸·Î ¼Ë´Ù¿îµÈ »óÅ¿¡¼ µ¥ÀÌŸ ÆÄÀÏ, ·Î±× ÆÄÀÏ, ÄÜÆ®·Ñ ÆÄÀÏÀ» ¸ðµÎ ¹é¾÷ ¹Þ´Â °ÍÀ» ¸»ÇÑ´Ù. ¼Ë´Ù¿îÇÏÁö ¾Ê°í ¿ÀÇÂµÈ »óÅ¿¡¼ ¹é¾÷À» ¹ÞÀ¸¸é ¹é¾÷ ¹ÞÀº ³»¿ëÀ» ³ªÁß¿¡ »ç¿ëÇÒ ¼ö°¡ ¾øÀ¸¹Ç·Î À¯ÀÇÇØ¾ß ÇÑ´Ù.
ÄÝµå ¹é¾÷À» À§Çؼ µ¥ÀÌŸº£À̽º¸¦ ¼Ë´Ù¿îÇÒ ¶§¿¡´Â Normal ¶Ç´Â Immediate ¿É¼ÇÀ» »ç¿ëÇØ¾ß Çϸç, Abort¸¦ »ç¿ëÇؼ´Â ¾È µÈ´Ù. »óȲÀÌ ¿©ÀÇÄ¡ ¾Ê¾Æ Abort¸¦ »ç¿ëÇÑ °æ¿ì¿¡´Â ¼Ë´Ù¿î ÈÄ¿¡ ´Ù½Ã ½ºÅ¸Æ®¾÷ÇÏ°í Normal·Î ¼Ë´Ù¿îÇÑ ÈÄ ¹é¾÷À» ¹Þµµ·Ï ÇÑ´Ù.
¿ì¼± À̵é ÆÄÀÏÀ» ¹é¾÷Çϱâ À§ÇØ ÄÜÆ®·Ñ ÆÄÀÏ°ú µ¥ÀÌŸ ÆÄÀÏ ¹× ·Î±× ÆÄÀÏÀÇ À§Ä¡¸¦ È®ÀÎÇÏ¿© À̵éÀ» tar, cpio, dd µîÀÇ ¸í·ÉÀ» ÀÌ¿ëÇÏ¿© ¹é¾÷ ¹Þµµ·Ï ÇÑ´Ù. NT¿¡¼´Â Copy ¸í·ÉÀ̳ª Ž»ö±â¸¦ ÀÌ¿ëÇؼ ¹é¾÷À» ¹ÞÀ¸¸é µÈ´Ù.
¡á ÄÜÆ®·Ñ ÆÄÀÏ È®ÀÎ ¹æ¹ý
sqlplus¿¡ system/manager·Î Á¢¼Ó ÈÄ
SQL>select value from v$controlfile;
¡á µ¥ÀÌŸ ÆÄÀÏ È®ÀÎ ¹æ¹ý
SQL>select name from v$datafile;
¡á ·Î±× ÆÄÀÏ È®ÀÎ ¹æ¹ý
SQL>select member from v$logfile;
ÀÌó·³ °¢°¢ÀÇ ÆÄÀÏ À§Ä¡¸¦ È®ÀÎÇÏ¿© À§¿¡¼ È®ÀÎµÈ 3Á¾·ùÀÇ ÆÄÀϵéÀ» ¹é¾÷ ¹ÞÀ¸¸é µÈ´Ù. À̶§ ¿À¶óŬÀº ¹Ýµå½Ã ¼Ë´Ù¿îµÈ »óÅÂÀ̾î¾ß ÇÑ´Ù. Ç×»óÀº ¾Æ´ÏÁö¸¸ ÇÊ¿ä¿¡ µû¶ó¼´Â Æз¯¹ÌÅÍ ÆÄÀϱîÁö ¹Þ¾ÆµÎ´Â °ÍÀÌ ÁÁ´Ù. Æз¯¹ÌÅÍ ÆÄÀÏÀº $ORACLE_HOME/dbs/init.ora¿¡ Àִµ¥, ÀÌ ÃʱâÈ Æз¯¹ÌÅÍ ÆÄÀÏ¿¡ ±â¼úµÇ¾îÁø Æз¯¹ÌÅÍ´Â ½Ã½ºÅÛÀÇ ¼º´É¿¡ ÁÖ¿äÇÑ ¿ªÇÒÀ» ÇϹǷΠÀÌ ÆÄÀÏÀÌ ¾ø¾îÁø °æ¿ì¿¡ ¿¹ÀüÀÇ ¼º´ÉÀ» À¯ÁöÇÏ·Á¸é ÀÌ ÆÄÀÏÀ» ÇʼöÀûÀ¸·Î ¹é¾÷ÇØ¾ß ÇÑ´Ù.
NT¿¡¼´Â C:\ORANT\DATABASE\init.ora ÆÄÀÏÀÌ´Ù.
ÀϹÝÀûÀ¸·Î NTÀÇ SID°¡ óÀ½ ¸¸µé¾îÁú ¶§ ORCLÀ̹ǷΠÀÌ Ãʱâ Æз¯¹ÌÅÍ ÆÄÀÏ ¿ª½Ã initORCL.ora¶ó°í µÇ¾î ÀÖ´Ù.
¿©±â¼ ´Â ¿À¶óŬ ÀνºÅϽº À̸§À¸·Î ȯ°æº¯¼ö ORACLE_SID·Î ÁöÁ¤µÇ¾î ÀÖ´Ù. ÀÌ ORACLE_SID´Â UnixÀÇ °æ¿ì $env, NTÀÇ °æ¿ì´Â Registry¿¡ ÁöÁ¤µÇ¾î ÀÖÀ¸¹Ç·Î Á÷Á¢ È®ÀÎÇØ º¼ ¼ö ÀÖ´Ù.
Hot Backup ¹Þ´Â ¹æ¹ý
ÇÖ ¹é¾÷(Hot Backup)À̶õ µ¥ÀÌŸº£À̽º¸¦ ¼Ë´Ù¿îÇÏÁö ¾Ê°í ¹é¾÷ÇÏ´Â ¹æ½ÄÀ¸·Î, ÀϹÝÀûÀÎ °æ¿ì´Â Àû¿ëµÇÁö ¾Ê°í ÀÚ½ÅÀÇ µ¥ÀÌŸº£À̽º¸¦ Archive Mode·Î ¿î¿µÇÏ´Â °æ¿ì¿¡¸¸ °¡´ÉÇÏ´Ù. ÄÝµå ¹é¾÷À» ÀÌ¿ëÇÏ¿© µ¥ÀÌŸ¸¦ º¹±¸ÇÏ´Â °æ¿ì¿¡´Â ÄÝµå ¹é¾÷À» ¹ÞÀº ½ÃÁ¡±îÁö¸¸ º¹±¸°¡ °¡´ÉÇÑ µ¥ ¹ÝÇØ, ÀÌ Archive ¹æ½ÄÀ¸·Î µ¥ÀÌŸº£À̽º¸¦ ¿î¿µÇÏ´Â °æ¿ì¿¡´Â »ç¿ëÀÚ°¡ ¿øÇÏ´Â ½ÃÁ¡±îÁö µ¥ÀÌŸ¸¦ º¹±¸ÇÒ ¼ö ÀÖ´Ù. Áï, ¿øÇÏ´Â ½Ã°£À» ÁÖ¾î¼, SCN ¹øÈ£¸¦ ÁÖ¾î¼, ȤÀº ¾î´À µ¥ÀÌŸ ÆÄÀÏ ÇÑ °³¸¸ÀÇ º¹±¸µµ °¡´ÉÇÏ´Ù.
µ¥ÀÌŸ º¹±¸¸¸ »ý°¢ÇÑ´Ù¸é ¸ðµç µ¥ÀÌŸº£À̽º¸¦ Archive ¹æ½ÄÀ¸·Î ¿î¿µÇÏ´Â °ÍÀÌ ÁÁ°ÚÁö¸¸, ÀÌ ¹æ½ÄÀ» »ç¿ëÇÏ´Â °æ¿ì µ¥ÀÌŸº£À̽º °ü¸®ÀÚ°¡ ¹é¾÷/¸®Ä¿¹ö¸®¿¡ °üÇÏ¿© ¸¹Àº Áö½Ä°ú °æÇèÀ» °®Ãç¾ß Çϸç, ¶Ç Archive Log¸¦ °è¼Ó À¯Áö°ü¸®ÇÏ´Â µ¥´Â ½ºÆäÀ̽º¿Í ¼º´ÉÀÇ ºÎÇÏ°¡ µû¸£±â ¶§¹®¿¡ »ç¿ëÀÚÀÇ ÀûÀýÇÑ ÆÇ´Ü¿¡ ÀÇÇÏ¿© ÀÌ¿ëÇϵµ·Ï ÇÑ´Ù.
±×·¯¸é Archive Log ModeÀÇ ¿î¿µ ¹æ¹ý¿¡ ´ëÇØ ¾Ë¾Æº¸ÀÚ.
Archive Log Mode ¿î¿µ ¹æ¹ý
¿À¶óŬ¿¡¼ µ¥ÀÌŸº£À̽º°¡ ¼Ë´Ù¿îµÇÁö ¾ÊÀº »óÅ¿¡¼ ¹é¾÷À» ¹Þ°Å³ª ¹®Á¦°¡ »ý±ä ½ÃÁ¡±îÁöÀÇ ¿Ïº®ÇÑ ¸®Ä¿¹ö¸® ÀÛ¾÷À» ¼öÇàÇϱâ À§Çؼ´Â µ¥ÀÌŸº£À̽º¸¦ ¾ÆÄ«ÀÌºê ·Î±× ¸ðµå·Î ¿î¿µÇÏ¿©¾ß ÇÑ´Ù.
¾ÆÄ«ÀÌºê ·Î±× ¸ðµå·Î ¿î¿µÇϱâ À§Çؼ´Â ´ÙÀ½ÀÇ ÀýÂ÷¿¡ µû¶ó º¯°æÇÏ¿©¾ß ÇÑ´Ù.
1. initSID.ora ÆÄÀÏ°ú configSID.ora¿¡ ´ÙÀ½ÀÇ Æз¯¹ÌÅÍ°¡ ÀÌ¹Ì ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎÇÑ ÈÄ¿¡ ¾øÀ» °æ¿ì initSID.ora¿¡ ¼³Á¤ÇÑ´Ù.
(1) LOG_ARCHIVE_START = TRUE
ÀÌ Æз¯¹ÌÅÍ¿¡ ÀÇÇØ µ¥ÀÌŸº£À̽º°¡ óÀ½ ±¸µ¿½Ã ARCH ÇÁ·Î¼¼½º°¡ ±âµ¿.
Log Switch ¹ß»ý½Ã Automatic Archive¸¦ ¼öÇàÇÑ´Ù.
¸¸¾à ÀÌ Æз¯¹ÌÅÍ°¡ FalseÀ̸é Manual Archive¸¦ ¼öÇàÇÑ´Ù.
(2)LOG_ARCHIVE_DEST =/home/oracle8/dbs/archive_file/arc
¾ÆÄ«À̺ê ÆÄÀÏÀÌ »ý¼ºµÇ´Â À§Ä¡ÀÎ µð·ºÅ丮¿Í È®ÀåÀÚ¸¦ Æ÷ÇÔÇÏÁö ¾Ê´Â ÆÄÀϸíÀ» ÁöÁ¤.
¿©±â¿¡¼ archive_file±îÁö´Â µð·ºÅ丮ÀÌ¸ç ¸¶Áö¸·¿¡ ÀÖ´Â arc´Â ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏ À̸§ÀÇ Ã¹ ºÎºÐÀÌ´Ù.
ÀÌ ¾ÆÄ«ÀÌºê ·Î±× ¸ðµå¸¦ ¼³Á¤ÇÏ¸é ·Î±× ÆÄÀÏÀÇ ½ºÀ§Ä¡°¡ ÀϾ ¶§¸¶´Ù Áö¼ÓÀûÀ¸·Î ÀÌ Log_Archive_Dest¿¡ ÁöÁ¤ÇÑ À§Ä¡¿¡ ·Î±× ÆÄÀÏÀÌ ½×ÀÌ°Ô µÇ´Âµ¥, ¸¸ÀÏ ºÎÁÖÀÇ¿¡ ÀÇÇØ ÀÌ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀÌ ±úÁö°Å³ª ºÐ½ÇµÇ´Â °æ¿ì´Â ±× ÀÌÈÄÀÇ µ¥ÀÌŸ º¹±¸°¡ ºÒ°¡´ÉÇϹǷΠÁÖÀÇÇÏ¿©¾ß ÇÑ´Ù.
ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÁÙÀ̱â À§ÇØ Oracle8ºÎÅÍ´Â ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀ» MirroringÇϱâ À§ÇÏ¿© ¿©·¯ ±ºµ¥¿¡ º¸°üÇÒ ¼ö ÀÖ´Â ¹æ¾Èµµ µµÀԵǾú´Ù. ÀÌ´Â log_archive_duplex_dest¸¦ ¼³Á¤ÇÔÀ¸·Î½á °¡´ÉÇÏ´Ù.
¶ÇÇÑ V8iºÎÅÍ´Â ÃÖ´ë 5±ºµ¥¿¡ ÀÌ ·Î±× ÆÄÀÏÀ» ÀúÀåÇÒ ¼ö ÀÖµµ·Ï ÇÏ¿©
LOG_ARCHIVE_DEST_1=¡±LOCATION=/oracle8/arch_1 MANDATORY¡±
LOG_ARCHIVE_DEST_2=¡±LOCATION=/oracle8/arch_2 OPTIONAL?
ó·³ ÁöÁ¤ÀÌ °¡´ÉÇÏ´Ù
(3) LOG_ARCHIVE_FORMAT = %s.log
¾ÆÄ«À̺ê ÆÄÀÏÀÇ È®ÀåÀÚ¿Í ·Î±× ½ÃÄö½º ¹øÈ£ÀÇ Çü½ÄÀ» ÁöÁ¤.
ÀÌ´Â (2)¿¡¼ Á¤ÀÇµÈ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀÇ Ã¹ ºÎºÐ À̸§°ú ÇÔ²² ³ªÅ¸³´Ù.
arc123.log, arc124.log (123°ú 124´Â ·Î±× ½ÃÄö½º ¹øÈ£) ¿Í °°Àº ÇüÅÂÀÇ ÆÄÀÏÀÌ ÁöÁ¤ÇÑ À§Ä¡¿¡ »ý¼ºµÈ´Ù.
2. ´ÙÀ½°ú °°ÀÌ ÀÛ¾÷ÇÏ¿© ¾ÆÄ«ÀÌºê ·Î±× ¸ðµå·Î º¯È¯ÇÑ´Ù.
$ svrmgrl
SVRMGR> connect internal
SVRMGR> startup mount - ¡á
SVRMGR> alter database archivelog; - ¡à
SVRMGR> archive log list - ¡Ü
Database log mode ARCHIVELOG - ¡Ý
Automatic archival ENABLED - ¡Þ
Archive destination ?/dbs_ar/offline_log/offline - ¡ß
Oldest online log sequence 123 - ¡â
Next log sequence to archive 125 - ¡ã
Current log sequence 125 - ¢¹
SVRMGR> alter database open; - ¢º
¡á DB¸¦ Startup Mount±îÁö¸¸ ÇÑ´Ù.
¡à ÀÌ Ä¿¸Çµå¸¦ ÀÌ¿ëÇÏ¿© ¾ÆÄ«ÀÌºê ¸ðµå·Î µ¥ÀÌŸº£À̽º¸¦ º¯°æÇÑ´Ù.
¡Ü ¾ÆÄ«ÀÌºê ¸ðµå·Î º¯°æµÇ¾ú´ÂÁö¸¦ È®ÀÎÇÑ´Ù.
¡Ý µ¥ÀÌŸº£À̽º°¡ ¾ÆÄ«ÀÌºê ¸ðµåÀÓÀ» ³ªÅ¸³½´Ù. ¸¸¾à NOARCHIVELOG·Î µÇ¾î ÀÖÀ¸¸é º¯°æµÇÁö ¾ÊÀº °ÍÀ» ÀǹÌÇÑ´Ù.
¡Þ initSID.ora ÆÄÀÏ¿¡¼ LOG_ARCHIVE_START Æз¯¹ÌÅ͸¦ TRUE·Î Á¤ÀÇÇÏ¿´À½À» ³ªÅ¸³»¸ç FalseÀÎ °æ¿ì¿¡´Â DISABLED·Î ³ªÅ¸³´Ù.
¡ß initSID.ora ÆÄÀÏÀÇ LOG_ARCHIVE_DEST Æз¯¹ÌÅÍ¿¡¼ Á¤ÀÇÇÑ ¾ÆÄ«À̺êÇÒ Àå¼ÒÀÌ´Ù.
¡â 3°³ÀÇ Redo Log Áß °¡Àå ¿À·¡µÈ ¸®µÎ ·Î±×ÀÇ ½ÃÄö½º°¡ 123ÀÓÀ» ÀǹÌÇÑ´Ù.
¡ã ´ÙÀ½¿¡ ¾ÆÄ«ÀÌºê ¹ÞÀ» ÆÄÀÏÀÇ ·Î±× ½ÃÄö½º ¹øÈ£¸¦ ³ªÅ¸³½´Ù.
¢¹ ÇöÀç »ç¿ëÁßÀÎ ¸®µÎ ·Î±×ÀÇ ½ÃÄö½º°¡ 125ÀÓÀ» ÀǹÌÇÑ´Ù. ¸¸¾à ÀÌÀüºÎÅÍ ¾ÆÄ«ÀÌºê ·Î±× ¸ðµå·Î ¿î¿µÁßÀ̾ú´Ù¸é ¿©±â¿¡¼ ¾ÆÄ«ÀÌºê ·Î±× ÆÄÀÏÀº ·Î±× ½ÃÄö½º 124±îÁö ¾ÆÄ«À̺êµÇ¾î ÀÖ´Ù´Â °ÍÀ» ÀǹÌÇÑ´Ù.
¢º ¾ÆÄ«ÀÌºê ¸ðµå·Î º¯°æ ÈÄ DB¸¦ ¿ÀÇÂÇÑ´Ù.
No Archive Log Mode·Î ÀüȯÇÏ´Â ¹æ¹ý
¹Ý´ë·Î, Archivelog Mode¿¡¼ No Archivelog Mode·Î ÀüȯÇÏ´Â ¹æ¹ýÀº ´ÙÀ½°ú °°´Ù.
¸ÕÀú, À§¿¡¼ ¼¼ÆÃÇß´ø initSID.ora ÆÄÀÏ°ú configSID.ora¿¡ ÀÖ´Â ´ÙÀ½ Æз¯¹ÌÅÍ ¾Õ¿¡ #À» ³Ö°í ÀúÀåÇÑ´Ù.
#LOG_ARCHIVE_START = TRUE
#LOG_ARCHIVE_DEST = /home/oracle8/dbs/archive_file/arc
#LOG_ARCHIVE_FORMAT = %s.log
$ svrmgrl
SVRMGR> connect internal;¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
SVRMGR> shutdown immediate
SVRMGR> startup mount¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
ORACLE instance started.¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
Database mounted.¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
SVRMGR> alter database noarchivelog;¡¡¡¡¡¡¡¡¡¡
Statement processed.¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
SVRMGR> alter database open;¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡
Statement processed.
Hot Backup ÇÏ´Â ¹æ¹ý
µ¥ÀÌŸº£À̽º¸¦ ¼Ë´Ù¿îÇÏÁö ¾Ê°í µ¥ÀÌŸ ÆÄÀÏÀ» ¹é¾÷ÇÏ´Â ¹æ¹ýÀÌ´Ù.
ÀÌ ¹æ¹ýÀº ÄÝµå ¹é¾÷º¸´Ù ´õ º¹ÀâÇÏÁö¸¸ µ¥ÀÌŸº£À̽º°¡ ¿ÀǵǾî ÀÖ´Â µµÁß¿¡ ÇÒ ¼ö ÀÖ°í ¶ÇÇÑ Å×ÀÌºí½ºÆäÀ̽º º°·Î ¹é¾÷ÇÒ ¼ö ÀÖ´Ù´Â ÀåÁ¡ÀÌ ÀÖ´Ù.
ÇÖ ¹é¾÷Àº Ç×»ó µ¥ÀÌŸº£À̽º¸¦ ¾ÆÄ«ÀÌºê ·Î±× ¸ðµå »óÅ·ΠµÎ°í ½Ç½ÃÇÑ´Ù.
| ¹æ¹ý | Å×ÀÌºí½ºÆäÀ̽º ´ÜÀ§·Î ¹é¾÷À» ½Ç½ÃÇÑ´Ù.
svrmgrl > CONNECT INTERNAL
svrmgrl > ALTER TABLESPACE SYSTEM BEGIN BACKUP;
½Ã½ºÅÛ Å×ÀÌºí½ºÆäÀ̽ºÀÇ ¸ðµç µ¥ÀÌŸÆÄÀÏ¿¡ ´ëÇؼ OS Backup ÇÑ´Ù.
$ tar cvf /dev/rmt0 /usr/oracle8/dbs/syst1ORA8.dbf
$ tar cvf /dev/rmt0 /usr/oracle8/dbs/syst2ORA8.dbf
svrmgrl > ALTER TABLESPACE SYSTEM END BACKUP;
svrmgrl > ALTER TABLESPACE USERS BEGIN BACKUP;
$ tar cvf /dev/rmt0 /usr/oracle8/dbs/user1ORA8.dbf
svrmgrl > ALTER TABLESPACE USERS END BACKUP;
´Ù¸¥ Å×ÀÌºí½ºÆäÀ̽º¿¡ ´ëÇؼµµ °°Àº ¹æ¹ýÀ¸·Î ÇÑ´Ù.
ÁÖÀÇÇÒ Á¡Àº BEGIN°ú END »çÀÌ¿¡´Â ÇØ´ç Å×ÀÌºí½ºÆäÀ̽ºÀÇ µ¥ÀÌŸÆÄÀÏ Çì´õ Á¤º¸°¡ º¯°æµÇÁö ¾Ê´Â´Ù´Â °ÍÀÌ´Ù. µû¶ó¼ OS ¹é¾÷ÀÌ Á¾·áµÊ°ú µ¿½Ã¿¡ ¡®ALTER TABLESPACE ... END BAKCUP¡¯ Ä¿¸Çµå¸¦ ½ÇÇàÇÏ¿© µ¥ÀÌŸÆÄÀÏÀÇ Çì´õ°¡ º¯°æµÇµµ·Ï ÇÑ´Ù.
ÀÌ ¾ÆÄ«ÀÌºê ¹é¾÷ ÆÄÀÏÀ» ÀÌ¿ëÇÑ º¹±¸ ¹æ¹ýÀº ´ÙÀ½ ±âȸ¿¡ ´Ù·çµµ·Ï ÇÑ´Ù.
Export Backup ÇÏ´Â ¹æ¹ý
¿À¶óŬ¿¡¼ Á¦°øµÇ´Â Export À¯Æ¿¸®Æ¼´Â µ¥ÀÌŸº£À̽º¿¡ ÀúÀåµÈ µ¥ÀÌŸ¸¦ ¹ÙÀ̳ʸ® ÇüÅÂÀÇ OS ÆÄÀÏ·Î ¸¸µé°í, ÇÊ¿ä½Ã Import À¯Æ¿¸®Æ¼¸¦ ÀÌ¿ëÇÏ¿© µ¥ÀÌŸº£À̽º·Î ´Ù½Ã ¿Ã¸®´Â ¹æ½ÄÀÌ´Ù .
ÀÌ À¯Æ¿¸®Æ¼´Â °¢ ¿ÀºêÁ§Æ® ´ÜÀ§·Î 󸮰¡ °¡´ÉÇϱ⠶§¹®¿¡ Å×ÀÌºí ¸î °³¸¸À» º¹±¸ÇѴٵ簡 ƯÁ¤ »ç¿ëÀÚÀÇ Å×À̺íµéÀ» ´Ù¸¥ Å×ÀÌºí½ºÆäÀ̽º·Î ¿Å±ä´Ùµç°¡ ¶Ç´Â Àüü µ¥ÀÌŸº£À̽ºÀÇ ÀڷḦ ¼·Î ´Ù¸¥ OS·Î ¿Å±â´Â °æ¿ì µî¿¡ ƯÈ÷ À¯¸®ÇÏ´Ù.
ExportÀÇ Á¾·ù
ÀÌ Export ¹æ¾ÈÀº ½Ã½ºÅÛ°ú ¼·Î ¸Þ½ÃÁö¸¦ ÁÖ°í¹ÞÀ¸¸é¼ ¹é¾÷À» ÇÒ ¼ö ÀÖ´Â Interactive Mode°¡ ÀÖ°í, ÇÑ ¶óÀÎÀÇ ¸í·É¾î·Î Export½Ã ÇÊ¿äÇÑ ¿É¼ÇÀ» ±æ°Ô ¿°ÅÇØÁÖ´Â Command ¹æ½ÄÀÌ ÀÖ´Ù.
Command ¹æ½ÄÀº ¼ø°£ ¼ø°£ ÇÊ¿äÇÑ ¿É¼ÇÀ» Àû¾îÁֱ⸸ ÇÏ¸é µÇ±â ¶§¹®¿¡ ¿©±â¼´Â Interactive ¹æ½ÄÀ» ´Ù·ç¾î º¸±â·Î ÇÑ´Ù
ExportÀÇ ´ÜÀ§
Full ´ÜÀ§ : Àüü µ¥ÀÌŸº£À̽º¸¦ Export ÇÑ´Ù.
User ´ÜÀ§ : ƯÁ¤ À¯Àú Àüü ¿ÀºêÁ§Æ®¸¦ Export ÇÑ´Ù.
Table ´ÜÀ§ : ƯÁ¤ Å×À̺íÀ» Export ÇÑ´Ù.
Partition ´ÜÀ§ : ƯÁ¤ Å×À̺íÀÇ ÆÄƼ¼ÇÀ» Export ÇÑ´Ù.
ExportÀÇ ½ÇÁ¦ ¿¹Á¦
| ¿¹ 1 | Àüü µ¥ÀÌŸº£À̽ºÀÇ Export (Interactive Method)
$ exp system/manager
Connected to: ORACLE8 Server Release 8.0.5 - Production
With the procedural and distributed options
PL/SQL Release 2.2 - Production
Enter array fetch buffer size : 4096 > 100000 (RETURN)
Export file : expdat.dmp >
(1) E(ntire database), (2) U(sers), (3) T(ables) : U > e
Export grants (Y/N) : Y > y
Export table data (Y/N) : Y > y
Compress extents (Y/N) : Y > y
About to export the entire database....
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting role
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting sequence numbers
. exporting cluster definitions
. exporting stored procedures
. about to export SYSTEM¡¯s tables ...
. about to export SCOTT¡¯s tables ...
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting triggers
Export terminated successfully without warnings.
| ¿¹ 2 | Àüü µ¥ÀÌŸº£À̽ºÀÇ EXPORT(Command Line Method)
$ exp userid=system/manager full=y file=fullbackup.dmp buffer=100000
| ¿¹ 3 | Àüü µ¥ÀÌŸº£À̽ºÀÇ EXPORT(Dynamic Method)
Export Æз¯¹ÌÅ͸¦ ´ÙÀ½°ú °°Àº ÆÄÀÏ(tusc.par) ÇüÅ·Π¸¸µç´Ù.
system/manager
full=y
file=fullbackup.dmp
buffer=100000
$ exp parfile=tusc.par
| ¿¹ 4 | User ´ÜÀ§ÀÇ Export
$ exp system/manager
Connected to: ORACLE8 Server Release 8.0.5 - Production
With the procedural and distributed options
PL/SQL Release 2.2 - Production
Enter array fetch buffer size : 4096 > 100000 (RETURN)
Export file : expdat.dmp >
(1) E(ntire database), (2) U(sers), (3) T(ables) : U > u
Export grants (Y/N) : Y > y
Export table data (Y/N) : Y > y
Compress extents (Y/N) : Y > y
About to export specified users
User to be exported: (RETURN to quit) > scott
. exporting snapshots
. exporting snapshot log
. exporting database links
. exporting sequence numbers
. exporting sequence numbers
. exporting cluster definitions
. exporting stored procedures
. about to export SCOTT¡¯s tables ...
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting triggers
Export terminated successfully without warnings.
| ¿¹ 5 | User ´ÜÀ§ÀÇ Export (Command Line Method)
$ exp system/manager owner=scott file=scott.dmp buffer=100000
¶Ç´Â
$ exp scott/tiger file=scott.dmp buffer=100000
| ¿¹ 6 | User ´ÜÀ§ÀÇ Export (Dynamic Method )
Export Æз¯¹ÌÅ͸¦ ´ÙÀ½°ú °°Àº ÆÄÀÏ(tusc.par) ÇüÅ·Π¸¸µç´Ù.
$vi tusc.par
scott/tiger
file=scott.dmp
buffer=1000000
$ exp parfile=tusc.par
| ¿¹ 7 | Table ´ÜÀ§ÀÇ Export
$ exp scott/tiger file=table.dmp tables=emp,dept buffer=100000
[Ãâó] [¸Å´º¾ó Á¤¸®] ¿À¶óŬ ¹é¾÷ (¼îÇθô ´ë¹Ú¸ø³»´Â ÁøÂ¥ÀÌÀ¯!) |ÀÛ¼ºÀÚ ÇÁ·±Æ¼¾î
|
|
|
|
|
|