¿ØÖÆÎļþºÍREDOLOGͬʱË𻵵ÄORACLEÊý¾Ý¿â»Ö¸´Ò»Àý
¿ØÖÆÎļþºÍREDOLOGͬʱË𻵵ÄORACLEÊý¾Ý¿â»Ö¸´Ò»Àý
Ò»¸ö¿Í»§´òµç»°¸øÎÒ£¬ËµËûÃÇÒ»¸ö²âÊÔÊý¾Ý¿âÆð²»À´ÁË£¬ÈÃÎÒ¹ýÈ¥¿´¿´£¬
µ½¿Í»§ÏÖ³¡·¢ÏÖÊý¾Ý¿âÒѾDOWNÁË£¬ÊÔ×ÅÆô¶¯Ò»ÏÂ
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 7 10:33:29 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 2365587456 bytes
Fixed Size 2060096 bytes
Variable Size 1526726848 bytes
Database Buffers 822083584 bytes
Redo Buffers 14716928 bytes
Database mounted.
ORA-16038: log 2 sequence# 454 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/home/oradata/test/redo02.log'
ÕâÖÖÇé¿öÏÂͨ³£ÊÇÇå³ýһϹ鵵״̬¾Í¿ÉÒÔÁË£¬±¾À´ÒÔΪÎÊÌâºÜ¼òµ¥£¬Æô¶¯Êý¾Ý¿âµ½MOUNT״̬
ORACLE instance shut down.
SQL> SQL>
SQL>
SQL> startup mount
ORACLE instance started.
Total System Global Area 2365587456 bytes
Fixed Size 2060096 bytes
Variable Size 1526726848 bytes
Database Buffers 822083584 bytes
Redo Buffers 14716928 bytes
Database mounted.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
----------
Ïà¹ØÎĵµ£º
ƽʱÓõıȽ϶àµÄ£¬¾ÍÊÇNVL£¬Ã»ÔõôÔÚÒâÆäËû¼¸¸ö¡£
NVL ¾Í²»ÓÃ˵ÁË£¬¾ÍÊÇÅжϵÚÒ»¸öÊÇ·ñΪNULL£¬ÊǾÍÓõڶþ¸ö´úÌ棬²»ÊǾͷµ»ØµÚÒ»¸ö¡£
NVL2 Ò²ÊÇÅжϵÚÒ»¸öÊÇ·ñΪNULL£¬µ«ÊÇ·µ»Øֵȴ²»Í¬¡£µÚÒ»¸öΪNULL£¬¾Í·µ»ØµÚÈý¸ö£¬·ñÔò·µ»ØµÚ¶þ¸ö¡£
NULLIF ÅжÏÁ½¸ö²ÎÊýÊÇ·ñÏàµÈ£¬ÏàµÈ·µ»ØNULL£¬·ñÔò·µ»ØµÚÒ»¸ö²ÎÊý¡£
COALESCE Õâ ......
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨ÔÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2 Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......
oracle±íÖÐÓÐDateÀàÐ͵Ä×ֶΣ¬ÓÃPD×Ô¶¯Éú³É²âÊÔÊý¾Ý£¬¸ñʽΪ‘yyyy-mm-dd’£¬¶øoracleÖвåÈëDateÀàÐ͵Ä×ֶθñʽΪ'dd-mmÔÂ-yyyy'¡£Èç¹ûÊý¾ÝÁ¿ÉÙ£¬¿ÉÒÔÓÃto_date()£¬
to_date('2008-01-25 12:39:49','YYYY-MM-DD HH24:MI:SS')
µ«ÊDzâÊÔÓÃÊý¾ÝÓÐ10ÍòÌõ£¬Èç¹ûÊܶ¯È¥Ð´ÏÔÈ»ÊDz»Êµ¼ÊµÄ¡ ......
°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......