Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

Archive for February, 2021

How to backup of the ASM HEADER in Oracle ASM Database.

Posted by Mir Sayeed Hassan on 8th February 2021

How to backup of the ASM HEADER in Oracle ASM Database. Overview of ASM Disk Header ASM disk header contains the metadata essential for the operation and availability of an ASM disk group, ASM disks are formatted into Allocation Units, The… Read more..

Posted in ASM | Comments Off on How to backup of the ASM HEADER in Oracle ASM Database.

Move the datafile in standby database from one disk to another in Oracle 11gR2(11.2.0.4)

Posted by Mir Sayeed Hassan on 3rd February 2021

Move the datafile in standby database from one disk to another in Oracle 11gR2(11.2.0.4) Check the database status SQL> select version,instance_name,open_mode from V$database,v$instance; VERSION           INSTANCE_NAME    OPEN_MODE ——- —————- ——————– 11.2.0.4.0        teststd         MOUNTED Fallow… Read more..

Posted in DBA Administration | Comments Off on Move the datafile in standby database from one disk to another in Oracle 11gR2(11.2.0.4)

How to extend/increase the size of a existing Linux LVM disk by adding a new disk

Posted by Mir Sayeed Hassan on 3rd February 2021

How to extend/increase the size of a existing Linux LVM disk by adding a new disk Detect the new disk space [root@testdb ~]# echo “- – -” > /sys/class/scsi_host/host0/scan New disk allocated to extend existing disk [root@testdb ~]# fdisk -l Disk /dev/sdf: 322.1 GB, 322122547200 bytes 255 heads, 63 sectors/track, 39162 cylinders Units… Read more..

Posted in UNIX for DBA | Comments Off on How to extend/increase the size of a existing Linux LVM disk by adding a new disk