ASM Migration

1.step
C:\Documents and Settings\Navaneeth.v>e:\oracle\product\10.2.0\db_1\bin\localconfig.bat add
Step 1: creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'kgisl\Navaneeth.v', privgrp ''..
Operation successful.
Step 2: creating new CSS service
successfully created local CSS service
successfully added CSS to home
2 .step
C:\>asmtool -create E:\ASM_Disk\asm_disk1 1000
C:\>set oracle_sid=+asm
C:\>sqlplus
selectDiskUIDataSource - You need at least one disk to create a Disk Group with external redundancy
Reference Document :
http://www.oracle.com/technology/obe/obe10gdb/storage/asm/asm.htm
http://www.oracle.com/technology/products/database/asm/pdf/asm_10gr2_bptwp_sept05.pdf
For ASM Configuration :
step1 : Creating Partition
For Creatign RAW partations Step by step :
http://download.oracle.com/docs/cd/B19306_01/install.102/b15660/pre_install.htm#sthref591 **
Microsoft DiskPart version 5.1.3553
Copyright (C) 1999-2001 Microsoft Corporation.
On computer: KGSOFT148
DISKPART> select disk 0
Disk 0 is now the selected disk.
DISKPART> list partition
Partition ### Type Size Offset
------------- ---------------- ------- -------
Partition 1 Primary 15 GB 32 KB
Partition 2 Primary 20 GB 15 GB
Partition 3 Primary 29 GB 34 GB
DISKPART> create partition primary size=11000
DiskPart succeeded in creating the specified partition.
DISKPART> list partition
Partition ### Type Size Offset
------------- ---------------- ------- -------
Partition 1 Primary 15 GB 32 KB
Partition 2 Primary 20 GB 15 GB
Partition 3 Primary 29 GB 34 GB
* Partition 4 Primary 11 GB 63 GB
DISKPART>
Step 2:
Run "asmtoolg" tool For Creating disks.
+
Do needed For creating the disks.
Step 3: Creating Disk group
SQL> create diskgroup 'DBFILES' external redundancy disk '\\.\ORCLDISKDATA0' SIZE 10997 M ;
Diskgroup created.
C:\Documents and Settings\Navaneeth.v>asmcmd -p
ASMCMD [+] > ls
DBFILES/
ASMCMD [+] > cd DBFILES
ASMCMD [+DBFILES] > ls


Migrate Existing Database to ASM using Database Control.
Migrating to Oracle ASM using Oracle Enterprise Manager 10g Database Control
http://www.oracle.com/technology/pub/notes/technote_rego.html
http://www.oracle-base.com/articles/10g/ASMUsingASMLibAndRawDevices.php
For Configuring ASM
http://www.oracledba.org/10g/asm/dbca_asm_crte.html
http://www.oracle.com/technology/obe/obe10gdb/manage/asm/10g_asmlab3/viewlet/asmlab3_viewlet_swf.html

***ASM conversion using RMAN***
1.
run
{
allocate channel c1 device type disk format='+dbfiles';
backup as copy database;
}
2.
SQL> alter system set db_create_file_dest='+DBFILES';
System altered.
3.
SQL> alter system set db_create_online_log_dest_1='+DBFILES';
System altered.
3a. Alter system set control_files='+DBFILES'
4. Including all datafiles and tempfiles.
run
{
shutdown immediate;
startup mount;
set newname for datafile 1 to '+dbfiles';
set newname for datafile 2 to '+dbfiles';
set newname for datafile 3 to '+dbfiles';
set newname for datafile 4 to '+dbfiles';
set newname for datafile 5 to '+dbfiles';
restore controlfile from copy '+DBFILES' ---- > check not confirmed yet
restore database;
switch datafile 1;
switch datafile 2;
switch datafile 3;
switch datafile 4;
switch datafile 5;
recover database;
sql" alter database open resetlogs;
}
Transfer logfiles to ASM by creating new files and drop existing ones.

5. Alter database add logfile group 3 '+DBFILES' size 10m;
6. Alter database add logifle group 4 '+DBFILES' size 10m;
7. alter system switch logfile;
8. Alter system switch logfile;
9. Alter system checkpoint;
10.Alter database drop logfile group 1;
11. Alter database drop logfile group 2;
Check the logfiles for ASM location
12.select * from v$logfile;

Completed sucessfully.