ÇØ°áÇß½À´Ï´Ù~°í¸¿½À´Ï´Ù^^

°­»óÃá   
   Á¶È¸ 6808   Ãßõ 1    

¿À¶óŬ¿¡ ¹®Á¦°¡ »ý°å½À´Ï´Ù.

°©Àڱ⠴ٿîµÆ³ª ±×·¨À»°Å¿¡¿ä.±× ÈÄ·Î Á¢¼ÓÇϸé ÈÞÁöÀνºÅϽº¿¡ Á¢¼ÓµÇ¾ú½À´Ï´Ù.

ÀÌ·¸°Ô ³ª¿À³×¿ä.°Ë»öÇغ¸´Ï ¾î¶² ÀÛ¾÷À» ÇØ¾ß Çϴµ¥ Á¦°¡ ÄÁÆ®·Ñ ÆÄÀÏÀ» Áö¿ö¹ö·È³×¿ä,ÈæÈæ

±×·¯´Ù°¡ ¾Æ·¡¿Í °°Àº ±ÛÀ» ºÃ´Âµ¥¿ä.¸í·É¾î°¡ ¾È ¸ÔÈ÷³×¿ä


SQL> ALTER DATABASE backup controlfile to trace;
# ÀÌ ¸í·É ¼öÇà ÈÄ ÄÁÆ®·Ñ ÆÄÀÏÀÌ À¯Àú ´ýÇÁ À§Ä¡·Î Æ®·¹ÀÌ½Ì µË´Ï´Ù.

-->> ALTER ÀÌ ¸í·É¾î°¡ ¾È¸ÔÈü´Ï´Ù

