DB/Oracle/¥³¥Þ¥ó¥É/¥¢¡¼¥«¥¤¥Ö¥â¡¼¥É¹½À®
Ìܼ¡†
¥¢¡¼¥«¥¤¥Ö¥â¡¼¥É¤Ë´Ø¤¹¤ë¾ðÊ󡣥⡼¥É¤ÎÊѹ¹°Ê³°¤Ë¤Ï¤¢¤Þ¤ê½ñ¤¯¤³¤È¤¬¤Ê¤¤¡£
ARCHIVELOG ¥â¡¼¥É¤òÊѹ¹†
¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î ARCHIVELOG ¥â¡¼¥É¤òÊѹ¹¤¹¤ë¡£10g ¤«¤é¤Ï½é´ü²½¥Ñ¥é¥á¡¼¥¿ LOG_ARCHIVE_START ¤ÎÀßÄê¤ÏÉÔÍס£
ÊýË¡†
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥·¥ã¥Ã¥È¥À¥¦¥ó¤¹¤ë
shutdown immediate
- ¡Ê¥ª¥×¥·¥ç¥ó¡Ë¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë
- ¡Ê¥ª¥×¥·¥ç¥ó¡Ë½é´ü²½¥Ñ¥é¥á¡¼¥¿¤òÊÔ½¸¤¹¤ë
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥Þ¥¦¥ó¥È¾õÂ֤ǵ¯Æ°¤¹¤ë
startup mount;
- ARCHIVELOG ¥â¡¼¥É¤òÊѹ¹¤¹¤ë
-- ARCHIVELOG ¥â¡¼¥É¤Ë¤¹¤ë¾ì¹ç alter database archivelog; -- ARCHIVELOG ¥â¡¼¥É¤ò¤ä¤á¤ë¾ì¹ç alter database noarchivelog;
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥ª¡¼¥×¥ó¤¹¤ë
alter database open;
- ¥Ç¡¼¥¿¥Ù¡¼¥¹¤ò¥Ð¥Ã¥¯¥¢¥Ã¥×¤¹¤ë
³Îǧ†
- ¸½ºß¤Î¥â¡¼¥É¤ò³Îǧ¤¹¤ë
archive log list
- ¥¢¡¼¥«¥¤¥Ö¥í¥°¤ÎÊݸÀè¤ò³Îǧ¤¹¤ë
show parameter db_recovery_file_dest
- $ORACLE_BASE/flash_recovery_area ¤¬¥Ç¥Õ¥©¥ë¥È¡£¤³¤ÎÃæ¤Î <SID>/archivelog/<YYYY-MM-DD>/ ¤ËÊݸ¤µ¤ì¤ë
- Oracle XE ¤Ç¤Ï /u01/app/oracle/fast_recovery_area ¤¬¥Ç¥Õ¥©¥ë¥È
抠
- NOARCHIVELOG ¥â¡¼¥É¤Î¾ì¹ç¡¢¥ª¥ó¥é¥¤¥ó¥Ð¥Ã¥¯¥¢¥Ã¥×¤¬¤Ç¤¤Ê¤¤¡£¥Ð¥Ã¥¯¥¢¥Ã¥×»þ¤ÏÍ×¥·¥ã¥Ã¥È¥À¥¦¥ó¤Ë¤Ê¤ë¤Î¤Ç¡¢¥Ð¥Ã¥¯¥¢¥Ã¥×¤È¥ê¥«¥Ð¥ê¤ÎÄä»ß»þ´Ö¤òµöÍƤǤ¤ë¤«¤òȽÃǤ·¤¿¾å¤Ç¥â¡¼¥É¤ò·èÄꤹ¤ë
Last-modified: 2011-11-02 (¿å) 15:13:14