At my wits end with ASM file names...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Sat, 08 Apr 2006 18:28:21 +0200
Message-ID: <e18ob7$nuq$1@nntp.fujitsu-siemens.com>

Hi!
I'm trying to create a database (10gR2, Linux) which uses asm. Asm runs and I can query the views and everything.

Now, on a different account I try to create the database. I've used dbca for creating the scripts and then tried to set it up in such a way as to use ASM and OMF and automatical stuff for everything.
Here's my init.ora:

log_archive_dest_1='LOCATION=+RECOVERY'
log_archive_format=%t_%s_%r.dbf
db_block_size=8192
db_file_multiblock_read_count=16
open_cursors=300
db_domain=ecad.abg.fsc.net
db_name=colon
background_dump_dest=/vol1/oracle/admin/colon/bdump core_dump_dest=/vol1/oracle/admin/colon/cdump user_dump_dest=/vol1/oracle/oracle/product/10.2.0/db/admin/colon/udump
#############################################################################
control_files=+CONTROL(fine)

db_create_file_dest=+DATA_STRUCTURED(coarse)
db_create_online_log_dest_1=+REDO(fine)
db_recovery_file_dest=+RECOVERY(coarse)


#############################################################################

db_recovery_file_dest_size=10737418240
job_queue_processes=10
compatible=10.2.0.1.0
processes=150
control_file_record_keep_time=70
sga_target=444596224
audit_file_dest=/vol1/oracle/admin/colon/adump remote_login_passwordfile=EXCLUSIVE
dispatchers="(PROTOCOL=TCP) (SERVICE=colonXDB)" pga_aggregate_target=147849216
undo_management=AUTO
undo_tablespace=UNDOTBS1

Is anybody able to help me set it up so that all control files end up in the control disk group, the redos in the redo disk group and the data in the DATA_STRUCTURED disk group?

As for the recovery_dest size, actually I am happy enough if it uses the whole disk group. Can I leave out that parameter?

Lots of Greetings!
Volker Received on Sat Apr 08 2006 - 11:28:21 CDT