现在换所有的数据都导出来了,现在我想知道为什么~~~
下面这段日志是我在服务器启动后,然后打开资源管理器关闭oracle.exe进程,然后在命令行输入oracle.exe ***启动,最后我在sqlplus中打开数据库然后关闭,可以正常关闭。
Stopping background process QMNC
Tue Nov 27 19:25:30 2007
Stopping background process CJQ0
Tue Nov 27 19:26:32 2007
Stopping background process MMNL
Tue Nov 27 19:26:33 2007
Stopping background process MMON
Tue Nov 27 19:26:34 2007
Shutting down instance (normal)
License high water mark = 3
Tue Nov 27 19:26:34 2007
Stopping Job queue slave processes
Tue Nov 27 19:26:34 2007
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Tue Nov 27 19:26:38 2007
ALTER DATABASE CLOSE NORMAL
Tue Nov 27 19:26:38 2007
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Nov 27 19:26:38 2007
Shutting down archive processes
Archiving is disabled
Tue Nov 27 19:26:38 2007
ARCH shutting down
Tue Nov 27 19:26:38 2007
ARC0: Archival stopped
Tue Nov 27 19:26:39 2007
Thread 1 closed at log sequence 118
Successful close of redo thread 1
Tue Nov 27 19:26:39 2007
ARCH shutting down
Tue Nov 27 19:26:39 2007
ARC1: Archival stopped
Tue Nov 27 19:26:40 2007
Completed: ALTER DATABASE CLOSE NORMAL
Tue Nov 27 19:26:40 2007
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1090
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 activ
下面这段日志是我在服务器启动后,我在sqlplus中关闭数据库,但结果不能正常关闭数据库
Shutting down instance: further logons disabled
Tue Nov 27 19:16:56 2007
Stopping background process QMNC
Tue Nov 27 19:16:56 2007
Stopping background process CJQ0
Tue Nov 27 19:16:58 2007
Stopping background process MMNL
Tue Nov 27 19:16:59 2007
Stopping background process MMON
Tue Nov 27 19:17:01 2007
Shutting down instance (normal)
License high water mark = 37
Tue Nov 27 19:17:01 2007
Stopping Job queue slave processes
Tue Nov 27 19:17:01 2007
Job queue slave processes stopped
Tue Nov 27 19:22:10 2007
Private_strands 7 at log switch
Thread 1 advanced to log sequence 117
Current log# 3 seq# 117 mem# 0: D:\ORACLE\ORADATA\CQCW\REDO03.LOG
Tue Nov 27 19:22:10 2007
ARC1: Evaluating archive log 2 thread 1 sequence 116
Committing creation of archivelog 'F:\ARCHIVE\ARC00116_0639334986.001'
Tue Nov 27 19:22:21 2007
Active process 2976 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 1996 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 1316 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3856 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 720 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3852 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2112 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2324 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 388 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2184 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2936 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3016 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3496 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2844 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3180 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2548 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3952 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3128 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3120 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 968 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2632 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2696 user 'SYSTEM' program 'ORACLE.EXE (J000)'
Active process 748 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2364 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 384 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3236 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 3668 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2228 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
Active process 2576 user 'SYSTEM' program 'ORACLE.EXE (SHAD)'
SHUTDOWN: waiting for logins to complete.