DB°ü¸®½Ã üũ Ç׸ñ
±¸ºÐ | Á¡°Ë³»¿ë | Á¡°Ë»çÇ× | ºñ °í |
ÀÏÀÏ Á¡°Ë | Oracle Instance »óÅ ȮÀÎ | Oracle Instance service »óÅ ȮÀÎ | SQL>select insatnce_name, status from v$instance; |
Listener »óÅ ȮÀÎ | listener°¡ Á¤»ó service ÁßÀÎÁö È®ÀÎ | $ lsnrctl status | |
Oracle S/W, Archive °ø°£ È®ÀÎ | Oracle ¼³Ä¡ Directory¿Í Archive DestÀÇ Free °ø°£ È®ÀÎ | $ df -k (HP¼¹öÀÏ °æ¿ì bdf) | |
Resource Check | Oracle¿¡ ¼³Á¤µÈ Parameter¿¡ µû¶ó resource°¡ ºÎÁ·ÇÑÁö È®ÀÎ | SQL> select * from v$resource_limit; | |
Backup È®ÀÎ | Oracle Database Backup¼öÇà ¿©ºÎ È®ÀÎ | SQL> select * from v$backup; (HotBackup) | |
recover ÆÄÀÏ Á¶È¸ | recovery °¡ ÇÊ¿äÇÑ ÆÄÀÏÀ» Á¶È¸ | SQL> select * from v$recover_file | |
Tablespace »ç¿ë·® È®ÀÎ | TablespaceÀÇ ¿©À¯ °ø°£À» È®ÀÎ ÇÏ¿© ºÎÁ·ÇÑ ½ºÆäÀ̽º ÇÒ´ç | SQL> SELECT a.tablespace_name, a.bytes/1024/1024 "AMOUNT(MB)", b.bytes/1024/1024 "USED(MB)", c.bytes/1024/1024 "FREE(MB)", | |
Redo ¹ß»ý·® È®ÀÎ | Redo ¹ß»ý·®ÀÌ °©ÀÚ±â Áõ°¡ ÇÒ °æ¿ì ApplicationÀÇ ¿ÀÀÛµ¿ÀÏ °æ¿ì°¡ ¸¹À¸¹Ç·Î Redo ¹ß»ý·®ÀÌ ¸¹À» °æ¿ì logmnrÀ» ÀÌ¿ëÇÏ¿©¿øÀÎ SQL ºÐ¼® | SQL> select to_char(first_time,'YYYY/MM/DD') "Date",count(thread#) "Count" | |
Alert Log È®ÀÎ | Alert_"SID".log ÆÄÀÏ¿¡¹ß»ýÇÏ´Â ErrorÈ®ÀÎ | $ vi $ORACLE_BASE/admin/"SID"/bdump/alert_"SID".log ¶Ç´Â cd $ORACLE_BASE/admin/SID/bdump -> grep ora-alert_SID.log | |
¼ö½Ã/ ÁÖ Á¡°Ë | Tablespace FragmentationÈ®ÀÎ | TablespaceÀÇ FragmentationÀÌ ½ÉÇÑ Tablespace´Â coalesce | SQL> SELECT * FROM ( |
Job ¼öÇà¿©ºÎ È®ÀÎ | DBA_JOBS¸¦ È®ÀÎÇÏ¿© µî·ÏµÈ JobÀÌ Á¤»óÀûÀ¸·Î ¼öÇàÁßÀÎÁö È®ÀÎ | SQL> select job, schema_user, last_date, last_sec, next_date, next_sec, what from dba_jobs; | |
Backup È®ÀÎ | ¹°¸®ÀûÀÎ Backup ¹× export Backup¿¡ ´ëÇÑ Á¤»ó ¼öÇà¿©ºÎ¿Í ControlfileÀº BackupÀÌ µÇ´ÂÁö Backup ÁÖ±â¿Í º¸°ü ÁßÀÎ Backup º»ÀÌ ¸î copyÀÎÁö È®ÀÎ | Backup Àåºñ¸¦ »ç¿ëÇÒ°æ¿ì Backup solution¿¡¼ È®ÀÎ | |
Trace È®ÀÎ | Oracle Process°¡ ¹ß»ý ½ÃÅ°´Â traceÆÄÀÏ È®ÀÎ (¹ß»ýÇÑ Trace ÆÄÀÏÀÌ ÀÖÀ» °æ¿ì metalink¸¦ ÀÌ¿ëÇÑ ¿øÀÎ ºÐ¼®) | $ ls -ltr $ORACLE_BASE/admin/"SID"/bdump $ ls -ltr $ORACLE_BASE/admin/"SID"/udump |
Ãâó: http://goalker.tistory.com/126 [¿À¶óŬ ½ºÅ͵ð]