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

  • Connecting to CDB and PDB – Oracle Database 12c

    Connecting to CDB and PDB – Oracle Database 12c

    Connecting to CDB and PDB in Oracle Using Easy Connect Syntax Connecting to CDB and PDB in Oracle Using Easy Connect Syntax When a Container Database (CDB) is created in Oracle, a service is automatically created with the same name as the CDB. Similarly, when a Pluggable Database (PDB) is…

    Continue reading →: Connecting to CDB and PDB – Oracle Database 12c

  • Working with Tables and Materialized Views in Oracle: A Practical Guide

    Working with Tables and Materialized Views in Oracle: A Practical Guide

    “Materialized views are a powerful feature in Oracle databases that enhance performance by storing query results, making data retrieval faster and more efficient. However, one key aspect often overlooked is the need to keep these views synchronized with the base tables, especially when underlying data changes. In this guide, we’ll…

    Continue reading →: Working with Tables and Materialized Views in Oracle: A Practical Guide

  • Create Oracle Control file manually

    Create Oracle Control file manually

    When to create control files ? Create control files in situations when : 1. You have lost all your control files. 2. When you want to rename your database name (db_name); Note :although we can use utility called DBNEWID to change the DBNAME. DBNEWID can be used to change :…

    Continue reading →: Create Oracle Control file manually

  • Oracle Database files to be excluded in Anti-virus or any third party tools scan

    Oracle Database files to be excluded in Anti-virus or any third party tools scan

    Oracle Database Files to Exclude from Antivirus and Third-Party Scans Oracle Database Files to Exclude from Antivirus and Third-Party Scans Properly managing antivirus and third-party scans is critical for maintaining the stability and performance of your Oracle Database. Failing to exclude essential database files from scans can lead to file…

    Continue reading →: Oracle Database files to be excluded in Anti-virus or any third party tools scan

  • QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database

    QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database

    Finding Archive gap between PRIMARY and STANDBY      A Physical Standby database syncs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby is less than 10-15 numbers, We can simple ship the logs which are missing in the standby…

    Continue reading →: QUERY TO FIND ARCHIVE GAP BETWEEN PRIMARY AND STANDBY in ORACLE Database

  • Working with Oracle Database Flashback Recovery

    Working with Oracle Database Flashback Recovery

      Configuring Flashback Recovery in Oracle Database Flashback Database is a powerful feature in Oracle that allows you to rewind your database to a previous state without requiring traditional point-in-time recovery. Starting from Oracle 11g R2, enabling Flashback Database no longer requires a database restart. For earlier versions, a database…

    Continue reading →: Working with Oracle Database Flashback Recovery

  • Audit Failed Logon Attempts in Oracle Database

    Audit Failed Logon Attempts in Oracle Database

        Audit Failed Logon Attempts in Oracle Database. Failed logon attempts can cause account locks, resulting in disruptions for users and increased workload for DBAs. Identifying the source of failed logon attempts is crucial for troubleshooting and preventing further issues. Oracle’s audit functionality provides an efficient way to track…

    Continue reading →: Audit Failed Logon Attempts in Oracle Database

  • Managing Old Log Files on Linux Directories: Deletion and Compression

    Managing Old Log Files on Linux Directories: Deletion and Compression

    Managing Old Files in Oracle Directories: Deletion and Compression Managing Old Files in Oracle Directories: Deletion and Compression Managing disk space is a crucial task for database administrators, especially in environments where large amounts of data are exported and stored. Oracle database environments often utilize directory paths such as /u01/app/oracle/dpump…

    Continue reading →: Managing Old Log Files on Linux Directories: Deletion and Compression

  • ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

    ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

    When you start or stop you oracle service in Unix/Linux system and you get the prompt of ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener error.   [oracle@linux1bin]$ echo $ORACLE_SID qptest [oracle@linux1 bin]$ . dbshut ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener Usage: -bash ORACLE_HOME…

    Continue reading →: ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener

  • Generate sql file from EXPDP/IMPDP

    Generate sql file from EXPDP/IMPDP

    It’s straight forward to generate DDL SQL Script from any specific schema. However, it has nothing to do with expdp. expdp arvind/password schemas=hr directory=DPUMP dumpfile=HR_2014_08_13.dmp logfile=impsql_HR_2014_08_13.log while importing you need to specify .sql file name using impdp, it will generate DDL SQL Script for any specific schema.  [oracle@qpdbdev202 dpump]$ impdp…

    Continue reading →: Generate sql file from EXPDP/IMPDP

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