(ÀÌ ÀÛ¾÷À» ÇÑÈÄ¿¡ ÄÁÆ®·Ñ ÆÄÀÏÀ» Áö¿ö¾ß Çϴµ¥ ´Ù¸¥°÷ÀÇ ±ÛÀ» ºÃÀ»¶§ Á¦°¡ ¸øºÃ³ªº¾´Ï´Ù.

Àú´Â ÄÁÆ®·Ñ ÆÄÀÏÀ» ¹Ì¸® Áö¿ü½À´Ï´Ù. ±×·¡¼­ ÀÌ ¸í·É¾î°¡ ¾È ¸ÔÈü´Ï´Ù.¾îÂîÇØ¾ß Çϳª¿ä?

½ÇÇàÇϸ頠
*
1Çà¿¡ ¿À·ù:
ORA-01507: ??????? ????? ?????

ÀÌ·¸°Ô ³ª¿É´Ï´Ù.µµ¿ò ºÎŹµå¸³´Ï´Ù.

Á¶¾ð ²À ºÎŹµå¸³´Ï´Ù.





1. sqlplus ¿¡ /as sysdba loginÀ» Çؼ­ db °¡µ¿ ¿©ºÎ¸¦ È®ÀÎÇØ º¾´Ï´Ù.

$ ps -aux | grep <sid>  ( ps -ef | grep <sid> )
$ sqlplus "/as sysdba"
SQL> startup
SQL> exit


2. trace file À» »ý¼ºÇÏ°í editing Çؼ­ control file À» Àç»ý¼ºÇÏ´Â ½ºÅ©¸³Æ® ÆÄÀÏÀ» ¸¸µì´Ï´Ù.
$ sqlplus system/manager <-- °¢ÀÚÀÇ Æнº¿öµå

SQL> show parameter user_dump ==> user_dump_dest À¯Àú ´ýÇÁ À§Ä¡ È®ÀÎ

SQL> ALTER DATABASE backup controlfile to trace;
# ÀÌ ¸í·É ¼öÇà ÈÄ ÄÁÆ®·Ñ ÆÄÀÏÀÌ À¯Àú ´ýÇÁ À§Ä¡·Î Æ®·¹ÀÌ½Ì µË´Ï´Ù.

-->> ALTER ÀÌ ¸í·É¾î°¡ ¾È¸ÔÈü´Ï´Ù

(ÀÌ ÀÛ¾÷À» ÇÑÈÄ¿¡ ÄÁÆ®·Ñ ÆÄÀÏÀ» Áö¿ö¾ß Çϴµ¥ ´Ù¸¥°÷ÀÇ ±ÛÀ» ºÃÀ»¶§ Á¦°¡ ¸øºÃ³ªº¾´Ï´Ù.

±×·¡¼­ ÀÌ ¸í·É¾î°¡ ¾È ¸ÔÈü´Ï´Ù.¾îÂîÇØ¾ß Çϳª¿ä?



SQL> !ps -aux | grep <SID>  # ¼­¹ö ÇÁ·Î¼¼½º¸¦ È®ÀÎÇÕ´Ï´Ù.
SQL> exit

$ cd $HOME($ORACLE_HOME)/ADMIN/UDUMP   == > °¢ÀÚÀÇ À§Ä¡¿¡ ¸Â°Ô
$ cp sid_ora_xxxx.trc $HOME/BACKUP/UMAN/cntrl1.trc  == > À̸§À» ¹Ù²Ù¾î ÁÝ´Ï´Ù.
$ vi cntrl1.trc
ÆÄÀÏÀ» ¿­¾î¼­ ÁÖ¼®À̵Ǿî ÀÖ´Â ºÎºÐÀº ÀüºÎ »èÁ¦ÇÕ´Ï´Ù.
(STARTUP NOMOUNT ¹®Àå Àü±îÁö ±×ÈÄ¿¡µµ ´Ù »èÁ¦ÇÕ´Ï´Ù.)

3. DB shutdown ÇÕ´Ï´Ù. (Ŭ¸° ¼Ë´Ù¿î)

SQL> shutdown immediate
SQL> exit


4. control fileÀ» ¸ðµÎ »èÁ¦ÇÕ´Ï´Ù.
$ rm $HOME/ORADATA/u03/ctrl01.ctl $HOME/ORADATA/u05/ctrl02.ctl
(¸ÖƼ Ç÷º½ÌÀ» ÇßÀ» °æ¿ì)


5. DB ¸¦ °¡µ¿ÇØ º¾´Ï´Ù.
$ sqlplus "/as sysdba"
SQL> startup
    ORA-00205 error in identifying controlfile, check alert log for more info
SQL> shutdown immediate

½ÇÆа¡ ³ª¿É´Ï´Ù.
$ oerr ora 00205    <== ¿¡·¯ÀÇ ¿øÀΰú ÃëÇÒ ¼ö ÀÖ´Â ¾×¼Ç ¼³¸íÀ̳ª¿É´Ï´Ù.

00205, 00000, "error in identifying controlfile, check alert log for more info"
// *Cause:  The system could not find a controlfile of the specified name and
//         size.
// *Action: Check that ALL controlfiles are online and that they are the same
//         files that the system created at cold start time.


@$HOME/flash_recovery_area/cntrl1.trc

6. ¾Æ±î ¸¸µé¾î ³õÀº ½ºÅ©¸³Æ® ÆÄÀÏ·Î control fileÀ» Àç»ý¼ºÇÒ ¼öÀÖ½À´Ï´Ù.

SQL> @$HOME/BACKUP/UMAN/cntrl1.trc ¾Æ±î ¹é¾÷¹Þ¾Æ³õÀº ½ºÅ©¸³Æ® ÆÄÀÏÀ» ½ÇÇà½Ãŵ´Ï´Ù.
SQL> SELECT * FROM hr.employees;   ==> db°¡ ¿ÀǵǾú´ÂÁö È®ÀÎÇÕ´Ï´Ù.
SQL> shutdown immediate
SQL> startup                     ===> ÀçÈ®ÀÎÇÕ´Ï´Ù.
ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.


QnA
Á¦¸ñPage 4099/5689
2015-12   1546603   ¹é¸Þ°¡
2014-05   5010934   Á¤ÀºÁØ1
2016-06   10677   KyuJoonA
2017-06   3641   ¼ÒÀ²¹Ù¶ó±â
2016-07   7746   twopaik
2017-07   4882   µé°í¾çÀÌ
2017-07   3218   jblee1234
2009-01   6809   °­»óÃá
2014-04   3532   ºü½Ã¿Â
2016-12   4707   ±è°Ç¿ì
2022-01   2484   Àü¼³¼ÓÀǹ̡¦
2019-05   3561   ÇູÇϼ¼
2020-10   2282   ¾Æ½º¶õ
2016-05   6683   ÆíÇѼ¼»ó
2016-05   4779   ¸¶Â¡°¡
2017-05   4614   ¸·ÆÇ´ëÀå
2017-05   3343   annm
2017-06   6245   Rainwalk
2017-06   3349   À嵿°Ç2014
2016-07   3878   Àº¼­¾Æºü
2021-03   2534   È«Àμº
2016-09   4186   Jisan