What do you get when you try
ARCHIVE LOG LIST ?
Connect to svrmgrl as internal
and issue the command
ARCHIVE LOG LIST.
This should show whether the database
is in archivelog mode and whether automatic
archive is enabled.
Then issue the command
ALTER SYSTEM SWITCH LOGFILE
or
ALTER SYSTEM ARCHIVE LOG NEXT
this should generate a new log file in the
archive destination.
Hemant K Chitale
"vze24462" <vze24462_at_verizon.net> wrote in message
news:3C6EE291.1000501_at_verizon.net...
> Below is my initpord.ora and it has never been modified ever since.#
> # $Header: init.ora 1.2 94/10/18 16:12:36 gdudey Osd<desktop/netware> $
> init.ora Copyr (c) 1991 Oracle
> #
>
############################################################################
##
> # Example INIT.ORA file
> #
> # This file is provided by Oracle Corporation to help you customize
> # your RDBMS installation for your site. Important system parameters
> # are discussed, and example settings given.
> #
> # Some parameter settings are generic to any size installation.
> # For parameters that require different values in different size
> # installations, three scenarios have been provided: SMALL, MEDIUM
> # and LARGE. Any parameter that needs to be tuned according to
> # installation size will have three settings, each one commented
> # according to installation size.
> #
> # Use the following table to approximate the SGA size needed for the
> # three scenarious provided in this file:
> #
> # -------Installation/Database Size------
> # SMALL MEDIUM LARGE
> # Block 2K 4500K 6800K 17000K
> # Size 4K 5500K 8800K 21000K
> #
> # To set up a database that multiple instances will be using, place
> # all instance-specific parameters in one file, and then have all
> # of these files point to a master file using the IFILE command.
> # This way, when you change a public
> # parameter, it will automatically change on all instances. This is
> # necessary, since all instances must run with the same value for many
> # parameters. For example, if you choose to use private rollback segments,
> # these must be specified in different files, but since all gc_*
> # parameters must be the same on all instances, they should be in one
file.
> #
> # INSTRUCTIONS: Edit this file and the other INIT files it calls for
> # your site, either by using the values provided here or by providing
> # your own. Then place an IFILE= line into each instance-specific
> # INIT file that points at this file.
>
############################################################################
###
>
> db_name = PROD
> db_files = 20
>
> # optimizer_mode=rule
>
> control_files = (
> D:\ORADATA\PROD\ctl2PROD.dbf,
> e:\oradata\PROD\ctl3PROD.dbf)
>
> rollback_segments = (rbseg01, rbseg02, rbseg03, rbseg04, rbseg05,
rbs_batch)
>
> compatible = 7.3.3.0.0
>
> sort_area_size = 262144
> sort_area_retained_size = 262144
>
> db_file_multiblock_read_count = 8 # SMALL
> # db_file_multiblock_read_count = 16 # MEDIUM
> # db_file_multiblock_read_count = 32 # LARGE
>
> # db_block_buffers = 200 # SMALL
> # db_block_buffers = 550 # MEDIUM
> # db_block_buffers = 3200 # LARGE
> db_block_buffers = 9600 # LARGE
>
> # shared_pool_size = 3500000 # SMALL
> # shared_pool_size = 6000000 # MEDIUM
> # shared_pool_size = 9000000 # LARGE
> shared_pool_size = 30000000 # LARGE
>
> log_checkpoint_interval = 10000
>
> # processes = 50 # SMALL
> processes = 100 # MEDIUM
> # processes = 200 # LARGE
>
> # dml_locks = 100 # SMALL
> # dml_locks = 200 # MEDIUM
> dml_locks = 500 # LARGE
>
> # log_buffer = 8192 # SMALL
> # log_buffer = 32768 # MEDIUM
> log_buffer = 163840 # LARGE
>
> sequence_cache_entries = 10 # SMALL
> # sequence_cache_entries = 30 # MEDIUM
> # sequence_cache_entries = 100 # LARGE
>
> sequence_cache_hash_buckets = 10 # SMALL
> # sequence_cache_hash_buckets = 23 # MEDIUM
> # sequence_cache_hash_buckets = 89 # LARGE
>
> # audit_trail = true # if you want auditing
> # timed_statistics = true # if you want timed statistics
> # max_dump_file_size = 20480 # limit trace file size
>
> # sql_trace = true # if you want to start tracing
>
> # user_dump_dest = %ORACLE_HOME%\admin\PROD\udump
> # background_dump_dest = %ORACLE_HOME%\admin\PROD\bdump
> # log_archive_start = true # if you want automatic archiving
>
> log_archive_start=true
> log_archive_dest=D:\DBarchive\PROD
> log_archive_format="prod_%t_%s.arc"
>
>
> db_block_size = 8192
> snapshot_refresh_processes = 1
> remote_login_passwordfile = shared
> text_enable = true
>
Received on Sun Feb 17 2002 - 01:40:27 CST
