rhel5.4+oracle_10g+asm 手工配置

lvcreate -L 8G -nLogVol06 VolGroup00
lvcreate -L 8G -nLogVol07 VolGroup00
lvcreate -L 8G -nLogVol08 VolGroup00
lvcreate -L 8G -nLogVol09 VolGroup00
lvcreate -L 8G -nLogVol10 VolGroup00
lvcreate -L 8G -nLogVol11 VolGroup00
lvcreate -L 8G -nLogVol12 VolGroup00
lvcreate -L 8G -nLogVol13 VolGroup00

/etc/init.d/oracleasm createdisk VOL1 /dev/mapper/VolGroup00-LogVol06
/etc/init.d/oracleasm createdisk VOL2 /dev/mapper/VolGroup00-LogVol07
/etc/init.d/oracleasm createdisk VOL3 /dev/mapper/VolGroup00-LogVol08
/etc/init.d/oracleasm createdisk VOL4 /dev/mapper/VolGroup00-LogVol09
/etc/init.d/oracleasm createdisk VOL5 /dev/mapper/VolGroup00-LogVol10
/etc/init.d/oracleasm createdisk VOL6 /dev/mapper/VolGroup00-LogVol11
/etc/init.d/oracleasm createdisk VOL7 /dev/mapper/VolGroup00-LogVol12
/etc/init.d/oracleasm createdisk VOL8 /dev/mapper/VolGroup00-LogVol13

alter system set asm_diskstring='/dev/oracleasm/disks/VOL*';
create diskgroup efbbak external redundancy disk '/dev/oracleasm/disks/VOL*';

alter system set asm_diskstring='ORCL:*';
create diskgroup defbbak1 normal redundancy failgroup fefbbak1 disk 'ORCL:VOL1','ORCL:VOL3','ORCL:VOL5','ORCL:VOL7' failgroup fefbbak2 disk 'ORCL:VOL2','ORCL:VOL4','ORCL:VOL6','ORCL:VOL8';

col name for a15
select disk_number,name,mount_status,total_mb from v$asm_disk;

=========================init+ASM.ora
+ASM.asm_diskgroups=''#Manual Dismount
*.asm_diskstring='ORCL:*'
*.background_dump_dest='/app/oracle/products/admin/+ASM/bdump'
*.core_dump_dest='/app/oracle/products/admin/+ASM/cdump'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='SHARED'
*.user_dump_dest='/app/oracle/products/admin/+ASM/udump'

initefbbak.ora
================
*.compatible='10.2.0.1.0'
*.db_domain=''
*.db_name='efbbak'
*.db_block_size=8192
*.db_file_multiblock_read_count=32
*.dispatchers='(PROTOCOL=TCP) (SERVICE=efbbak)'
*.job_queue_processes=10
*.open_cursors=1240
*.processes=600
*.sessions=750
*.remote_login_passwordfile='EXCLUSIVE'
*.star_transformation_enabled='TRUE'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.sga_target=4294967296
*.pga_aggregate_target=100485760
*.db_cache_size=10485760
*.java_pool_size=1048576
*.large_pool_size=1048576
*.shared_pool_size=67108864
*.streams_pool_size=0
#*.audit_file_dest='/oracle/data/liwei/audit_file_dest'
*.background_dump_dest='/app/oracle/products/admin/efbbak/bdump'
*.core_dump_dest='/app/oracle/products/admin/efbbak/cdump'
*.user_dump_dest='/app/oracle/products/admin/efbbak/udump'
*.control_files='+DEFBBAK1/efbback/control/CONTROL01.CTL','+DEFBBAK1/efbback/control/CONTROL02.CTL','+DEFBBAK1/efbback/control/CONTROL03.CTL'
#*.db_recovery_file_dest='/oracle/data/liwei/db_recovery_file_dest'
#*.db_recovery_file_dest_size=104857600
==================

startup pfile='/app/oracle/products/10.2/db_1/dbs/initefbbak.ora' nomount;

=====create database
create database efbbak
CONTROLFILE REUSE
maxinstances 4
maxloghistory 2
maxlogfiles 16
maxlogmembers 2
maxdatafiles 8
character set zhs16gbk
national character set al16utf16
datafile '+DEFBBAK1/system.dbf' size 500m REUSE EXTENT MANAGEMENT LOCAL
sysaux datafile '+DEFBBAK1/sysaux.dbf' size 300m REUSE default temporary tablespace temp tempfile '+DEFBBAK1/temp.dbf' size 2000m REUSE extent management local uniform size 32k
undo tablespace undotbs1 datafile '+DEFBBAK1/undotbs1.dbf' size 2000m REUSE

logfile
group 1 ('+DEFBBAK1/redo0101.dbf') size 50m reuse,
group 2 ('+DEFBBAK1/redo0201.dbf') size 50m reuse,
group 3 ('+DEFBBAK1/redo0301.dbf') size 50m reuse;

shutdown immediate;

@?/rdbms/admin/catalog.sql;
@?/rdbms/admin/catproc.sql;
@?/rdbms/admin/catexp7.sql
@?/sqlplus/admin/caths.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql
@?/rdbms/admin/catexp.sql;
@?/rdbms/admin/catpart.sql;
@?/rdbms/admin/catadt.sql;
@?/rdbms/admin/catblock.sql;

[@more@]