Contents

    1. System config
    2. MCPOS environment
    3. multipath
      1. parted
      2. UDEV
  2. SAN Switch
    1. MINISO-BR6505-01
      1. alias create
      2. zonecreate
      3. cfg
    2. MINISO_BR6505_02
      1. alicreate
      2. zonecreate
      3. cfg
    3. Redo
  3. RMAN
    1. lunch_rman leve0
    2. lunch_rman leve0
    3. level0
    4. level1
    5. calc shm
  4. change modify crs resource

System config

mkdir /mnt/iso
mount -o loop /media/orasoft/OracleLinux-R6-U9-Server-x86_64-dvd.iso /mnt/iso
cd /mnt/iso/Packages/; rpm -ivh createrepo-* python-deltarpm* deltarpm-*

cat >> /etc/yum.repos.d/iso.repo <<EOF
[IS0]
name=ISO
baseurl=file:///mnt
gpgcheck=0
enabled=1
EOF

yum upgrade
yum install tigervnc-server.x86_64 xorg-x11-server-Xorg.x86_64 twm xterm vim

MCPOS environment

[root@MCPOS-HOST-01 orasoft]# for DISK in `find /dev/ -name "sd*" | sort`;   do     WWID=`/sbin/scsi_id --whitelisted --replace-whitespace --device=$DISK`;     echo $DISK " WWID is " $WWID;     done | sort -k 4 -n
/dev/sdh  WWID is  3600a098000d982670000007d5b18aa44
/dev/sdi  WWID is  3600a098000d982670000007d5b18aa44
/dev/sdp  WWID is  3600a098000d982670000007d5b18aa44
/dev/sdq  WWID is  3600a098000d982670000007d5b18aa44
/dev/sdaa  WWID is  360080e50004797680000022f5b19ee62
/dev/sdab  WWID is  360080e50004797680000022f5b19ee62
/dev/sdac  WWID is  360080e50004797680000022f5b19ee62
/dev/sdb  WWID is  360080e50004797680000022c5b19ee46
/dev/sdc  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdd  WWID is  360080e50004797680000022c5b19ee46
/dev/sde  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdf  WWID is  360080e50004797680000022c5b19ee46
/dev/sdg  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdj  WWID is  360080e50004797680000022c5b19ee46
/dev/sdk  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdl  WWID is  360080e50004797680000022c5b19ee46
/dev/sdm  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdn  WWID is  360080e50004797680000022c5b19ee46
/dev/sdo  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdr  WWID is  360080e50004797680000022c5b19ee46
/dev/sds  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdt  WWID is  360080e50004797680000022c5b19ee46
/dev/sdu  WWID is  360080e50004797680000016b5b18a9cd
/dev/sdv  WWID is  360080e50004797680000022f5b19ee62
/dev/sdw  WWID is  360080e50004797680000022f5b19ee62
/dev/sdx  WWID is  360080e50004797680000022f5b19ee62
/dev/sdy  WWID is  360080e50004797680000022f5b19ee62
/dev/sdz  WWID is  360080e50004797680000022f5b19ee62
/dev/sda1  WWID is  3650002075b11a42022ad3f9f1e7a9b03
/dev/sda2  WWID is  3650002075b11a42022ad3f9f1e7a9b03
/dev/sda  WWID is  3650002075b11a42022ad3f9f1e7a9b03

multipath

https://library.netapp.com/ecmdocs/ECMP12404601/html/GUID-49E94674-947F-4921-A1D1-CE9B42DCBA39.html

https://library.netapp.com/ecmdocs/ECMP1217221/html/GUID-6B39FC09-C391-4916-B1D5-DAD56470BB3C.html

https://library.netapp.com/ecmdocs/ECMP1654939/html/GUID-ADD56A15-EE4A-451A-8B46-914B01F8694E.html

dracut --force --add multipath
chkconfig multipathd on

