切換歸檔模式後後臺程式的情況
做了個小實驗,看看將資料庫改為歸檔模式的情況下,後臺程式的啟動情況。
SQL> select distinct name,description from v$bgprocess where paddr<>'00'
NAME DESCRIPTION
----- ----------------------------------------------------------------
CKPT checkpoint
QMNC AQ Coordinator
MMNL Manageability Monitor Process 2
PSP0 process spawner 0
DBW0 db writer process 0
SMON System Monitor Process
RECO distributed recovery
PMON process cleanup
CJQ0 Job Queue Coordinator
LGWR Redo etc.
MMON Manageability Monitor Process
----- ----------------------------------------------------------------
CKPT checkpoint
QMNC AQ Coordinator
MMNL Manageability Monitor Process 2
PSP0 process spawner 0
DBW0 db writer process 0
SMON System Monitor Process
RECO distributed recovery
PMON process cleanup
CJQ0 Job Queue Coordinator
LGWR Redo etc.
MMON Manageability Monitor Process
NAME DESCRIPTION
----- ----------------------------------------------------------------
MMAN Memory Manager
----- ----------------------------------------------------------------
MMAN Memory Manager
12 rows selected.
--非歸檔模式下啟動了12個程式
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog;
Fixed Size 1247876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> select distinct name,description from v$bgprocess where paddr<>'0
NAME DESCRIPTION
----- ----------------------------------------------------------------
ARC2 Archival Process 2
CKPT checkpoint
QMNC AQ Coordinator
MMNL Manageability Monitor Process 2
PSP0 process spawner 0
DBW0 db writer process 0
SMON System Monitor Process
RECO distributed recovery
PMON process cleanup
CJQ0 Job Queue Coordinator
LGWR Redo etc.
----- ----------------------------------------------------------------
ARC2 Archival Process 2
CKPT checkpoint
QMNC AQ Coordinator
MMNL Manageability Monitor Process 2
PSP0 process spawner 0
DBW0 db writer process 0
SMON System Monitor Process
RECO distributed recovery
PMON process cleanup
CJQ0 Job Queue Coordinator
LGWR Redo etc.
NAME DESCRIPTION
----- ----------------------------------------------------------------
MMON Manageability Monitor Process
MMAN Memory Manager
ARC0 Archival Process 0
ARC1 Archival Process 1
----- ----------------------------------------------------------------
MMON Manageability Monitor Process
MMAN Memory Manager
ARC0 Archival Process 0
ARC1 Archival Process 1
15 rows selected.
--改為歸檔模式後,後臺啟動了15個程式,多出的三個程式是ARC0 ,ARC1,ARC2
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1247876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database noarchivelog
2 ;
Fixed Size 1247876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
Database mounted.
SQL> alter database noarchivelog
2 ;
Database altered.
SQL> alter database open;
Database altered.
SQL> select distinct name,description from v$bgprocess where paddr<>'00';
NAME DESCRIPTION
----- ----------------------------------------------------------------
CKPT checkpoint
QMNC AQ Coordinator
MMNL Manageability Monitor Process 2
PSP0 process spawner 0
DBW0 db writer process 0
SMON System Monitor Process
RECO distributed recovery
PMON process cleanup
CJQ0 Job Queue Coordinator
LGWR Redo etc.
MMON Manageability Monitor Process
----- ----------------------------------------------------------------
CKPT checkpoint
QMNC AQ Coordinator
MMNL Manageability Monitor Process 2
PSP0 process spawner 0
DBW0 db writer process 0
SMON System Monitor Process
RECO distributed recovery
PMON process cleanup
CJQ0 Job Queue Coordinator
LGWR Redo etc.
MMON Manageability Monitor Process
NAME DESCRIPTION
----- ----------------------------------------------------------------
MMAN Memory Manager
----- ----------------------------------------------------------------
MMAN Memory Manager
12 rows selected.
--再切換回非歸檔模式,後臺程式又變為12個。
--再切換回非歸檔模式,後臺程式又變為12個。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26084062/viewspace-750496/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 歸檔模式與非歸檔模式的切換模式
- VCS 切換後資料庫無法歸檔資料庫
- ORACLE RAC模式下歸檔模式和非歸檔模式的切換方法Oracle模式
- Linux 程式前後臺切換|管理Linux
- Oracle 歸檔和非歸檔模式之間的切換Oracle模式
- Oracle學習系列—歸檔模式的切換Oracle模式
- Oracle資料庫切換歸檔模式Oracle資料庫模式
- Oracle資料庫歸檔模式的切換ELOracle資料庫模式
- App切換到後臺後如何保持持續定位?APP
- Oracle RAC 歸檔與非歸檔切換Oracle
- Dataguard(Standby) 後臺程式及歸檔應用瞭解
- oracle 8i的歸檔與不歸檔切換Oracle
- oracle 歸檔切換頻率Oracle
- oracle10g 歸檔模式和非歸檔模式的轉換Oracle模式
- oracle dg 歸檔日誌恢復情況Oracle
- Sqlserver 映象切換操作並檢查映象同步情況SQLServer
- 切換到ZSH以後遇到的坑
- 關於歸檔日誌的切換測試
- oracle歸檔切換以及歸檔日誌滿報錯問題Oracle
- RMAN恢復歸檔但是歸檔放到ASM中,ASM已經掛掉的情況ASM
- dataguard 切換後更換IP,service_name
- db_ha叢集安裝後的自動切換及切換後的判斷步驟說明文件
- 對歸檔模式下CLEAR 未歸檔日誌後恢復資料庫的一點看法模式資料庫
- 歸檔模式無備份丟失資料檔案後恢復模式
- 歸檔模式有備份丟失資料檔案後恢復模式
- 建立後臺任務的兩種程式碼模式模式
- 如何在cmd視窗關閉情況下保持後臺啟動docsify?
- Oracle控制檔案在缺失歸檔日誌的情況下的恢復Oracle
- 將程式在後臺執行和殺掉後臺的程式
- Jboss 後臺執行模式模式
- 暫時記錄,以後歸檔。
- 後端做了負載均衡的情況下,前端怎麼做分片上傳檔案?後端負載前端
- home鍵監聽(Android應用切換到後臺監聽)Android
- ORACLE後臺程式Oracle
- oracle 後臺程式Oracle
- Clusterware 後臺程式
- iOS感測器:App前後臺切換後,獲取敏感資訊使用touch ID進行校驗iOSAPP
- 歸檔模式有備份丟失控制檔案和資料檔案後恢復模式