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

cow977發表於2012-03-12

以上是第一次啟動例項,從模板恢復資料庫。

第二次啟動,建立控制檔案。

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

相關文章