db_name = "CSZLS"
instance_name = CSZLS
service_names = CSZLS
db_files = 1024
control_files = ("e:\oradata\CSZLS\control01.ctl", "e:\oradata\CSZLS\control02.ctl", "e:\oradata\CSZLS\control03.ctl")
open_cursors = 300
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 43818
shared_pool_size = 119653478
large_pool_size = 614400
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 150
parallel_max_servers = 5
log_buffer = 32768
#audit_trail = true # if you want auditing
#timed_statistics = true # if you want timed statistics
max_dump_file_size = 10240 # limit trace file size to 5M each
# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
log_archive_start = true
# log_archive_dest_1 = "location=d:\oracle\oradata\CSZLS\archive"
log_archive_dest = E:\oradata\CSZLS\arch
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6 )
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true
# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true
oracle_trace_collection_name = ""
# define directories to store trace and alert files
background_dump_dest = d:\oracle\admin\CSZLS\bdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = d:\oracle\admin\CSZLS\udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
# The following parameters are needed for the Advanced Replication Option
job_queue_processes = 4
job_queue_interval = 60
open_links = 4
distributed_transactions = 10
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536
第五章 数据库控制文件
数据库控制文件参数如下，并可以用以下脚本重建：
*** SESSION ID:(13.195) 2002-12-25 12:59:41.210
*** 2002-12-25 12:59:41.210
# The following commands will create a new control file and use it
# to open the database.
# Data used by the recovery manager will be lost. Additional logs may
# be required for media recovery of offline data files. Use this
# only if the current version of all online logs are available.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "CSZLS" NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 1815
LOGFILE
GROUP 1 'E:\ORADATA\CSZLS\REDO01.LOG' SIZE 1M,
GROUP 2 'E:\ORADATA\CSZLS\REDO02.LOG' SIZE 1M,
GROUP 3 'E:\ORADATA\CSZLS\REDO03.LOG' SIZE 1M
DATAFILE
'E:\ORADATA\CSZLS\SYSTEM01.DBF',
'E:\ORADATA\CSZLS\RBS01.DBF',
'E:\ORADATA\CSZLS\USERS01.DBF',
'E:\ORADATA\CSZLS\TEMP01.DBF',
'E:\ORADATA\CSZLS\TOOLS01.DBF',
'E:\ORADATA\CSZLS\INDX01.DBF',
'E:\ORADATA\CSZLS\DR01.DBF',
'E:\ORADATA\CSZLS\WATER.ORA'
CHARACTER SET WE8ISO8859P1
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
#