oracle 10g data guard - Oracle / »ù´¡ºÍ¹ÜÀí
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES 14 NO 14 YES ÔÚStandby·þÎñÆ÷ÉÏÖ´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 YES 14 YES ÎÒÏëÖ»ÊdzöÏÖÔÚPrimary·þÎñÆ÷ÉÏÕâ¸öÏÖÏóÊÇʲôÔÒò£¿
°ï¶¥£¡ ÄãÓжà¸ö¹éµµÄ¿±ê. ÎҲ£¬Ó¦¸ÃÓÐ2¸ölog_archive_dest£¬ÄÇ×é״̬ÊÇNOµÄ13£¬14ÊÇÔõô»ØÊ£¬¸ßÈËÖ¸½Ì£¡ ¸ßÊÖ,ѧϰ!ÒýÓà 13 NO 13 YES 14 NO 14 YES Ò»¸öÊDZ¾µØµÄ¹éµµÎļþ£¬Ò»¸öÊÇStandbyµÄ¡£ ±¾µØµÄ²»ÐèÒª½øÐÐapply. ËùÒÔÏÔʾΪNO¡£ ------------------------------------------------------------------------------ Blog£º http://blog.csdn¡¡ Õ⼸Ììæ£¬½áÌù¸ø4Â¥·ÖÁË
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......