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 the 'DBA Scripts' Category

DB dumpfile backup using NAS Storage

Posted by Mir Sayeed Hassan on 30th April 2018

Login with Oracle user & create the mnt directory [oracle@testdb ~]$ pwd /home/oracle [oracle@testdb ~]$ mkdir mnt [oracle@testdb mnt]$ pwd /home/oracle/mnt Login as the root & create the mount_nas.sh file [root@testdb scripts]# cd /home/oracle/scripts/

Posted in DBA Scripts | Comments Off on DB dumpfile backup using NAS Storage

Script to automatically startup and shutdown the Oracle database 11gR2

Posted by Mir Sayeed Hassan on 17th February 2018

Script to automatically startup and shutdown the Oracle database 11gR2 Fallow the below step by step procedure as shown below: Create the directory as shown below: [oracle@ogg-test1 ~]$ pwd /home/oracle [root@oracleTestServer ~]# mkdir -p /home/oracle/scripts [root@oracleTestServer… Read more..

Posted in DBA Scripts | Comments Off on Script to automatically startup and shutdown the Oracle database 11gR2