Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¿ØÖÆÎļþºÍ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
----------


Ïà¹ØÎĵµ£º

oracleȨÏÞÎÊÌ⼯ºÏ

1.oracleÉèÖò»Í¬È¨ÏÞµÄÓû§È¥·ÃÎÊͬһ±í¿Õ¼ä
1.create user testa identified by testa;
2.alter user testa default tablespace users temporary tablespace temp;
3.grant connect to testa;
4.grant select any table to testa;
2.ORACLEÖÐÉèÖÃͬһ¸öÓû§¶ÔÁ½¸ö±í¿Õ¼äµÄȨÏ޵ĴúÂë
alter user Óû§ quota unlimi ......

oracle µÄDMLÃüÁîµÄÏêϸ´¦Àí¹ý³Ì

Ô­ÎĵØÖ·£ºhttp://book.csdn.net/bookfiles/732/10073222578.shtml
¶ÔÓÚDMLÓï¾äÀ´Ëµ£¬Ö»ÒªÐÞ¸ÄÁËÊý¾Ý¿é£¬OracleÊý¾Ý¿â¾Í»á½«ÐÞ¸ÄÇ°µÄÊý¾Ý±£ÁôÏÂÀ´£¬±£´æÔÚundo segmentÀ¶øundo segmentÔò±£´æÔÚundo±í¿Õ¼äÀï¡£´ÓOracle 9iÆð£¬ÓÐÁ½ÖÖundoµÄ¹ÜÀí·½Ê½£º×Ô¶¯Undo¹ÜÀí£¨Automatic Undo Management£¬¼ò³ÆAUM£©ºÍÊÖ¹¤Undo¹ÜÀí£¨ ......

Oracle Split¹¦Äܺ¯Êý

ÔÚpl/sqlʱ¾­³£»áÅöµ½½«Ä³Ð©Ìض¨µÄ·ûºÅת»»³ÉÐÐ,Õ⹦ÄÜÏ൱ÓÚsplit.ÒÔÇ°ÔÚÍøÉÏÊÕ¼¯µÄsplitº¯ÊýÈçÏÂ:
CREATE OR REPLACE TYPE DJ_STR_SPLIT IS TABLE OF VARCHAR2 (4000);
CREATE OR REPLACE PACKAGE Dj_Function_API IS
module_  CONSTANT VARCHAR2(25) := 'FNDBAS';
lu_name_ CONSTANT VARCHAR2(25) := 'DjFuncti ......

Oracle¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ

°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
  Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......

OracleÊý¾Ý¿âDBFÎļþÎóɾ³ý½â¾ö·½°¸

·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