Datasheet

Using ASM Storage 41
Creating Spfiles or Parameter Files on an ASM Disk Group
You can create pfiles or spfiles on an ASM disk group using the create pfile or create
spfile
command with the ASM disk group as the location for the parameter file. For example,
you could issue this command:
create spfile ‘+COOKED_DGROUP1’ from pfile;
Creating Online Redo Logs in an ASM Disk Group Location
Creation of redo logs on ASM disks is straightforward. If the database was configured to
use ASM from the beginning, then the existing online redo logs will already be on ASM
disk groups. Assuming that the parameter
DB_ONLINE_CREATE_LOG_DEST_n or DB_CREATE_
FILE_DEST
is set, you can simply issue the alter database add logfile command and
Oracle will add a new redo log group to your database for you, as shown in this example:
alter database add logfile size 100m;
You can also manually add a redo log file group to a disk group if you prefer using SQL,
such as in the following, which will create a new log file group, and multiplex it, between
two ASM disk groups:
alter database add logfile (’+COOKED_DGROUP1’,’+COOKED_DGROUP2’) size 100m;
Defining an ASM Disk Group Location as an Archived
Redo Log Storage Area
Once you have created an ASM disk, it’s easy to use it as the storage for archived redo logs.
Simply set one of the
LOG_ARCHIVE_DEST_n parameters to point to that ASM disk group, as
shown in this example:
alter system
set log_archive_dest_1=’location=+COOKED_DGROUP2’;
You can check the ASM instance and see the new archived logs being created, as shown
in this example code:
SQL> select a.group_number, b.name, a.incarnation, a.file_number, a.type
2 from v$ASM_DISKGROUPS b, v$asm_file a
3 where a.group_number=b.group_number
4 and a.type=’ARCHIVELOG’;
95134c01.indd 41 1/28/09 9:43:46 AM