Oracle 10G R2 RAC ÈÕ³£¹ÜÀí
Ò»¡¢Ê¹ÓÃsrvctl¹ÜÀíRACÊý¾Ý¿â
[root@NODE01 bin]# pwd
/orac/crs/bin # srvctlÔÚ$CRS_HOME/binĿ¼Ï£¬Ëü¿ÉÒÔÔÚÈκνڵãÉÏά»¤¡£
[root@NODE01 bin]# ./srvctl
Usage: srvctl <command> <object> [<options>]
command: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
objects: database|instance|service|nodeapps|asm|listener
For detailed help on each command and object and its options use:
srvctl <command> <object> -h
³£ÓõÄÃüÁîÖ÷ÒªÈçÏÂ:
1¡¢Ê¹ÓÃsrvctl statusÃüÁî
²é¿´Êý¾Ý¿âµÄ״̬£º
[root@NODE01 bin]# ./srvctl status database -d racdb
Instance RACDB1 is running on node node01
Instance RACDB2 is running on node node02
²é¿´Êý¾Ý¿âʵÀýµÄ״̬£º
[root@NODE01 bin]# ./srvctl status instance -d racdb -i racdb1,racdb2
Instance racdb1 is running on node node01
Instance racdb2 is running on node node02
²é¿´ASMʵÀýµÄ״̬£º
[root@NODE01 bin]# ./srvctl status asm -n node01
ASM instance +ASM1 is running on node node01.
[root@NODE01 bin]# ./srvctl status asm -n node02
ASM instance +ASM2 is running on node node02.
²é¿´½ÚµãÓ¦ÓóÌÐò£¨VIP¡¢GSD¡¢Listener¡¢ONS£©µÄ״̬£º
[root@NODE01 bin]# ./srvctl status nodeapps -n node01
VIP is running on node: node01
GSD is running on node: node01
Listener is running on node: node01
ONS daemon is running on node: node01
[root@NODE01 bin]#
[root@NODE01 bin]# ./srvctl status nodeapps -n node02
VIP is running on node: node02
GSD is running on node: node02
Listener is running on node: node02
ONS daemon is running on node: node02
ÒÔÉϵÄÃüÁîÔÚÈκνڵãÉ϶¼¿ÉÒÔÖ´ÐС£ÆäÖÐ-d±íʾÊý¾Ý¿âµÄÃû×Ö£¬-i±íʾinstanceÃû³Æ£¬-n±íʾ½ÚµãµÄÖ÷»úÃû¡£
2¡¢Ê¹ÓÃsrvctl start/stopÃüÁî
srvctl start asm –n node01 # to start the ASM instance
srvctl stop asm –n node01 &nb
Ïà¹ØÎĵµ£º
ÒÑÓм¸¸öÏîÄ¿×鿪ʼʹÓÃoracleµÄÈ«ÎÄË÷Òý¡£OracleµÄ´Ê·¨·ÖÎöÆ÷Õë¶ÔZHS16GBK×Ö·û¼¯µÄ´Ê·¨·ÖÎöÉв»¹»ÖÇÄÜ£¬Ö»ÄÜ»úеµØÒÔ×ÖΪµ¥Ôª
½øÐÐÆ¥Åä¡£¶ÔÓÚutf8×Ö·û¼¯µÄÊý¾Ý¿âÓÐÒ»¸öеĺºÓï·ÖÎöÆ÷chinese_lexer£¬Ð§ÂÊÓÐÁ˺ܴó¸ÄÉÆ¡£ÏÖ½«ÑéÖ¤²¢ÕûÀí¹ýµÄÈçºÎ½øÐÐoracleÈ«ÎÄ
Ë÷ÒýÉèÖõÄÎĵµ·¢¸ø´ó¼Ò£¬ÊÊÓÃÓÚ8i¡¢9i¸÷ƽ̨°æ±¾¡£
¡¡¡¡¶ÔÓ ......
Ò»:oracle°æ±¾½éÉÜ:
oracle8
oracle8i ±íʾ´Ëʱoracle¹«Ë¾½ø¾ü»¥ÁªÍø,i´ú±íInternet
oracle9iºÍoracle8iÀàËÆ
oracle10g°üÀ¨ÏÖÔÚµÄ11gʹÓÃÁËÍø¸ñ¼ÆËã,g´ú±ígrid.
¶þ:oracle10g·þÎñ½éÉÜ:
OracleDBConsoleorcl Õâ¸öÊDzÉÓÃä¯ÀÀÆ÷ʹÓõÄoracleÆóÒµ¹ÜÀíÆ÷ (Ò²¾ÍÊÇÄã°²×°µ¯³öµÄÄǸöÍøÒ³)
OracleOraDb10g_home1iSQ ......
sqlÓï¾äÈçÏÂ:
select * from userdb40.numservice where ServiceNumber =88880068
and applytime <= to_date('2009-12-26 10:41:44','yyyy-MM-dd HH24:mi:ss')
select to_date('2007-06-28 19:51:20.0','yyyy-MM-dd HH24:mi:ss') from dual; ......
±È½Ï¹Ù·½µÄ˵·¨
Full
A backup of a datafile that includes every allocated block in the file being backed up. A full backup of a datafile can be an image copy, in which case every data block is backed up. It can also be stored in a backup set, in which case datafile blocks not in use may be skipped, ......
ËäÈ»ÒÔǰÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
1. Oracle 10g windows ƽ̨ϰ²×°
¡¡¡¡ÏÂÔØµØÖ·£º http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com ......