資料庫第一次resetlogs是發生在db建立時1

cow977發表於2012-03-12

看到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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章