資料庫第一次resetlogs是發生在db建立時1
看到warehouse“資料庫第一次resetlogs是發生在db建立時”一文,對此也進行了一翻研究,最後在alert.log檔案中,找到了根據,以下是資料庫建立過程中的日誌:
Thu Feb 16 11:47:09 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/cfgtoollogs/dbca/cow977/initcow977TempOMF.ora on machine rhel5
System parameters with non-default values:
processes = 150
memory_target = 1568M
control_files = "/home/oracle/cfgtoollogs/dbca/cow977/tempControl.ctl"
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 = "seeddata"
db_unique_name = "cow977"
open_cursors = 300
diagnostic_dest = "/home/oracle"
Thu Feb 16 11:47:10 2012
PMON started with pid=2, OS id=6355
Thu Feb 16 11:47:10 2012
VKTM started with pid=3, OS id=6357 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Feb 16 11:47:10 2012
GEN0 started with pid=4, OS id=6361
Thu Feb 16 11:47:10 2012
DIAG started with pid=5, OS id=6363
Thu Feb 16 11:47:10 2012
DBRM started with pid=6, OS id=6365
Thu Feb 16 11:47:10 2012
PSP0 started with pid=7, OS id=6367
Thu Feb 16 11:47:10 2012
DIA0 started with pid=8, OS id=6369
Thu Feb 16 11:47:10 2012
MMAN started with pid=9, OS id=6371
Thu Feb 16 11:47:10 2012
DBW0 started with pid=10, OS id=6373
Thu Feb 16 11:47:10 2012
LGWR started with pid=11, OS id=6375
Thu Feb 16 11:47:10 2012
CKPT started with pid=12, OS id=6377
Thu Feb 16 11:47:10 2012
SMON started with pid=13, OS id=6379
Thu Feb 16 11:47:10 2012
RECO started with pid=14, OS id=6381
Thu Feb 16 11:47:11 2012
MMON started with pid=15, OS id=6383
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Feb 16 11:47:11 2012
MMNL started with pid=16, OS id=6385
starting up 2 shared server(s) ...
ORACLE_BASE from environment = /home/oracle
Thu Feb 16 11:47:11 2012
ALTER DATABASE MOUNT
Set as converted control file due to db_unique_name mismatch
Changing di2dbun from seeddata to cow977
Successful mount of redo thread 1, with mount id 4104053631
Database mounted in Exclusive Mode
Lost write protection disabled
Create Relation IPS_PACKAGE_UNPACK_HISTORY
Completed: ALTER DATABASE MOUNT
Full restore complete of datafile 4 to datafile copy /home/oracle/oradata/COW977/datafile/o1_mf_users_7mrz254l_.dbf. Elapsed time: 0:00:00
checkpoint is 945183
Full restore complete of datafile 3 to datafile copy /home/oracle/oradata/COW977/datafile/o1_mf_undotbs1_7mrz24yt_.dbf. Elapsed time: 0:00:02
checkpoint is 945183
Thu Feb 16 11:48:29 2012
Full restore complete of datafile 2 to datafile copy /home/oracle/oradata/COW977/datafile/o1_mf_sysaux_7mrz24vh_.dbf. Elapsed time: 0:01:10
checkpoint is 945183
last deallocation scn is 944925
Thu Feb 16 11:48:50 2012
Full restore complete of datafile 1 to datafile copy /home/oracle/oradata/COW977/datafile/o1_mf_system_7mrz24r2_.dbf. Elapsed time: 0:01:32
checkpoint is 945183
last deallocation scn is 940169
Shutting down instance (abort)
License high water mark = 1
USER (ospid: 6394): terminating the instance
Instance terminated by USER, pid = 6394
Thu Feb 16 11:48:51 2012
Instance shutdown complete
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-718328/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 資料庫第一次resetlogs是發生在db建立時資料庫
- 資料庫第一次resetlogs是發生在db建立時3資料庫
- 資料庫第一次resetlogs是發生在db建立時2資料庫
- db2 建立資料庫與資料放置DB2資料庫
- DB2建立資料庫,建立表空間DB2資料庫
- 資料庫resetlogs後進行rman恢復1資料庫
- DB2建立聯邦資料庫DB2資料庫
- [DB2]資料庫建立實驗DB2資料庫
- 分析發生在過去的資料庫效能問題資料庫
- 建立oracle資料庫(1)Oracle資料庫
- 關於開啟資料庫時的resetlogs選項資料庫
- 建立資料庫時使用schema資料庫
- Oracle資料庫恢復之resetlogsOracle資料庫
- CQL #1:SQLChain 資料庫建立流程SQLAI資料庫
- ORACLE建立資料庫時無法建立目錄Oracle資料庫
- 10G建立資料庫時發生的錯誤資料庫
- 10可以穿越resetlogs恢復資料庫!資料庫
- DB資料庫面試資料庫面試
- SQLServer資料庫中建立臨時表SQLServer資料庫
- db2 資料庫DB2資料庫
- 建立 Oracle10g ASM 資料庫(1)OracleASM資料庫
- 使用RESETLOGS重建控制檔案恢復資料庫資料庫
- 資料庫resetlogs後進行rman恢復7資料庫
- 資料庫resetlogs後進行rman恢復6資料庫
- 資料庫resetlogs後進行rman恢復5資料庫
- 資料庫resetlogs後進行rman恢復4資料庫
- 資料庫resetlogs後進行rman恢復3資料庫
- 資料庫resetlogs後進行rman恢復2資料庫
- 建立資料庫資料庫
- ORACLE資料庫修改資料庫名db_nameOracle資料庫
- 1 小時學會 MySQL 資料庫MySql資料庫
- 手工建立資料庫及刪除資料庫示例--附建庫時alert日誌資料庫
- DB2_資料庫角色DB2資料庫
- mysql 建立 資料庫時指定編碼很重要MySql資料庫
- MySQL 建立資料庫 建立表MySql資料庫
- 使用RESETLOGS重建控制檔案恢復資料庫(二)資料庫
- 使用_allow_resetlogs_corruption強制開啟資料庫資料庫
- 第一次手工建資料庫資料庫