[root@MCPOS-HOST-01 ~]# multipath -ll
mpathg (360080e5000479768000002515b1a0424) dm-9 NETAPP,INF-01-00
size=2.0T features='4 queue_if_no_path pg_init_retries 50 retain_attached_hw_handle' hwhandler='1 rdac' wp=rw
|-+- policy='round-robin 0' prio=0 status=active
| |- 7:0:2:5  sdak 66:64  active undef unknown
| |- 8:0:1:5  sdcf 69:48  active undef unknown
| |- 7:0:3:5  sdaz 67:48  active undef unknown
| `- 8:0:5:5  sddk 71:32  active undef unknown
`-+- policy='round-robin 0' prio=0 status=enabled
  |- 7:0:0:5  sdg  8:96   active undef unknown
  |- 8:0:0:5  sdbq 68:64  active undef unknown
  |- 7:0:1:5  sdv  65:80  active undef unknown
  `- 8:0:2:5  sdcu 70:32  active undef unknown

[root@MCPOS-HOST-01 ~]# sed '/^$/d;/^#/d' /etc/multipath.conf 
defaults {
        user_friendly_names   yes
        max_fds               max       
        flush_on_last_del     yes
        queue_without_daemon  no
        dev_loss_tmo          infinity
        fast_io_fail_tmo      5
}
blacklist {
       wwid "3650002075b11a42022ad3f9f1e7a9b03"
        devnode "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
        devnode "^hd[a-z]"
}
devices {
    device {
       vendor                  "NETAPP"
       product                 "LUN"
       path_grouping_policy    group_by_prio
       features                "3 queue_if_no_path pg_init_retries 50"
       prio                    "alua"
       path_checker            tur
       failback                immediate
       path_selector           "round-robin 0"
       hardware_handler        "1 alua"
       rr_weight               uniform
       rr_min_io               128
       getuid_callout          "/lib/udev/scsi_id -g -u -d /dev/%n"
}
}
multipaths {
multipath {
        alias DATA01
        wwid 360080e50004797680000022c5b19ee46
}
multipath {
        alias DATA02
        wwid 360080e50004797680000022f5b19ee62
}
multipath {
        alias DATA03
        wwid 360080e5000479768000002495b1a034c
}
multipath {
        alias DATA04
        wwid 360080e50004797680000024b5b1a0381
}
multipath {
        alias DATA05
        wwid 360080e50004797680000024d5b1a03a3
}
multipath {
        alias DATA06
        wwid 360080e50004797680000024f5b1a03bf
}
multipath {
        alias DATA07
        wwid 360080e5000479768000002515b1a0424
}
multipath {
        alias ARCH01
        wwid 360080e5000479768000002555b1a0493
}
multipath {
        alias ARCH02
        wwid 360080e5000479768000002585b1a04aa
}
multipath {
        alias ARCH03
        wwid 360080e50004797680000025a5b1a04c4
}
multipath {
        alias ARCH04
        wwid 360080e50004797680000025c5b1a04df
}
multipath {
        alias ARCH05
        wwid 360080e50004797680000025e5b1a0501
}
multipath {
        alias REDO01
        wwid 360080e5000479750000002765b1dd87b
}
multipath {
        alias REDO02
        wwid 360080e5000479750000002905b1dea28
}

# 2018-06-22 added
multipath {
        alias FAS-LUN03
        wwid 38304648752b4c73574f7a39
}
multipath {
        alias FAS-LUN04
        wwid 38304648752b4c73574f7a38
}
multipath {
        alias FAS-LUN05
        wwid 38304648752b4c73574f7a2d
}
multipath {
        alias FAS-LUN06
        wwid 38304648752b4c73574f7a41
}
}

service multipathd reload

parted

[root@MCPOS-HOST-01 ~]# for DISK in `find /dev/mapper/ -name "*0?"`; do echo "parted $DISK mklabel gpt mkpart primary 0% 100%"; done
parted /dev/mapper/REDO02 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/ARCH04 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/ARCH03 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/ARCH05 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/ARCH02 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/REDO01 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/ARCH01 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA07 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA06 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA05 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA04 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA02 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA03 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/DATA01 mklabel gpt mkpart primary 0% 100%

parted /dev/mapper/FAS-LUN03 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/FAS-LUN04 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/FAS-LUN05 mklabel gpt mkpart primary 0% 100%
parted /dev/mapper/FAS-LUN06 mklabel gpt mkpart primary 0% 100%


parted /dev/mapper/FAS-LUN03 set 1 lvm on
parted /dev/mapper/FAS-LUN04 set 1 lvm on
parted /dev/mapper/FAS-LUN05 set 1 lvm on
parted /dev/mapper/FAS-LUN06 set 1 lvm on


pvcreate /dev/mapper/FAS-LUN03p1
Found duplicate PV 4Xfxra0j1k4pQYdPMbIGH4AGrFZyVqu4: using /dev/mapper/mpathap2 not /dev/sda2
  Using duplicate PV /dev/mapper/mpathap2 from subsystem DM, replacing /dev/sda2
  Physical volume "/dev/mapper/FAS-LUN03p1" successfully created

pvcreate /dev/mapper/FAS-LUN04p1
  Physical volume "/dev/mapper/FAS-LUN04p1" successfully created

pvcreate /dev/mapper/FAS-LUN05p1
pvcreate /dev/mapper/FAS-LUN06p1

vgcreate OracleBK /dev/mapper/FAS-LUN03p1 /dev/mapper/FAS-LUN04p1 /dev/mapper/FAS-LUN05p1 /dev/mapper/FAS-LUN06p1
  Volume group "OracleBK" successfully created


lvcreate -l 100%FREE -n OracleBK_LV01 OracleBK
  Logical volume "OracleBK_LV01" created.

[root@MCPOS-HOST-01 ~]# mkfs.ext4 -L OracleBK_LV01 /dev/mapper/OracleBK-OracleBK_LV01 
mke2fs 1.43-WIP (20-Jun-2013)
Filesystem label=OracleBK_LV01
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
Stride=0 blocks, Stripe width=16 blocks
335544320 inodes, 5368705024 blocks
268435251 blocks (5.00%) reserved for the super user
First data block=0
163840 block groups
32768 blocks per group, 32768 fragments per group
2048 inodes per group
Superblock backups stored on blocks: 
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208, 
        4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968, 
        102400000, 214990848, 512000000, 550731776, 644972544, 1934917632, 
        2560000000, 3855122432

Allocating group tables: done                            
Writing inode tables: done                            
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

UDEV

[root@MCPOS-HOST-01 ~]# for DISK in `find /dev/mapper/ -name "*0?p1"`; do echo "$DISK" `udevadm info --query=all --name=$DISK | grep -i dm_uuid`; done
/dev/mapper/REDO02p1 E: DM_UUID=part1-mpath-360080e5000479750000002905b1dea28
/dev/mapper/ARCH05p1 E: DM_UUID=part1-mpath-360080e50004797680000025e5b1a0501
/dev/mapper/ARCH03p1 E: DM_UUID=part1-mpath-360080e50004797680000025a5b1a04c4
/dev/mapper/ARCH04p1 E: DM_UUID=part1-mpath-360080e50004797680000025c5b1a04df
/dev/mapper/ARCH02p1 E: DM_UUID=part1-mpath-360080e5000479768000002585b1a04aa
/dev/mapper/ARCH01p1 E: DM_UUID=part1-mpath-360080e5000479768000002555b1a0493
/dev/mapper/REDO01p1 E: DM_UUID=part1-mpath-360080e5000479750000002765b1dd87b
/dev/mapper/DATA05p1 E: DM_UUID=part1-mpath-360080e50004797680000024d5b1a03a3
/dev/mapper/DATA07p1 E: DM_UUID=part1-mpath-360080e5000479768000002515b1a0424
/dev/mapper/DATA06p1 E: DM_UUID=part1-mpath-360080e50004797680000024f5b1a03bf
/dev/mapper/DATA04p1 E: DM_UUID=part1-mpath-360080e50004797680000024b5b1a0381
/dev/mapper/DATA03p1 E: DM_UUID=part1-mpath-360080e5000479768000002495b1a034c
/dev/mapper/DATA02p1 E: DM_UUID=part1-mpath-360080e50004797680000022f5b19ee62
/dev/mapper/DATA01p1 E: DM_UUID=part1-mpath-360080e50004797680000022c5b19ee46


[root@MCPOS-HOST-01 ~]# for i in `cat dm-id`; do echo 'KERNEL=="dm-*",ENV{DM_UUID}=="'$i'",OWNER="grid",GROUP="asmadmin",MODE="0660"'; done
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479750000002905b1dea28",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000025e5b1a0501",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000025a5b1a04c4",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000025c5b1a04df",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002585b1a04aa",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002555b1a0493",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479750000002765b1dd87b",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000024d5b1a03a3",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002515b1a0424",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000024f5b1a03bf",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000024b5b1a0381",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002495b1a034c",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000022f5b19ee62",OWNER="grid",GROUP="asmadmin",MODE="0660"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000022c5b19ee46",OWNER="grid",GROUP="asmadmin",MODE="0660"

[root@MCPOS-HOST-01 ~]# for DISK in `find /dev/mapper/ -name "*0?p1" | sed 's#/dev/mapper/##g'` ; do echo `udevadm info --query=all --name=/dev/mapper/$DISK | grep -i dm_uuid | awk -F"=" '{ print "KERNEL==\"dm-*\",ENV{DM_UUID}==\""$2"\",OWNER=\"grid\",GROUP=\"asmadmin\",MODE=\"0660\"" }'`,\"NAME+=/dev/oracleasm/disks/$DISK\"; done
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479750000002905b1dea28",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/REDO02p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479750000002765b1dd87b",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/REDO01p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000025e5b1a0501",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/ARCH05p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000025c5b1a04df",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/ARCH04p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000025a5b1a04c4",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/ARCH03p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002585b1a04aa",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/ARCH02p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002555b1a0493",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/ARCH01p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000024d5b1a03a3",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA05p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002515b1a0424",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA07p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000024f5b1a03bf",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA06p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000024b5b1a0381",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA04p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e5000479768000002495b1a034c",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA03p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000022f5b19ee62",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA02p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-360080e50004797680000022c5b19ee46",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=/dev/oracleasm/disks/DATA01p1"

[root@MINISO-HDNETDB ~]# for DISK in `find /dev/ -name "sd?1"`  ; do echo `udevadm info --query=all --name=$DISK | grep -i ID_PATH | awk -F"=" '{ print "KERNEL==\"sd?1\",ENV{ID_PATH}==\""$2"\",OWNER=\"grid\",GROUP=\"asmadmin\",MODE=\"0660\"" }'`,NAME=\"\"; done
KERNEL=="sd?1",ENV{ID_PATH}=="pci-0000:03:00.0-scsi-0:0:3:0",OWNER="grid",GROUP="asmadmin",MODE="0660",NAME=""
KERNEL=="sd?1",ENV{ID_PATH}=="pci-0000:03:00.0-scsi-0:0:1:0",OWNER="grid",GROUP="asmadmin",MODE="0660",NAME=""
KERNEL=="sd?1",ENV{ID_PATH}=="pci-0000:03:00.0-scsi-0:0:2:0",OWNER="grid",GROUP="asmadmin",MODE="0660",NAME=""
KERNEL=="sd?1",ENV{ID_PATH}=="pci-0000:03:00.0-scsi-0:0:0:0",OWNER="grid",GROUP="asmadmin",MODE="0660",NAME=""

KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000f63f48000001cb5c7db88e",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-DATA06p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000e3c7e6000002685c7db865",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-DATA05p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000f63f48000001c95c7db88b",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-DATA04p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000e3c7e6000002665c7db862",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-DATA03p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000f63f48000001c75c7db889",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-DATA02p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000e3c7e6000002635c7db855",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-DATA01p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000f63f48000001cd5c7db891",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-REDO02p1"
KERNEL=="dm-*",ENV{DM_UUID}=="part1-mpath-3600a098000e3c7e60000026a5c7db868",OWNER="grid",GROUP="asmadmin",MODE="0660","NAME+=oracleasm/disks/EF570-REDO01p1"

SAN Switch

MINISO-BR6505-01

alias create

$ cat switch1.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }'

alicreate "Netapp_EF560_A1","20:22:00:80:e5:47:97:50"
alicreate "Netapp_EF560_A3","20:42:00:80:e5:47:97:50"
alicreate "Netapp_EF560_B1","20:23:00:80:e5:47:97:50"
alicreate "Netapp_EF560_B3","20:43:00:80:e5:47:97:50"
alicreate "Netapp_E2824_A1","20:22:00:a0:98:d9:82:67"
alicreate "Netapp_E2824_B1","20:23:00:a0:98:d9:82:67"
alicreate "Netapp_FAS2620_A1","20:00:00:a0:98:d9:9d:6d"
alicreate "Netapp_FAS2620_B1","20:02:00:a0:98:d9:9d:6d"
alicreate "RH2288_V3_ESXi01_FC2","10:00:00:90:fa:99:a5:ee"
alicreate "RH2288_V3_ESXi02_FC2","10:00:00:90:fa:99:a5:9e"
alicreate "RH2288_V3_ESXi03_FC2","10:00:00:90:fa:99:ac:7a"
alicreate "RH2288_V3_ESXi04_FC2","10:00:00:90:fa:99:a5:8e"
alicreate "RH2288_V3_ESXi05_FC2","10:00:00:90:fa:99:a5:86"
alicreate "RH2288_V3_BACKUP01_FC2","10:00:00:90:fa:99:a5:ba"
alicreate "RH5885_V3_Oracle01_FC2","21:00:00:24:ff:1c:f4:34"

# 2018-07-19 added

alicreate "Dell_MD3820f_A0","20:12:00:a0:98:d2:23:8a"
alicreate "Dell_MD3820f_B0","20:13:00:a0:98:d2:23:8a"

alicreate "Dell_R630_FC1_ESXi30","21:00:00:24:ff:1a:24:14"
alicreate "Dell_R630_FC1_ESXi31","21:00:00:24:ff:1a:24:26"
alicreate "Dell_R630_FC1_ESXi32","21:00:00:24:ff:1a:24:1e"
alicreate "Dell_R630_FC1_ESXi33","21:00:00:24:ff:1a:24:32"

zonecreate

$ cat switch1.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }' | awk -F"\"" '{ print $2 }' | awk '{ print "zonecreate", "\""$0"_to_Netapp_EF560" "\"" "," "\""$0";""Netapp_EF560_A1;Netapp_EF560_A3;Netapp_EF560_B1;Netapp_EF560_B3" "\""}' | grep Oracle | tee zones_MINISO_BR6505_01.txt
zonecreate "RH5885_V3_Oracle01_FC2_to_Netapp_EF560","RH5885_V3_Oracle01_FC2;Netapp_EF560_A1;Netapp_EF560_A3;Netapp_EF560_B1;Netapp_EF560_B3"
$ cat switch1.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }' | awk -F"\"" '{ print $2 }' | awk '{ print "zonecreate", "\""$0"_to_Netapp_FAS2620" "\"" "," "\""$0";""Netapp_FAS2620_A1;Netapp_FAS2620_B1" "\""}' | grep BACKUP | tee -a zones_MINISO_BR6505_01.txt 
zonecreate "RH2288_V3_BACKUP01_FC2_to_Netapp_FAS2620","RH2288_V3_BACKUP01_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
$ cat switch1.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }' | awk -F"\"" '{ print $2 }' | awk '{ print "zonecreate", "\""$0"_to_Netapp_E2824" "\"" "," "\""$0";""Netapp_E2824_A1;Netapp_E2824_B1" "\""}' | grep ESXi | tee -a zones_MINISO_BR6505_01.txt 

zonecreate "RH5885_V3_Oracle01_FC2_to_Netapp_EF560","RH5885_V3_Oracle01_FC2;Netapp_EF560_A1;Netapp_EF560_A3;Netapp_EF560_B1;Netapp_EF560_B3"
zonecreate "RH2288_V3_BACKUP01_FC2_to_Netapp_FAS2620","RH2288_V3_BACKUP01_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "RH2288_V3_ESXi01_FC2_to_Netapp_E2824","RH2288_V3_ESXi01_FC2;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "RH2288_V3_ESXi02_FC2_to_Netapp_E2824","RH2288_V3_ESXi02_FC2;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "RH2288_V3_ESXi03_FC2_to_Netapp_E2824","RH2288_V3_ESXi03_FC2;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "RH2288_V3_ESXi04_FC2_to_Netapp_E2824","RH2288_V3_ESXi04_FC2;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "RH2288_V3_ESXi05_FC2_to_Netapp_E2824","RH2288_V3_ESXi05_FC2;Netapp_E2824_A1;Netapp_E2824_B1"

# 2018-06-21
zonecreate "RH5885_V3_Oracle01_FC2_to_Netapp_FAS2620","RH5885_V3_Oracle01_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"

# 2018-06-28
zonecreate "RH2288_V3_ESXi01_FC2_to_Netapp_FAS2620","RH2288_V3_ESXi01_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "RH2288_V3_ESXi02_FC2_to_Netapp_FAS2620","RH2288_V3_ESXi02_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "RH2288_V3_ESXi03_FC2_to_Netapp_FAS2620","RH2288_V3_ESXi03_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "RH2288_V3_ESXi04_FC2_to_Netapp_FAS2620","RH2288_V3_ESXi04_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "RH2288_V3_ESXi05_FC2_to_Netapp_FAS2620","RH2288_V3_ESXi05_FC2;Netapp_FAS2620_A1;Netapp_FAS2620_B1"

# 2018-07-19
zonecreate "Dell_R630_FC1_ESXi30_to_Dell_MD3820f","Dell_R630_FC1_ESXi30;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "Dell_R630_FC1_ESXi31_to_Dell_MD3820f","Dell_R630_FC1_ESXi31;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "Dell_R630_FC1_ESXi32_to_Dell_MD3820f","Dell_R630_FC1_ESXi32;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "Dell_R630_FC1_ESXi33_to_Dell_MD3820f","Dell_R630_FC1_ESXi33;Dell_MD3820f_A0;Dell_MD3820f_B0"

### for OLD
zonecreate "Dell_R630_FC1_ESXi30_to_Netapp_E2824","Dell_R630_FC1_ESXi30;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "Dell_R630_FC1_ESXi31_to_Netapp_E2824","Dell_R630_FC1_ESXi31;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "Dell_R630_FC1_ESXi32_to_Netapp_E2824","Dell_R630_FC1_ESXi32;Netapp_E2824_A1;Netapp_E2824_B1"
zonecreate "Dell_R630_FC1_ESXi33_to_Netapp_E2824","Dell_R630_FC1_ESXi33;Netapp_E2824_A1;Netapp_E2824_B1"

zonecreate "Dell_R630_FC1_ESXi30_to_Netapp_FAS2620","Dell_R630_FC1_ESXi30;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "Dell_R630_FC1_ESXi31_to_Netapp_FAS2620","Dell_R630_FC1_ESXi31;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "Dell_R630_FC1_ESXi32_to_Netapp_FAS2620","Dell_R630_FC1_ESXi32;Netapp_FAS2620_A1;Netapp_FAS2620_B1"
zonecreate "Dell_R630_FC1_ESXi33_to_Netapp_FAS2620","Dell_R630_FC1_ESXi33;Netapp_FAS2620_A1;Netapp_FAS2620_B1"


# for MD3820f to NEW
zonecreate "RH2288_V3_ESXi01_FC2_to_Dell_MD3820f","RH2288_V3_ESXi01_FC2;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "RH2288_V3_ESXi02_FC2_to_Dell_MD3820f","RH2288_V3_ESXi02_FC2;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "RH2288_V3_ESXi03_FC2_to_Dell_MD3820f","RH2288_V3_ESXi03_FC2;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "RH2288_V3_ESXi04_FC2_to_Dell_MD3820f","RH2288_V3_ESXi04_FC2;Dell_MD3820f_A0;Dell_MD3820f_B0"
zonecreate "RH2288_V3_ESXi05_FC2_to_Dell_MD3820f","RH2288_V3_ESXi05_FC2;Dell_MD3820f_A0;Dell_MD3820f_B0"

cfg

$ cat zones_MINISO_BR6505_01.txt | awk -F"\"" '{ print $2 }' | sort | tr '\n' ';' | awk ' { print "cfgcreate","\"""MINISO_BR6505_01""\",""\""$0"\"" }'

cfgcreate "MINISO_BR6505_01","RH2288_V3_BACKUP01_FC2_to_Netapp_FAS2620;RH2288_V3_ESXi01_FC2_to_Netapp_E2824;RH2288_V3_ESXi02_FC2_to_Netapp_E2824;RH2288_V3_ESXi03_FC2_to_Netapp_E2824;RH2288_V3_ESXi04_FC2_to_Netapp_E2824;RH2288_V3_ESXi05_FC2_to_Netapp_E2824;RH5885_V3_Oracle01_FC2_to_Netapp_EF560"

# 2018-06-21
cfgadd "MINISO_BR6505_01","RH5885_V3_Oracle01_FC2_to_Netapp_FAS2620"

# 2018-06-21
cfgadd "MINISO_BR6505_01","RH2288_V3_ESXi01_FC2_to_Netapp_FAS2620;RH2288_V3_ESXi02_FC2_to_Netapp_FAS2620;RH2288_V3_ESXi03_FC2_to_Netapp_FAS2620;RH2288_V3_ESXi04_FC2_to_Netapp_FAS2620;RH2288_V3_ESXi05_FC2_to_Netapp_FAS2620"

# 2018-07-19
cfgadd "MINISO_BR6505_01","Dell_R630_FC1_ESXi30_to_Dell_MD3820f;Dell_R630_FC1_ESXi31_to_Dell_MD3820f;Dell_R630_FC1_ESXi32_to_Dell_MD3820f;Dell_R630_FC1_ESXi33_to_Dell_MD3820f"

###
cfgadd "MINISO_BR6505_01","Dell_R630_FC1_ESXi30_to_Netapp_E2824;Dell_R630_FC1_ESXi31_to_Netapp_E2824;Dell_R630_FC1_ESXi32_to_Netapp_E2824;Dell_R630_FC1_ESXi33_to_Netapp_E2824"

cfgadd "MINISO_BR6505_01","Dell_R630_FC1_ESXi30_to_Netapp_FAS2620;Dell_R630_FC1_ESXi31_to_Netapp_FAS2620;Dell_R630_FC1_ESXi32_to_Netapp_FAS2620;Dell_R630_FC1_ESXi33_to_Netapp_FAS2620"

cfgadd "MINISO_BR6505_01","RH2288_V3_ESXi01_FC2_to_Dell_MD3820f;RH2288_V3_ESXi02_FC2_to_Dell_MD3820f;RH2288_V3_ESXi03_FC2_to_Dell_MD3820f;RH2288_V3_ESXi04_FC2_to_Dell_MD3820f;RH2288_V3_ESXi05_FC2_to_Dell_MD3820f"

cfgenable MINISO_BR6505_01

MINISO_BR6505_02

alicreate

alicreate "Netapp_EF560_A0","20:12:00:80:e5:47:97:50"
alicreate "Netapp_EF560_A2","20:32:00:80:e5:47:97:50"
alicreate "Netapp_EF560_B0","20:13:00:80:e5:47:97:50"
alicreate "Netapp_EF560_B2","20:33:00:80:e5:47:97:50"
alicreate "Netapp_E2824_A0","20:12:00:a0:98:d9:82:67"
alicreate "Netapp_E2824_B0","20:13:00:a0:98:d9:82:67"
alicreate "Netapp_FAS2620_A0","20:01:00:a0:98:d9:9d:6d"
alicreate "Netapp_FAS2620_B0","20:03:00:a0:98:d9:9d:6d"
alicreate "RH2288_V3_ESXi01_FC1","10:00:00:90:fa:99:a5:bc"
alicreate "RH2288_V3_ESXi02_FC1","10:00:00:90:fa:99:ab:2a"
alicreate "RH2288_V3_ESXi03_FC1","10:00:00:90:fa:99:a5:a4"
alicreate "RH2288_V3_ESXi04_FC1","10:00:00:90:fa:99:a9:7e"
alicreate "RH2288_V3_ESXi05_FC1","10:00:00:90:fa:99:a5:a2"
alicreate "RH2288_V3_BACKUP01_FC1","10:00:00:90:fa:99:ab:4c"
alicreate "RH5885_V3_Oracle01_FC1","21:00:00:24:ff:1c:f3:df"

# 2018-07-19 added
alicreate "Dell_MD3820f_A1","20:22:00:a0:98:d2:23:8a"
alicreate "Dell_MD3820f_B1","20:23:00:a0:98:d2:23:8a"
alicreate "Dell_R630_FC2_ESXi30","21:00:00:24:ff:1a:24:15"
alicreate "Dell_R630_FC2_ESXi31","21:00:00:24:ff:1a:24:27"

alicreate "Dell_R630_FC2_ESXi32","21:00:00:24:ff:1a:24:1f"
alicreate "Dell_R630_FC2_ESXi33","21:00:00:24:ff:1a:24:33"

zonecreate

$ cat switch2.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }' | awk -F"\"" '{ print $2 }' | awk '{ print "zonecreate", "\""$0"_to_Netapp_EF560" "\"" "," "\""$0";""Netapp_EF560_A0;Netapp_EF560_A2;Netapp_EF560_B0;Netapp_EF560_B2" "\""}' | grep Oracle | tee zones_MINISO_BR6505_02.txt 
zonecreate "RH5885_V3_Oracle01_FC1_to_Netapp_EF560","RH5885_V3_Oracle01_FC1;Netapp_EF560_A0;Netapp_EF560_A2;Netapp_EF560_B0;Netapp_EF560_B2"
$ cat switch2.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }' | awk -F"\"" '{ print $2 }' | awk '{ print "zonecreate", "\""$0"_to_Netapp_FAS2620" "\"" "," "\""$0";""Netapp_FAS2620_A0;Netapp_FAS2620_B0" "\""}' | grep BACKUP | tee -a zones_MINISO_BR6505_02.txt 
zonecreate "RH2288_V3_BACKUP01_FC1_to_Netapp_FAS2620","RH2288_V3_BACKUP01_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
$ cat switch2.txt | awk '{ print "alicreate","\""$1"\""",""\""$2"\"" }' | awk -F"\"" '{ print $2 }' | awk '{ print "zonecreate", "\""$0"_to_Netapp_E2824" "\"" "," "\""$0";""Netapp_E2824_A0;Netapp_E2824_B0" "\""}' | grep ESXi | tee -a zones_MINISO_BR6505_02.txt 

zonecreate "RH5885_V3_Oracle01_FC1_to_Netapp_EF560","RH5885_V3_Oracle01_FC1;Netapp_EF560_A0;Netapp_EF560_A2;Netapp_EF560_B0;Netapp_EF560_B2"
zonecreate "RH2288_V3_BACKUP01_FC1_to_Netapp_FAS2620","RH2288_V3_BACKUP01_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "RH2288_V3_ESXi01_FC1_to_Netapp_E2824","RH2288_V3_ESXi01_FC1;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "RH2288_V3_ESXi02_FC1_to_Netapp_E2824","RH2288_V3_ESXi02_FC1;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "RH2288_V3_ESXi03_FC1_to_Netapp_E2824","RH2288_V3_ESXi03_FC1;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "RH2288_V3_ESXi04_FC1_to_Netapp_E2824","RH2288_V3_ESXi04_FC1;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "RH2288_V3_ESXi05_FC1_to_Netapp_E2824","RH2288_V3_ESXi05_FC1;Netapp_E2824_A0;Netapp_E2824_B0"

# 2018-06-21
zonecreate "RH5885_V3_Oracle01_FC1_to_Netapp_FAS2620","RH5885_V3_Oracle01_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"

# 2018-06-28
zonecreate "RH2288_V3_ESXi01_FC1_to_Netapp_FAS2620","RH2288_V3_ESXi01_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "RH2288_V3_ESXi02_FC1_to_Netapp_FAS2620","RH2288_V3_ESXi02_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "RH2288_V3_ESXi03_FC1_to_Netapp_FAS2620","RH2288_V3_ESXi03_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "RH2288_V3_ESXi04_FC1_to_Netapp_FAS2620","RH2288_V3_ESXi04_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "RH2288_V3_ESXi05_FC1_to_Netapp_FAS2620","RH2288_V3_ESXi05_FC1;Netapp_FAS2620_A0;Netapp_FAS2620_B0"

# 2018-07-19
zonecreate "Dell_R630_FC2_ESXi30_to_Dell_MD3820f","Dell_R630_FC2_ESXi30;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "Dell_R630_FC2_ESXi31_to_Dell_MD3820f","Dell_R630_FC2_ESXi31;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "Dell_R630_FC2_ESXi32_to_Dell_MD3820f","Dell_R630_FC2_ESXi32;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "Dell_R630_FC2_ESXi33_to_Dell_MD3820f","Dell_R630_FC2_ESXi33;Dell_MD3820f_A1;Dell_MD3820f_B1"

### for OLD
zonecreate "Dell_R630_FC2_ESXi30_to_Netapp_E2824","Dell_R630_FC2_ESXi30;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "Dell_R630_FC2_ESXi31_to_Netapp_E2824","Dell_R630_FC2_ESXi31;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "Dell_R630_FC2_ESXi32_to_Netapp_E2824","Dell_R630_FC2_ESXi32;Netapp_E2824_A0;Netapp_E2824_B0"
zonecreate "Dell_R630_FC2_ESXi33_to_Netapp_E2824","Dell_R630_FC2_ESXi33;Netapp_E2824_A0;Netapp_E2824_B0"

zonecreate "Dell_R630_FC2_ESXi30_to_Netapp_FAS2620","Dell_R630_FC2_ESXi30;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "Dell_R630_FC2_ESXi31_to_Netapp_FAS2620","Dell_R630_FC2_ESXi31;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "Dell_R630_FC2_ESXi32_to_Netapp_FAS2620","Dell_R630_FC2_ESXi32;Netapp_FAS2620_A0;Netapp_FAS2620_B0"
zonecreate "Dell_R630_FC2_ESXi33_to_Netapp_FAS2620","Dell_R630_FC2_ESXi33;Netapp_FAS2620_A0;Netapp_FAS2620_B0"

# for MD3820f to NEW
zonecreate "RH2288_V3_ESXi01_FC1_to_Dell_MD3820f","RH2288_V3_ESXi01_FC1;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "RH2288_V3_ESXi02_FC1_to_Dell_MD3820f","RH2288_V3_ESXi02_FC1;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "RH2288_V3_ESXi03_FC1_to_Dell_MD3820f","RH2288_V3_ESXi03_FC1;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "RH2288_V3_ESXi04_FC1_to_Dell_MD3820f","RH2288_V3_ESXi04_FC1;Dell_MD3820f_A1;Dell_MD3820f_B1"
zonecreate "RH2288_V3_ESXi05_FC1_to_Dell_MD3820f","RH2288_V3_ESXi05_FC1;Dell_MD3820f_A1;Dell_MD3820f_B1"

cfg

$ cat zones_MINISO_BR6505_02.txt | awk -F"\"" '{ print $2 }' | sort | tr '\n' ';' | awk ' { print "cfgcreate","\"""MINISO_BR6505_02""\",""\""$0"\"" }' 

cfgcreate "MINISO_BR6505_02","RH2288_V3_BACKUP01_FC1_to_Netapp_FAS2620;RH2288_V3_ESXi01_FC1_to_Netapp_E2824;RH2288_V3_ESXi02_FC1_to_Netapp_E2824;RH2288_V3_ESXi03_FC1_to_Netapp_E2824;RH2288_V3_ESXi04_FC1_to_Netapp_E2824;RH2288_V3_ESXi05_FC1_to_Netapp_E2824;RH5885_V3_Oracle01_FC1_to_Netapp_EF560"

# 2018-06-21
cfgadd "MINISO_BR6505_02","RH5885_V3_Oracle01_FC1_to_Netapp_FAS2620"
# 2018-06-21
cfgadd "MINISO_BR6505_02","RH2288_V3_ESXi01_FC1_to_Netapp_FAS2620;RH2288_V3_ESXi02_FC1_to_Netapp_FAS2620;RH2288_V3_ESXi03_FC1_to_Netapp_FAS2620;RH2288_V3_ESXi04_FC1_to_Netapp_FAS2620;RH2288_V3_ESXi05_FC1_to_Netapp_FAS2620"

# 2018-07-19
cfgadd "MINISO_BR6505_02","Dell_R630_FC2_ESXi30_to_Dell_MD3820f;Dell_R630_FC2_ESXi31_to_Dell_MD3820f;Dell_R630_FC2_ESXi32_to_Dell_MD3820f;Dell_R630_FC2_ESXi33_to_Dell_MD3820f"

##
cfgadd "MINISO_BR6505_02","Dell_R630_FC2_ESXi30_to_Netapp_E2824;Dell_R630_FC2_ESXi31_to_Netapp_E2824;Dell_R630_FC2_ESXi32_to_Netapp_E2824;Dell_R630_FC2_ESXi33_to_Netapp_E2824"

cfgadd "MINISO_BR6505_02","Dell_R630_FC2_ESXi30_to_Netapp_FAS2620;Dell_R630_FC2_ESXi31_to_Netapp_FAS2620;Dell_R630_FC2_ESXi32_to_Netapp_FAS2620;Dell_R630_FC2_ESXi33_to_Netapp_FAS2620"

cfgadd "MINISO_BR6505_02","RH2288_V3_ESXi01_FC1_to_Dell_MD3820f;RH2288_V3_ESXi02_FC1_to_Dell_MD3820f;RH2288_V3_ESXi03_FC1_to_Dell_MD3820f;RH2288_V3_ESXi04_FC1_to_Dell_MD3820f;RH2288_V3_ESXi05_FC1_to_Dell_MD3820f"

cfgenable MINISO_BR6505_02

Redo

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD LOGFILE ('+REDOVG') SIZE 1G;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 50 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 51 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 52 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 53 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 54 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 55 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 56 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 57 ('+REDOVG') SIZE 1G;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 58 ('+REDOVG') SIZE 1G;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';


select member from v$logfile where type='STANDBY';

RMAN

lunch_rman leve0

#
# LEVEL0 
#
# crontab -l
# 0 2 * * * /oracle/autojobs/lunch_rman.sh 2>&1 >>/tmp/lunch_rman.log
#0 12 * * 6 /home/oracle/scripts/lunch_rman_level0.sh 2>&1 >>/tmp/lunch_rman.log
#0 20 * * 0-5 /home/oracle/scripts/lunch_rman_level1.sh 2>&1 >>/tmp/lunch_rman.log

#
#------------------------------------------------------------------

. ~/.bash_profile

#SERVER_IP=`/sbin/ifconfig | head -3 | grep 'addr:' | awk ' { print $2 }' | awk -F":" '{ print $2 }'`
ORACLE_SID=`echo $ORACLE_SID`
LOGDIR=/home/oracle/scripts/logs
WORKDIR=/home/oracle/scripts
DATE=`date +"%F_%H-%M"`
LOGFILE="$LOGDIR"/"Level0_${DATE}.log"

cd $WORKDIR

echo -e "\n\t \E[32m  BACKUP DATABASE LEVEL=0 ---> Starting...    "
sleep 1 
        echo -e "  ."
sleep 0.5
        echo -e "  .."
sleep 0.5
        echo -e "  ..."

rman target / @level0.rcv > $LOGFILE 2>&1

df -h | grep oracle >> $LOGFILE
date +"%F_%H-%M" >> $LOGFILE

lunch_rman leve0

#
# LEVEL1 
#
# crontab -l
# 0 2 * * * /oracle/autojobs/lunch_rman.sh 2>&1 >>/tmp/lunch_rman.log
#
# 0 12 * * 6 /home/oracle/scripts/lunch_rman_level0.sh 2>&1 >>/tmp/lunch_rman.log
# 0 20 * * 0-5 /home/oracle/scripts/lunch_rman_level1.sh 2>&1 >>/tmp/lunch_rman.log

#
#------------------------------------------------------------------

. ~/.bash_profile

#SERVER_IP=`/sbin/ifconfig | head -3 | grep 'addr:' | awk ' { print $2 }' | awk -F":" '{ print $2 }'`
ORACLE_SID=`echo $ORACLE_SID`
LOGDIR=/home/oracle/scripts/logs
WORKDIR=/home/oracle/scripts
DATE=`date +"%F_%H-%M"`
LOGFILE="$LOGDIR"/"Level1_${DATE}.log"

cd $WORKDIR

echo -e "\n\t \E[32m  BACKUP DATABASE LEVEL=1 ---> Starting...    "
sleep 1 
        echo -e "  ."
sleep 0.5
        echo -e "  .."
sleep 0.5
        echo -e "  ..."

rman target / @level1.rcv > $LOGFILE 2>&1

df -h | grep oracle >> $LOGFILE
date +"%F_%H-%M" >> $LOGFILE

level0

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'DISK';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

RUN{
ALLOCATE CHANNEL C1 TYPE DISK;
ALLOCATE CHANNEL C2 TYPE DISK;
ALLOCATE CHANNEL C3 TYPE DISK;
ALLOCATE CHANNEL C4 TYPE DISK;
ALLOCATE CHANNEL C5 TYPE DISK;
ALLOCATE CHANNEL C6 TYPE DISK;
ALLOCATE CHANNEL C7 TYPE DISK;
ALLOCATE CHANNEL C8 TYPE DISK;


backup as compressed incremental level 0 filesperset 8 database format '/oracle-backup/MCPOSDB/%d_set%s_piece%p_%T_%U';
sql 'alter system switch logfile';
backup as compressed archivelog all delete input format './oracle-backup/MCPOSDB/%d_set%s_piece%p_%T_%U';
backup current controlfile format '/oracle-backup/MCPOSDB/controlfile_%d_set%s_piece%p_%T_%U';

RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
RELEASE CHANNEL C3;
RELEASE CHANNEL C4;
RELEASE CHANNEL C5;
RELEASE CHANNEL C6;
RELEASE CHANNEL C7;
RELEASE CHANNEL C8;
}

#allocate channel for maintenance device type disk;
allocate channel for maintenance device TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
list backup summary;
release channel;

level1

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'DISK';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

RUN{
ALLOCATE CHANNEL C1 TYPE DISK;
ALLOCATE CHANNEL C2 TYPE DISK;
ALLOCATE CHANNEL C3 TYPE DISK;
ALLOCATE CHANNEL C4 TYPE DISK;
ALLOCATE CHANNEL C5 TYPE DISK;
ALLOCATE CHANNEL C6 TYPE DISK;
ALLOCATE CHANNEL C7 TYPE DISK;
ALLOCATE CHANNEL C8 TYPE DISK;


backup as compressed incremental level 1 filesperset 8 database format '/oracle-backup/MCPOSDB/%d_set%s_piece%p_%T_%U';
sql 'alter system switch logfile';
backup as compressed archivelog all delete input format './oracle-backup/MCPOSDB/%d_set%s_piece%p_%T_%U';
backup current controlfile format '/oracle-backup/MCPOSDB/controlfile_%d_set%s_piece%p_%T_%U';

RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
RELEASE CHANNEL C3;
RELEASE CHANNEL C4;
RELEASE CHANNEL C5;
RELEASE CHANNEL C6;
RELEASE CHANNEL C7;
RELEASE CHANNEL C8;
}

#allocate channel for maintenance device type disk;
allocate channel for maintenance device TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';

report obsolete;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
list backup summary;
release channel;

calc shm

# Output lines suitable for sysctl configuration based
# on total amount of RAM on the system.  The output
# will allow up to 50% of physical memory to be allocated
# into shared memory.

# On Linux, you can use it as follows (as root):
#
# ./shmsetup >> /etc/sysctl.conf
# sysctl -p

# Early FreeBSD versions do not support the sysconf interface
# used here.  The exact version where this works hasn't
# been confirmed yet.

page_size=`getconf PAGE_SIZE`
phys_pages=`getconf _PHYS_PAGES`

if [ -z "$page_size" ]; then
  echo Error:  cannot determine page size
  exit 1
fi

if [ -z "$phys_pages" ]; then
  echo Error:  cannot determine number of memory pages
  exit 2
fi

shmall=`expr $phys_pages / 2`
shmmax=`expr $shmall \* $page_size`

echo \# Maximum shared segment size in bytes
echo kernel.shmmax = $shmmax
echo \# Maximum number of shared memory segments in pages
echo kernel.shmall = $shmall

change modify crs resource

crsctl modify res ora.mcwmsgz.db -attr "SPFILE=/oracle/product/11.2.0/db_1/dbs/spfilemcwmsgz.ora"
crsctl modify res ora.mcwmsgz.db -attr "ENABLED=0"

désert/workarea/ayy/DataGuard (last edited 2019-03-05 08:12:59 by 192)