Arvind Toorpu

Database Administration & Architecture

Hi, I’m Arvind Toorpu.

I’m a Database Admin/Architect with 14+ years managing Oracle, SQL Server, and cloud (AWS/RDS) systems. This blog covers the cloning, tuning, security, and migration work that keeps databases running.

Read the blog
About me
Arvind Toorpu

  • Automating Oracle ADDM Reports via Email Using PL/SQL

    Automating Oracle ADDM Reports via Email Using PL/SQL

    Learn how to automate Oracle ADDM report generation and send it via email using PL/SQL. This guide walks through the process, including necessary configurations and a practical script example.

    Continue reading →: Automating Oracle ADDM Reports via Email Using PL/SQL

  • Oracle audting explained

    Oracle audting explained

        Oracle AUDIT Explained: A Comprehensive Guide Oracle Database auditing is a vital feature for tracking database activities, ensuring compliance, and identifying security issues. This guide covers enabling and disabling auditing, audit trail options, cleaning up audit logs, and more. Configuration Options: Enable database auditing with extended information: ALTER…

    Continue reading →: Oracle audting explained

  • DELETE OS AUDIT FILES IN ORACLE

    DELETE OS AUDIT FILES IN ORACLE

    [atoorpu@ORACLE1 adump]$ pwd/u01/app/oracle/admin/ORCL/adump[atoorpu@ORACLE1 adump]$ ls -1 /u01/app/oracle/admin/ORCL/adump | wc -l22273[atoorpu@ORACLE1 adump]$ ls -lrt *aud | wc -l11363[atoorpu@ORACLE1 adump]$ sqlplus /”As sysdba”SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 9 10:40:58 2015Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP,…

    Continue reading →: DELETE OS AUDIT FILES IN ORACLE

  • Extracting Tablespace DDLs in Oracle Database

    Extracting Tablespace DDLs in Oracle Database

    Extracting Tablespace DDLs in Oracle Database Extracting Tablespace DDLs in Oracle Database When creating a new Oracle database similar to an existing one, you might need to replicate the tablespaces from the original database. Instead of manually recreating tablespaces, Oracle provides a simple way to extract the Data Definition Language…

    Continue reading →: Extracting Tablespace DDLs in Oracle Database

  • Understanding and Managing Oracle ASH Emergency Flushes

    Understanding and Managing Oracle ASH Emergency Flushes

    Learn how to diagnose and manage Oracle ASH emergency flushes effectively. This guide provides steps to monitor ASH performance, increase ASH size, and ensure database stability.

    Continue reading →: Understanding and Managing Oracle ASH Emergency Flushes

  • create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line

                                            vboxmanage command line  For our scenario : Lets create shared disks (vdi) on Virtualbox for ASM setup.  If you are getting error like below make sure you have virtual-box set in your…

    Continue reading →: create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line

  • ORA-01113: file string needs media recovery

    ORA-01113: file string needs media recovery

    Learn how to resolve the ORA-01113: File Needs Media Recovery error in Oracle Database. Understand its causes, follow step-by-step resolutions, and apply best practices to prevent recurrence.

    Continue reading →: ORA-01113: file string needs media recovery

  • Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide

    Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide

    Learn how to configure email notifications for Oracle Scheduler jobs. This guide covers SMTP server setup, defining default senders, creating jobs, and setting up job notifications for proactive monitoring.

    Continue reading →: Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide

  • Trigger to backup the data before delete or update on a table – Oracle

    Lets create a table : CREATE TABLE “ABC”    ( “EMPNO” NUMBER(4,0),  “ENAME” VARCHAR2(10 BYTE),  “JOB” VARCHAR2(9 BYTE),  “MGR” NUMBER(4,0),  “HIREDATE” DATE,  “SAL” NUMBER(7,2),  “COMM” NUMBER(7,2),  “DEPTNO” NUMBER(2,0)   ) TABLESPACE “USERS” ;Now we will insert some data into it :Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,’SMITH’,’CLERK’,7902,to_date(’17-DEC-80′,’DD-MON-RR’),800,null,20);Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,’ALLEN’,’SALESMAN’,7698,to_date(’20-FEB-81′,’DD-MON-RR’),1600,300,30);Insert into ABC…

    Continue reading →: Trigger to backup the data before delete or update on a table – Oracle

  • Generating Random Data in Oracle Tables for Testing

    Generating Random Data in Oracle Tables for Testing

    Learn how to use Oracle’s DBMS_RANDOM package to generate random test data for your tables. This guide covers random strings, numbers, and dates with PL/SQL examples.

    Continue reading →: Generating Random Data in Oracle Tables for Testing

Hello,

Arvind Toorpu

I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems

Let’s connect

Join the fun!

Stay updated with our latest tutorials and ideas by joining our newsletter.

Recent posts