資料庫第一次resetlogs是發生在db建立時2
以上是第一次啟動例項,從模板恢復資料庫。
第二次啟動,建立控制檔案。
Thu Feb 16 11:48:52 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
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 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in client-side pfile /home/oracle/admin/cow977/pfile/init.ora on machine rhel5
System parameters with non-default values:
processes = 150
memory_target = 1568M
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=/home/oracle/archive/cow977"
log_archive_format = "%t_%s_%r.dbf"
db_create_file_dest = "/home/oracle/oradata"
db_recovery_file_dest = "/home/oracle/flash_recovery_area"
db_recovery_file_dest_size= 3882M
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(protocol=TCP)"
shared_servers = 2
max_shared_servers = 5
max_dispatchers = 5
audit_file_dest = "/home/oracle/admin/cow977/adump"
audit_trail = "DB"
db_name = "cow977"
open_cursors = 300
diagnostic_dest = "/home/oracle"
Thu Feb 16 11:48:53 2012
PMON started with pid=2, OS id=6468
Thu Feb 16 11:48:53 2012
VKTM started with pid=3, OS id=6470 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Feb 16 11:48:53 2012
GEN0 started with pid=4, OS id=6474
Thu Feb 16 11:48:53 2012
DIAG started with pid=5, OS id=6476
Thu Feb 16 11:48:53 2012
DBRM started with pid=6, OS id=6478
Thu Feb 16 11:48:53 2012
PSP0 started with pid=7, OS id=6480
Thu Feb 16 11:48:53 2012
DIA0 started with pid=8, OS id=6482
Thu Feb 16 11:48:53 2012
MMAN started with pid=9, OS id=6484
Thu Feb 16 11:48:53 2012
DBW0 started with pid=10, OS id=6486
Thu Feb 16 11:48:53 2012
LGWR started with pid=11, OS id=6488
Thu Feb 16 11:48:53 2012
CKPT started with pid=12, OS id=6490
Thu Feb 16 11:48:53 2012
SMON started with pid=13, OS id=6492
Thu Feb 16 11:48:53 2012
RECO started with pid=14, OS id=6494
Thu Feb 16 11:48:53 2012
MMON started with pid=15, OS id=6496
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Feb 16 11:48:53 2012
MMNL started with pid=16, OS id=6498
starting up 2 shared server(s) ...
ORACLE_BASE from environment = /home/oracle
Thu Feb 16 11:48:54 2012
Create controlfile reuse set database "cow977"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/home/oracle/oradata/COW977/datafile/o1_mf_system_7mrz24r2_.dbf',
'/home/oracle/oradata/COW977/datafile/o1_mf_sysaux_7mrz24vh_.dbf',
'/home/oracle/oradata/COW977/datafile/o1_mf_undotbs1_7mrz24yt_.dbf',
'/home/oracle/oradata/COW977/datafile/o1_mf_users_7mrz254l_.dbf'
LOGFILE GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
GROUP 3 SIZE 51200K RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Successful mount of redo thread 1, with mount id 4060246374
Completed: Create controlfile reuse set database "cow977"
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
Datafile
'/home/oracle/oradata/COW977/datafile/o1_mf_system_7mrz24r2_.dbf',
'/home/oracle/oradata/COW977/datafile/o1_mf_sysaux_7mrz24vh_.dbf',
'/home/oracle/oradata/COW977/datafile/o1_mf_undotbs1_7mrz24yt_.dbf',
'/home/oracle/oradata/COW977/datafile/o1_mf_users_7mrz254l_.dbf'
LOGFILE GROUP 1 SIZE 51200K,
GROUP 2 SIZE 51200K,
GROUP 3 SIZE 51200K RESETLOGS
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 1
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: 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
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Stopping background process VKTM:
Thu Feb 16 11:49:01 2012
Instance shutdown complete
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-718329/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 資料庫第一次resetlogs是發生在db建立時資料庫
- 資料庫第一次resetlogs是發生在db建立時3資料庫
- 資料庫第一次resetlogs是發生在db建立時1資料庫
- db2 建立資料庫與資料放置DB2資料庫
- DB2建立聯邦資料庫DB2資料庫
- [DB2]資料庫建立實驗DB2資料庫
- DB2建立資料庫,建立表空間DB2資料庫
- db2 資料庫DB2資料庫
- DB2_資料庫角色DB2資料庫
- 資料庫resetlogs後進行rman恢復2資料庫
- 分析發生在過去的資料庫效能問題資料庫
- DB2 資料庫日常管理DB2資料庫
- 關於開啟資料庫時的resetlogs選項資料庫
- DB2查詢資料庫大小DB2資料庫
- DB2資料庫配置問題??DB2資料庫
- db2pd 監控資料庫DB2資料庫
- 建立資料庫時使用schema資料庫
- DB2 資料庫中的資料型別DB2資料庫資料型別
- 2 建立和配置資料庫資料庫
- 資料庫廠商的發展歷史之DB2資料庫DB2
- DB2_建立備份恢復使用自動儲存的資料庫DB2資料庫
- DB2中安裝sample資料庫和TOLLSDB資料庫DB2資料庫
- Oracle資料庫恢復之resetlogsOracle資料庫
- DB2___安裝db2客戶端並連線到db2資料庫DB2客戶端資料庫
- DB2資料庫中的各資料型別DB2資料庫資料型別
- 監控DB2資料庫指令碼DB2資料庫指令碼
- DB2資料庫的解除安裝DB2資料庫
- 常見資料庫系統之比較 - DB2資料庫(轉)資料庫DB2
- DB2建立DB linkDB2
- ORACLE建立資料庫時無法建立目錄Oracle資料庫
- 10G建立資料庫時發生的錯誤資料庫
- 10可以穿越resetlogs恢復資料庫!資料庫
- DB資料庫面試資料庫面試
- 2 Day DBA-使用DBCA建立和管理資料庫—使用DBCA建立資料庫資料庫
- DB2資料庫適配NC65DB2資料庫
- DB2--資料庫管理系統簡介DB2資料庫
- db2備份和恢復資料庫DB2資料庫
- 資料庫對比SQL SERVER 、 ORACLE、DB2資料庫SQLServerOracleDB2