UNDOCUMENTEDORACLE.docx

1、UNDOCUMENTED ORACLEUNDOCUMENTED ORACLE What They Didnt Teach You At ORACLE STARTUPD:ORANTDATABASESVRMGR30Oracle Server Manager Release 3.0.4.0.0 - Production(c) Copyright 1997, Oracle Corporation. All Rights Reserved.Oracle8 Enterprise Edition Release 8.0.4.0.0 - ProductionWith the Objects optionPL/

2、SQL Release 8.0.4.0.0 ProductionSVRMGR PROCESSREQPATHROTHERSVRMGR30.EXECREATED:orantDATABASEsqlnet.oraFile Not FoundAttributes:0000 Options:01000000SVRMGR CONNECT INTERNAL/ORACLEConnected.PROCESSREQUESTPATHOTHERoracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASEPW

3、DORCL.ORAOffs:512 Len:512oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOffs:512 Len:512SVRMGR STARTUP NOMOUNTORACLE instance started.Total System Global Area 11705004 bytesFixed Size 47788 bytesVariable Size 11173888 bytesDatabase Buffers 409600 by

4、tesRedo Buffers 73728 bytesPROCESSREQUESTPATHOTHERSVRMGR30.EXEREADD:orantDATABASEINITorcl.ORAOffs:0 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:1000 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:2000 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:3

5、000 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:4000 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:5000 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:6000 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:7000 Len:1000SVRMGR30.EXEFAST

6、IO_READD:orantDATABASEINITorcl.ORAOffs:7163 Len:1000SVRMGR30.EXEFASTIO_READD:orantDATABASEINITorcl.ORAOffs:7163 Len:1000oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOffs:512 Len:512oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOffs:0 Len:512oracle80.e

7、xeREADD:ORANTDATABASEPWDORCL.ORAOffs:512 Len:512SVRMGR ALTER DATABASE MOUNT;Statement processed.PROCESSREQPATHOTHERoracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:0 LEN:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle

8、80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:0 LEN:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:51200 LEN:2048orac

9、le80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:51200 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:2048 LEN:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOFFS:38912 LEN:

10、2048oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOFFS:0 LEN:512oracle80.exeREADD:ORANTDATABASEPWDORCL.ORAOFFS:512 LEN:512SVRMGR ALTER DATABASE OPEN;Statement processed.PROCESSREQPATHOTHERoracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:53248 L

11、en:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:65536 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:53248 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:65536 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:69

12、632 Len:2048oracle80.exeREADD:ORANTDATABASEA1.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:53248 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASEA1.ORAOffs:2048 Len:20

13、48oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:53248 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASEA1.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:1079296 Len

14、:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:38912 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:43008 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:65536 Len:2048oracle80.exeREADD:ORANTDATABASELOG1ORCL.ORAOffs:

15、0 Len:512oracle80.exeREADD:ORANTDATABASELOG1ORCL.ORAOffs:512 Len:512oracle80.exeWRITED:ORANTDATABASELOG1ORCL.ORAOffs:512 Len:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:43008 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOffs:45056 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs

16、:65536 Len:2048oracle80.exeREADD:ORANTDATABASELOG2ORCL.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASELOG2ORCL.ORAOffs:512 Len:512oracle80.exeWRITED:ORANTDATABASELOG2ORCL.ORAOffs:512 Len:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:45056 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOff

17、s:45056 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:65536 Len:2048oracle80.exeREADD:ORANTDATABASELOG2ORCL.ORAOffs:0 Len:512oracle80.exeREADD:ORANTDATABASELOG2ORCL.ORAOffs:512 Len:512oracle80.exeWRITED:ORANTDATABASELOG2ORCL.ORAOffs:512 Len:512oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOff

18、s:45056 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOffs:45056 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:53248 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:2048 Len:2048oracle80.exeWRITED:ORANTDATABASEDBS1ORCL.ORAOffs:2048 Len:2048oracle80.exeREADD:ORANTDATABASEA1.OR

19、AOffs:2048 Len:2048oracle80.exeWRITED:ORANTDATABASEA1.ORAOffs:2048 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOffs:51200 Len:2048oracle80.exeREADD:ORANTDATABASECTL1ORCL.ORAOffs:38912 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOffs:6144 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1OR

20、CL.ORAOffs:40960 Len:2048oracle80.exeWRITED:ORANTDATABASECTL1ORCL.ORAOffs:2048 Len:2048oracle80.exeWRITED:ORANTDATABASELOG2ORCL.ORAOffs:40960 Len:512oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:1079296 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:720896 Len:2048oracle80.exeREADD:ORANTD

21、ATABASEDBS1ORCL.ORAOffs:720896 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:722944 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:724992 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:727040 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:729088 Len:2048oracle80.

22、exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:731136 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:733184 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:735232 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:737280 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:739328 Le

23、n:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:741376 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:456704 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:458752 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:344064 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.OR

24、AOffs:241664 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:110592 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:108544 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:487424 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:116736 Len:2048oracle80.exeREADD:ORANTDATA

25、BASEDBS1ORCL.ORAOffs:112640 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:114688 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:118784 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:120832 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:122880 Len:2048oracle80.exe

26、READD:ORANTDATABASEDBS1ORCL.ORAOffs:124928 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:126976 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:129024 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:346112 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:131072 Len:2

27、048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:133120 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:135168 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:137216 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:139264 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOf

28、fs:1079296 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:4096 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:436224 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:323584 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:538624 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:303104 Len:2048oracle80.exeREADD:ORANTDATABASEDBS1ORCL.ORAOffs:4