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

Oracle ¿ØÖÆÎļþ

Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECORDS
BACKUP DATAFILE RECORDS
BACKUP LOG RECORDS
DATAFILE COPY RECORDS
BACKUP DATAFILE CORRUPTION RECORDS
DATAFILE COPY CORRUPTION RECORDS
DELETION RECORDS
PROXY COPY RECORDS
INCARNATION RECORDS
¶þ.¿ÉÒÔͨ¹ýdump¿´µ½ ¿ØÖÆÎļþÄÚ
·½·¨1.Ö±½Ódump controlfile£ºalter system set events 'immediate trace name controlf level 10'
·½·¨2.  alter database backup controlfile to trace
     ²é¿´UDMPĿ¼ÏµÄ<SID>_ora_<PID>.trcÎļþ
·½·¨3.alter database backup controlfile to ÎļþÃû
    ²éѯ¸ÃÎļþ
SQL>select name from v$controlfile     
SQL>show parameter user_dump_dest
ÔÚÖ¸¶¨µÄĿ¼Ï»áÕÒµ½¸Õ²úÉúµÄtrcÎļþ£¬Í¨¹ýÈÕÆÚ¿ÉÒÔ¿´³öÄǸöÊǸղúÉúµÄ¡£
Èý. ¿ØÖÆÎļþµÄÖØ½¨£ºCREATE CONTROLFILE SET/reuse DATABASE SID RESETLOGS/NOresetlogs NOARCHIVELOG/archivelong
ORA-00205: error in identifying control file, check alert log for more info
µ±Èý¸ö¿ØÖÆÎļþ¶¼ÒÑË𻵣¬ÓÖûÓпØÖÆÎļþµÄ±¸·Ý£¬ÎÒÃÇÖ»ÄܲÉÈ¡ÖØ½¨¿ØÖÆÎļþµÄ×ö·¨¡£
SQL> startup nomount
ORACLE instance started.
Total System Global Area  268435456 bytes
Fixed Size                  1266968 bytes
Variable Size              88083176 bytes
Database Buffers          176160768 bytes
Redo Buffers                2924544 bytes
SQL> create controlfile reuse database woody noresetlogs archivelog
  2  LOGFILE
  3  GROUP 1 '/u01/app/oracle/oradata/woody/redo01.lo


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLEËøÐÅÏ¢

²é¿´±»ËøµÄ±í
select   p.spid,a.serial#,
c.object_name,b.session_id,b.oracle_username,b.os_user_name   from  
v$process   p,v$session   a,   v$locked_object   b,all_objects   c  
where   p.addr=a.p ......

Oracle10g r1ÔÚLINUX OS4Éϵݲװ

°²×°oralce10g R1(10.1)²½Öè·½·¨£º
µÚÒ»²¿·Ö£º
Ò».  Ó²¼þ»·¾³£º
   1. RAM£ºÖÁÉÙ512M
    2.  ½»»»·ÖÇø´óСÖÁÉÙ1G£¨»òÕßÊÇÄÚÔÚµÄ2±¶£©
   3./tmpĿ¼ ÖÁÉÙÓÐ400M¿ÕÏпռä
   4. oracleÈí¼þ°²×°¿Õ¼äÖÁÉÙÔÚ1.5G--3GÖ®¼ä£¨ÒÀ¾Ý°²×°oracleÀàÐͶø¶¨£©
 &nbs ......

oracle sequenceÖµÖØÖûØ1

declare 
  n   number(10); 
  tsql   varchar2(100); 
  begin 
  select   test_seq.nextval   into   n   from   dual; 
  n:=-(n-1); 
  tsql:='alter   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