¿ØÖÆÎļþµÄ±¸·Ý¼°»Ö¸´£¨linuxϺÍXPϲ½ÖèÊÇÒ»ÑùµÄ£©
±¸·Ý¿ØÖÆÎļþ°üÀ¨ÈýÖÖ·½·¨£º
(1)ͨ¹ý²Ù×÷ϵͳÃüÁîÔÚÊý¾Ý¿â¹Ø±Õʱ¶Ô¿ØÖÆÎļþ½øÐÐCOPY£»
(2)ÀûÓÃALTER DATABASE BACKUP CONTROLFILE TOÃüÁ¿ØÖÆÎļþ±¸·Ýµ½¶þ½øÖÆÎļþ£»
SQL> alter database backup controlfile to 'E:\oracle\product\10.2.0\orcl\controlfile01.bak';
Êý¾Ý¿âÒѸü¸Ä¡£
(3)ÀûÓÃALTER DATABASE BACKUP CONTROLFILE TO TRACEÃüÁÖؽ¨¿ØÖÆÎļþ±¸·ÝµÄ½Å±¾±¸·Ýµ½ºǫ́traceÎļþÖС£
SQL> alter database backup controlfile to trace;
Êý¾Ý¿âÒѸü¸Ä¡£
OracleÍƼöʹÓõڶþÖÖ·½Ê½À´±¸·Ý¿ØÖÆÎļþ¡£µÚÒ»ÖÖ·½Ê½±¸·ÝµÄ¿ØÖÆÎļþ£¬Ò»°ãÓÃÓÚÈ«¿âÒ»ÖÂÐÔ»Ö¸´¡£¶øµÚÈýÖÖ·½Ê½±¸·Ý¿ØÖÆÎļþ»á¶ªÊ§¹éµµÈÕÖ¾ÀúÊ·µÈÐí¶àÐÅÏ¢¡£ÔÚÖؽ¨¿ØÖÆÎļþʱ£¬Ö»¶Á±í¿Õ¼äºÍÍÑ»úµÄÊý¾ÝÎļþµÄ´¦ÀíÏà¶Ô±È½Ï¸´ÔÓ¡£
»Ö¸´ÀûÓÃalter database backup controlfile to trace;±¸·ÝµÄ¿ØÖÆÎļþ
1 ¹Ø±ÕÊý¾Ý¿â£¬ÖØÃüÃû¿ØÖÆÎļþ£¬Ä£Äâ¿ØÖÆÎļþ¶ªÊ§
2 ´ò¿ªÊý¾Ý¿â£¬Á¬½ÓÈçÏ£º
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚÁù 5ÔÂ 15 19:23:57 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
SQL> conn system/manager
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
¾¯¸æ: Äú²»ÔÙÁ¬½Óµ½ ORACLE¡£
SQL> conn scott/tiger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
3 SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
ÐÞ¸ÄÓÉalter database backup controlfile to trace±¸·Ý¿ØÖÆÎļþʱ²úÉúµÄ½Å±¾£¬È¥µô¶àÓàµÄ×¢ÊÍ
ÔÚE:\oracle\product\10.2.0\admin\orcl\udumpµÄorcl_ora_668.trcÕÒµ½´´½¨¿ØÖÆÎļþµÄ½Å±¾
Ö´ÐÐÈçÏÂÓï¾ä£º
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG' SIZE 50M,
GROUP 2 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG' SIZE 50M,
GROUP 3 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG' SIZE 50M
DATAFILE
'E:\ORACLE\PRODUCT\10.2.0\O
Ïà¹ØÎĵµ£º
Àí½â
Linux
µ÷ÓŲÎÊý
ÔÚÎÒÃǽéÉÜ
Linux
ϵͳµÄ¸÷ÖÖµ÷ÓŲÎÊýºÍÐÔÄÜ
¼à²â¹¤¾ß֮ǰ£¬ÐèÒªÏÈÌÖÂÛһЩ¹ØÓÚÐÔÄܵ÷ÓŵIJÎÊý¡£ÒòΪ
Linux
ÊÇÒ»¸ö¿ªÔ´²Ù×÷ϵͳ£¬ËùÒÔÓÖ´óÁ¿¿ÉÓõÄÐÔÄܼà²â¹¤¾ß¡£¶ÔÕâЩ¹¤¾ßµÄÑ¡ÔñÈ¡¾öÓÚÄãµÄ¸öÈËϲºÃºÍ¶ÔÊý¾Ý
ϸ½ÚµÄÒªÇó¡£ËùÓеÄÐÔÄܼà²â¹¤¾ß¶¼ÊÇ°´ÕÕͬÑùµÄ¹æÔòÀ´¹¤×÷µÄ£¬ËùÒÔÎÞÂÛÄãʹÓÃÄÄÖÖ¼ ......
ת×Ô£ºhttp://www.yayu.org/look.php?id=162
µ±´ÅÅÌ´óС³¬¹ý±ê׼ʱ»áÓб¨¾¯Ìáʾ£¬ÕâʱÈç¹ûÕÆÎÕdfºÍduÃüÁîÊǷdz£Ã÷ÖǵÄÑ¡Ôñ¡£
df¿ÉÒԲ鿴һ¼¶Îļþ¼Ð´óС¡¢Ê¹ÓñÈÀý¡¢µµ°¸ÏµÍ³¼°Æä¹ÒÈëµã£¬µ«¶ÔÎļþÈ´ÎÞÄÜΪÁ¦¡£
du¿ÉÒԲ鿴Îļþ¼°Îļþ¼ÐµÄ´óС¡£
Á½ÕßÅäºÏʹÓã ......
step1£º
ÔÚubuntuÀïÃæÓÒ»÷Òª¹²ÏíµÄÎļþ¼Ð£¬»áÌáʾ°²×°Èí¼þ£¬Ñ¡Ôñ°²×°¼´¿É£»
step2£º
ʵÏÖxpÄäÃû·ÃÎÊUbuntu¹²ÏíÎļþ¼Ð£¬ ÔòÖ»ÐèÐÞ¸Ä/etc/samba/smb.co ......
fg¡¢bg¡¢jobs¡¢&¡¢ctrl + z¶¼ÊǸúϵͳÈÎÎñÓйصģ¬ËäÈ»ÏÖÔÚ»ù±¾Éϲ»ÔõôÐèÒªÓõ½ÕâЩÃüÁµ«Ñ§»áÁËÒ²ÊǺÜʵÓõÄ
Ò»¡£& ×î¾³£±»Óõ½
Õâ¸öÓÃÔÚÒ»¸öÃüÁîµÄ×îºó£¬¿ÉÒÔ°ÑÕâ¸öÃüÁî·Åµ½ºǫִ́ÐÐ
¶þ¡£ctrl + z
¿ÉÒÔ½«Ò»¸öÕýÔÚǰִ̨ÐеÄÃüÁî·Åµ½ºǫ́£¬²¢ÇÒÔÝÍ£
Èý¡£jobs
& ......
ÄÚºËÇý¶¯·ÖÀà
Çý¶¯ÊµÏÖ¹¦ÄÜ£º
¶Á
д
´ò¿ª
ÉèÖÃ
×îÖÕÄ¿µÄ²Ù×÷Ó²¼þÉ豸£ºÊý¾Ý´«ÊäºÍÊý¾Ý¿ØÖÆ
Ó²¼þ²Î¿¼ÊֲᣬÄÚºËÌṩµÄ¹¦ÄÜ£º²Ù×÷ʱÐò£¬×ÜÏßÈçºÎ²Ù×÷£¬ÄÚºËAPI
1.×Ö·ûÉ豸£¨char£©
2.¿éÉ豸£¨block£©
3.ÍøÂçÉ豸£¨net£©
ÄÚºËÄ£¿é²Ù×÷ÃüÁî
make
¼ÓÔØ:sudo modprobe ./Mo ......