×î½üÔÚÆô¶¯¼àÌýÆ÷µÄʱºòÊÕµ½ÁËTNS-01201: Listener cannot find executable...µÄ´íÎóÌáʾ¡£Õâ¸ö´íÎó»¹ÕæÊÇÒ»¸öһֱûÓÐÅöµ½¹ýµÄ´íÎó¡£Õ¦Ò»¿´»¹Õæ²»Ã÷°×ÊÇÔõôһ»ØÊÂÄØ¡£ÏÂÃæÊÇ´íÎóµÄ¾ßÌåÃèÊöÓë½â¾ö·½°¸¡£
1¡¢¹ÊÕÏÃèÊö
LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 06-JUN-2014 17:06:37
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Starting /home/oracle/OraHome10g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.3.0 - Production
Listener failed to start. See the error message(s) above...
2¡¢¹ÊÕÏ·ÖÎö
3¡¢¹ÊÕϽâ¾ö
SID_LIST_LISTENER_USBO2 =
oracle@DevDB02:~> echo $ORACLE_HOME
#ÓÉÓÚÖ±½Ó´ÓÁíÍâһ̨»úÆ÷¸´ÖÆÁËlistenerÅäÖÃÄÚÈÝ£¬Ð»úÆ÷Óë¾É»úÆ÷ʹÓÃÁ˲»Í¬µÄORACLE_HOME
Ïà¹Ø²Î¿¼
Oracle ÉÁ»ØÇø(Oracle Flash recovery area)
Oracle ¿ìÕÕ¿ØÖÆÎļþ(snapshot control file)
ÖÐСÐÍÊý¾Ý¿â RMAN CATALOG ±¸·Ý»Ö¸´·½°¸(Ò»)
ÖÐСÐÍÊý¾Ý¿â RMAN CATALOG ±¸·Ý»Ö¸´·½°¸(¶þ)
ÖÐСÐÍÊý¾Ý¿â RMAN CATALOG ±¸·Ý»Ö¸´·½°¸(Èý)
»ùÓÚRMANʵÏÖ»µ¿é½éÖʻָ´(blockrecover)
Óà DBMS_REPAIR ÐÞ¸´»µ¿é
RMAN Êý¾Ý¿â¿Ë¡ÎļþλÖÃת»»·½·¨
»ùÓÚRMANµÄÒì»úÊý¾Ý¿â¿Ë¡(rman duplicate)
»ùÓÚ RMAN µÄͬ»úÊý¾Ý¿â¿Ë¡
»ùÓÚÓû§¹ÜÀíµÄͬ»úÊý¾Ý¿â¿Ë¡
»ùÓÚRMAN´Ó»î¶¯Êý¾Ý¿âÒì»ú¿Ë¡(rman duplicate from active DB)
RMAN duplicate from active ʱÔâÓö ORA-17627 ORA-12154
Oracle À䱸·Ý
Oracle Èȱ¸·Ý
Oracle ±¸·Ý»Ö¸´¸ÅÄî
Oracle ʵÀý»Ö¸´
Oracle »ùÓÚÓû§¹ÜÀí»Ö¸´µÄ´¦Àí
SYSTEM ±í¿Õ¼ä¹ÜÀí¼°±¸·Ý»Ö¸´
SYSAUX±í¿Õ¼ä¹ÜÀí¼°»Ö¸´
Oracle »ùÓÚ±¸·Ý¿ØÖÆÎļþµÄ»Ö¸´(unsing backup controlfile)
RMAN ¸ÅÊö¼°ÆäÌåϵ½á¹¹
RMAN ÅäÖá¢¼à¿ØÓë¹ÜÀí
RMAN ±¸·ÝÏê½â
RMAN »¹ÔÓë»Ö¸´
RMAN catalog µÄ´´½¨ºÍʹÓÃ
»ùÓÚcatalog ´´½¨RMAN´æ´¢½Å±¾
»ùÓÚcatalog µÄRMAN ±¸·ÝÓë»Ö¸´
RMAN ±¸·Ý·¾¶À§»ó
×Ô¶¨Òå RMAN ÏÔʾµÄÈÕÆÚʱ¼ä¸ñʽ
Ö»¶Á±í¿Õ¼äµÄ±¸·ÝÓë»Ö¸´
Oracle »ùÓÚÓû§¹ÜÀíµÄ²»ÍêÈ«»Ö¸´
Àí½â using backup controlfile
ʹÓÃRMANʵÏÖÒì»ú±¸·Ý»Ö¸´(WINƽ̨)
ʹÓÃRMANÇ¨ÒÆÎļþϵͳÊý¾Ý¿âµ½ASM
»ùÓÚLinuxÏ Oracle ±¸·Ý²ßÂÔ(RMAN)
Linux ÏÂRMAN±¸·Ýshell½Å±¾
ʹÓÃRMANÇ¨ÒÆÊý¾Ý¿âµ½Òì»ú
RMAN Ìáʾ·ûÏÂÖ´ÐÐSQLÓï¾ä
Oracle »ùÓÚ RMAN µÄ²»ÍêÈ«»Ö¸´(incomplete recovery by RMAN)
rman »¹Ô¹éµµÈÕÖ¾(restore archivelog)