iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

November 18, 2017, 12:23:50 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Search Login Register  
Pages: [1] |   Go Down
  Send this topic  |  Print  
Author Topic: ASM Solaris add DISK&Migration  (Read 61 times)
Johni
Administrator
Newbie
*****
Posts: 1


« on: September 12, 2017, 03:28:19 PM »

Solaris
-----------
------ On domain
------ Chech for disks emcpower
ldm list-domains

# echo | format  | grep emcpower
for i in ` echo | format  | grep emcpower | awk '{print $2}'`;
do echo $i;
ldm list-services | grep $i;    bindings, constraints ...
done

Adding devices to ldm
# ldm add-vdsdev /dev/dsk/emcpower123c emcpower123c@primary-vds0    --check this
# ldm add-disk emcpower123c emcpower123c@primary-vds0    p-eds-oracle1t
-----------

On ldom
# su - or sudo
# sudo format

ASM Support large file  upto 2TB
Donot use slice start with cylinder 0
-----------------------------------------------------------
Part      Tag    Flag     First Sector        Size        Last Sector
  0        usr    wm               256      33.99GB         71288542   
  1 unassigned    wm                 0          0              0   
  2 unassigned    wm                 0          0              0   
  3 unassigned    wm                 0          0              0   
  4 unassigned    wm                 0          0              0   
  5 unassigned    wm                 0          0              0   
  6 unassigned    wm                 0          0              0   
  8   reserved    wm          71288543       8.00MB         71304926

ACF
crw-------   1 root     sys      272, 104 Aug 25 13:01 /dev/rdsk/c1d13s0
crw-------   1 root     sys      272, 112 Aug 25 13:03 /dev/rdsk/c1d14s0
crw-------   1 root     sys      272, 120 Aug 25 13:03 /dev/rdsk/c1d15s0

ls -alL c1d*s0

for i in 104 112 120;
do echo $i;
ls -alL /dev/rdsk/c1d*s0 |grep $i;
done

--- cd /dev
mkdir /dev/asmdisks
cd /dev/asmdisk
sudo mknod asmdata001 c 272 104
sudo mknod asmdata002 c 272 112
sudo mknod asmfra001 c 272 120
sudo chown grid:oinstall asmdata001
sudo chmod 660 asmdata001

---grid...
SQL> show parameter disk
SQL> alter system set asm_diskstring='AFD:*','/dev/asmdisk/*';
SQL> select name, path from v$asm_disk;
SQL> select * from v$asm_diskgroup;

SQL> create diskgroup DATA2 external redundancy DISK '/dev/asmdisk/asmdata001' name asmdata001;
SQL> alter diskgroup DATA2 ADD DISK '/dev/asmdisk/asmdata002' name asmdata002;
SQL> create diskgroup FRA2 external redundancy DISK '/dev/asmdisk/asmfra001' name asmfra001;

---db1
SQL> create tablespace test datafile '+DATA2/db2/datafile/test_01.df' size 50m; 

---db2
SQL> create tablespace test datafile '+DATA2/db1/datafile/test_01.df' size 50m;
SQL> alter diskgroup DATA2 add directory '+DATA2/sndbox';
SQL> create tablespace test11 datafile '+DATA2/db2/oradata/test11_01.df' size 50m;

SQL> drop diskgroup DATA2;
SQL> drop diskgroup DATA2 force including contents;
SQL> select * from v$asm_diskgroup;
//////////////////////////////////////////////////////////

# ls - lhL /dev/rdsk/c1d13    c1d14   c1d15

# ls -alL /dev/rdsk/c1d*s0
Create oracle naming convention

# mkdir /dev/asmdisk
# cd /dev/asmdisk
# mknod [name]  c  [major]  [minor] 

asmdata001...      asmfra001...
# chown oracle:dba asm*
# chmod 660 asm*

If error, Clean the header
# dd if=/dev/zero of=/dev/rdsk/asmdata005 bs=1024 count=100



# chown oracle:dba /dev/rdsk/c1d13s0
# cdmod 660 /dev/rdsk/c1d13s0


------ Migration
select name from v$datafile  and  controlfile;
select member from v$logfile;
select name, path, group_number from v$asm_disk;

Set db_create_file_dest    and  db_recovery_file_dest
-----------------
alter system set  db_create_file_dest = '+data' scope=spfile;
alter system set  db_recovery_file_dest = '+fra  scope=spfile;
alter system set  control_files = '+data', '+fra' scope=spfile;

create pfile from spfile;
shutdown immediate;
vi init

startup nomount;
rman ....

dgmgrl
disable configuration;
enable configuration;

Make sure
In grid add LDAP to sqlnet.ora
Copy ldap.ora to grid network/admin
Init file change the controlfile distination ....

Files
  controlfile, logfile, datafile
Logged
Pages: [1] |   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!