Oracle 控制文件 说明(二)

2014-11-24 18:01:14 · 作者: · 浏览: 1
hasStartedTa [0]


krvscm(+): hasValidSess [0]


krvscm(+): hasTxnConsistency[0]


krvscm(+): hasCleanlyShutdown [0]


krvscm(+): Generating new controlfile state from metadata


krvscm(+): Updating controlfile with new state


krvscm(+): New controlfile state


krvscm(+): kccdiflg [400001]kccdifl2 [1000]


krvscm(+): kccdi2ldscn[0x0000.00000000]


krvscm(+): kccdi2lrscn[0x0000.00000000]


krvscm(+): Updating SGA associated with controlfile state


krvscm(+): Validation complete


*** 2011-03-17 22:13:21.115


-- The following are current System-scope REDO Log Archival related


-- parameters and can be included in the database initializationfile.


--


-- LOG_ARCHIVE_DEST=''


-- LOG_ARCHIVE_DUPLEX_DEST=''


--


-- LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf


--


-- DB_UNIQUE_NAME="dave_st"


--


-- LOG_ARCHIVE_CONFIG='SEND, RECEIVE'


-- LOG_ARCHIVE_CONFIG='DG_CONFIG=("dave_pd")'


-- LOG_ARCHIVE_MAX_PROCESSES=2


-- STANDBY_FILE_MANAGEMENT=AUTO


-- STANDBY_ARCHIVE_DEST=/u01/archivelog


-- FAL_CLIENT=dave_st


-- FAL_SERVER=dave_pd


--


-- LOG_ARCHIVE_DEST_2='SERVICE=dave_pd'


-- LOG_ARCHIVE_DEST_2='OPTIONAL REOPEN=120 NODELAY'


-- LOG_ARCHIVE_DEST_2='LGWR NOAFFIRM NOEXPEDITE NOVERIFYASYNC=61440'


-- LOG_ARCHIVE_DEST_2='REGISTER NOALTERNATE NODEPENDENCY'


-- LOG_ARCHIVE_DEST_2='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'


-- LOG_ARCHIVE_DEST_2='DB_UNIQUE_NAME=dave_pd'


-- LOG_ARCHIVE_DEST_2='VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE)'


-- LOG_ARCHIVE_DEST_STATE_2=ENABLE


--


-- LOG_ARCHIVE_DEST_1='LOCATION=/u01/archivelog'


-- LOG_ARCHIVE_DEST_1='OPTIONAL REOPEN=300 NODELAY'


-- LOG_ARCHIVE_DEST_1='ARCH NOAFFIRM NOEXPEDITE NOVERIFY SYNC'


-- LOG_ARCHIVE_DEST_1='REGISTER NOALTERNATE NODEPENDENCY'


-- LOG_ARCHIVE_DEST_1='NOMAX_FAILURE NOQUOTA_SIZE NOQUOTA_USED'


-- LOG_ARCHIVE_DEST_1='DB_UNIQUE_NAME=dave_st'


-- LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'


-- LOG_ARCHIVE_DEST_STATE_1=ENABLE


--


-- Below are two sets of SQL statements, each of which creates a new


-- control file and uses it to open the database. The first setopens


-- the database with the NORESETLOGS option and should be used onlyif


-- the current versions of all online logs are available. The second


-- set opens the database with the RESETLOGS option and should beused


-- if online logs are unavailable.


-- The appropriate set of statements can be copiedfrom the trace into


-- a script file, edited as necessary, andexecuted when there is a


-- need to re-create the control file.


--


-- Set#1. NORESETLOGS case


--对使用noresetlogs 的说明


--


-- The following commands will create a new control file and use it


-- to open the database.


-- Data used by Recovery Manager will be lost.


-- Additional logs may be required for media recovery of offline


-- Use this only if the current versions of all online logs are


-- available.


-- After mounting the created controlfile, the following SQL


-- statement will place the database in the appropriate


-- protection mode:


-- ALTER DATABASE SET STANDBYDATABASE TO MAXIMIZE PERFORMANCE


STARTUP NOMOUNT


CREATE CONTROLFILE REUSE DATABASE "DAVE" NORESETLOGS ARCHIVELOG


MAXLOGFILES 16


MAXLOGMEMBERS 2


MAXDATAFILES 30


MAXINSTANCES 1


MAXLOGHISTORY 292


LOGFILE


GROUP 1'/u01/app/oracle/oradata/dave/redo01.log' SIZE 50M,


GROUP 2'/u01/app/oracle/oradata/dave/redo02.log' SIZE 50M,


GROUP 3'/u01/app/oracle/oradata/dave/redo03.log' SIZE 50M


-- STANDBY LOGFILE


DATAFILE


'/u01/app/oracle/oradata/dave/system01.dbf',


'/u01/