Mir Sayeed Hassan – Oracle Blog

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

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