oracle 正常關閉shutdown immediate與開啟open資料庫alert
---正常關庫
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
--正常關庫的alert log
Fri Jun 21 04:26:47 2013
Shutting down instance (immediate) --正常關閉
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
Fri Jun 21 04:26:52 2013
SMON: disabling tx recovery
SMON: disabling cache recovery
Fri Jun 21 04:26:52 2013
Shutting down archive processes
Archiving is disabled
Fri Jun 21 04:26:52 2013
ARCH shutting down
ARC3: Archival stopped
Fri Jun 21 04:26:52 2013
ARCH shutting down
ARC2: Archival stopped
Fri Jun 21 04:26:52 2013
ARCH shutting down
ARC1: Archival stopped
Fri Jun 21 04:26:52 2013
ARCH shutting down
ARC0: Archival stopped
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Completed: ALTER DATABASE CLOSE NORMAL
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jun 21 04:26:54 2013
Stopping background process VKTM:
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jun 21 04:26:57 2013
Instance shutdown complete --正常關閉結束
---正常啟動
SQL> startup
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1336232 bytes
Variable Size 159386712 bytes
Database Buffers 146800640 bytes
Redo Buffers 6336512 bytes
Database mounted.
Database opened.
---正常啟動alert log
Fri Jun 21 04:30:08 2013
Starting ORACLE instance (normal) --正常啟動開始
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Autotune of undo retention is turned on.
IMODE=BR
ILAT =27
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /oracle/app/oracle/product/11.2.0/dbhome_1/dbs/spfilezxy.ora
System parameters with non-default values:
processes = 150
sga_max_size = 300M
sga_target = 228M
control_files = "/oracle/app/oracle/oradata/zxy/new1.ctl"
control_files = "/oracle/app/oracle/oradata/zxy/new2.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest = "/oracle/arch"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=zxyXDB)"
session_cached_cursors = 200
job_queue_processes = 0
cursor_sharing = "FORCE"
audit_file_dest = "/oracle/app/oracle/admin/zxy/adump"
audit_trail = "DB"
db_name = "zxy"
open_cursors = 300
pga_aggregate_target = 75M
diagnostic_dest = "/oracle/app/oracle"
Fri Jun 21 04:30:10 2013
PMON started with pid=2, OS id=4079
Fri Jun 21 04:30:10 2013
VKTM started with pid=3, OS id=4081 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Fri Jun 21 04:30:10 2013
GEN0 started with pid=4, OS id=4085
Fri Jun 21 04:30:10 2013
DIAG started with pid=5, OS id=4087
Fri Jun 21 04:30:11 2013
DBRM started with pid=6, OS id=4089
Fri Jun 21 04:30:11 2013
PSP0 started with pid=7, OS id=4091
Fri Jun 21 04:30:11 2013
DIA0 started with pid=8, OS id=4093
Fri Jun 21 04:30:11 2013
MMAN started with pid=9, OS id=4095
Fri Jun 21 04:30:11 2013
DBW0 started with pid=10, OS id=4097
Fri Jun 21 04:30:11 2013
LGWR started with pid=11, OS id=4099
Fri Jun 21 04:30:11 2013
CKPT started with pid=12, OS id=4101
Fri Jun 21 04:30:11 2013
SMON started with pid=13, OS id=4103
Fri Jun 21 04:30:11 2013
RECO started with pid=14, OS id=4105
Fri Jun 21 04:30:11 2013
MMON started with pid=15, OS id=4107
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jun 21 04:30:11 2013
MMNL started with pid=16, OS id=4109
starting up 1 shared server(s) ...
ORACLE_BASE not set in environment. It is recommended
that ORACLE_BASE be set in the environment
Reusing ORACLE_BASE from an earlier startup = /oracle/app/oracle
Fri Jun 21 04:30:11 2013
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 1702482835
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Fri Jun 21 04:30:16 2013
ALTER DATABASE OPEN
LGWR: STARTING ARCH PROCESSES
Fri Jun 21 04:30:16 2013
ARC0 started with pid=20, OS id=4121
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /oracle/app/oracle/oradata/zxy/newredo01.log
Successful open of redo thread 1
Fri Jun 21 04:30:17 2013
ARC1 started with pid=21, OS id=4123
Fri Jun 21 04:30:17 2013
ARC2 started with pid=22, OS id=4125
Fri Jun 21 04:30:17 2013
ARC3 started with pid=23, OS id=4127
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Completed: ALTER DATABASE OPEN ---正常開啟結束
Fri Jun 21 04:30:19 2013
QMNC started with pid=24, OS id=4129
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-764537/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- shutdown immediate 持久無法關閉資料庫之解決方案資料庫
- 11G的SYS連線阻止SHUTDOWN IMMEDIATE關閉資料庫資料庫
- Oracle資料庫的啟動與關閉Oracle資料庫
- zt_Resolving Shutdown Immediate Hang Situations_shutdown immediate關庫慢
- 資料庫無法shutdown immediate的案例資料庫
- 關閉資料庫遇到SHUTDOWN: Active processes prevent shutdown operation資料庫
- shutdown immediate物理備庫長時間無法關閉案列
- 開啟關閉oracle資料庫附加日誌Oracle資料庫
- shutdown immediate alert出現SHUTDOWN: waiting for active calls to complete.AI
- 啟動/關閉與冷備份Oracle資料庫Oracle資料庫
- 【Shutdown】同一會話存在未提交事務時使用immediate選項無法關閉資料庫會話資料庫
- IndexedDB.open()開啟與新建資料庫Index資料庫
- IndexedDB.open() 開啟與新建資料庫Index資料庫
- Oracle資料庫的啟動和關閉Oracle資料庫
- 根據Alert日誌查詢資料庫啟動、關閉時間資料庫
- oracle資料庫的啟動關閉與各種服務Oracle資料庫
- oracle資料庫的啟動與關閉過程詳解Oracle資料庫
- RAC 資料庫的啟動與關閉資料庫
- 因歸檔日誌無法歸檔造成的 oracle shutdown immediate無法關閉Oracle
- ORACLE資料庫的啟動和關閉(轉)Oracle資料庫
- ORACLE DSG資料同步軟體程式導致資料庫無法正常關閉Oracle資料庫
- 開啟或關閉oracle資料庫的閃回功能步驟Oracle資料庫
- 【YashanDB知識庫】資料庫審計shutdown immediate操作導致資料庫異常退出資料庫
- 安全關閉Oracle資料庫Oracle資料庫
- Oracle 資料庫例項啟動關閉過程Oracle資料庫
- 隨系統啟動關閉的oracle資料庫Oracle資料庫
- 資料庫啟動和關閉資料庫
- 開啟與關閉oracle的歸檔Oracle
- 啟動、關閉與資料庫的特殊狀態資料庫
- 資料庫shutdown immediate,control.ctl 檔案不能刪除資料庫
- Oracle10g RAC (ASM) 資料庫及服務開啟關閉OracleASM資料庫
- oracle資料庫啟動從nomount到openOracle資料庫
- oracle啟動與關閉Oracle
- ORACLE資料庫的啟動和關閉之二(轉)Oracle資料庫
- Oracle資料庫的幾種啟動和關閉方式Oracle資料庫
- 深刻理解Oracle資料庫的啟動和關閉Oracle資料庫
- 深刻理解 oracle 資料庫的啟動和關閉Oracle資料庫
- 資料庫自動啟動關閉資料庫