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

  • Purging a Database Audit Trail AUD$

    Purging a Subset of Records from the Database Audit Trail You can manually remove records from the database audit trail tables. This method can be useful if you want to remove a specific subset of records. You can use this method if the database audit trail table is in any…

    Continue reading →: Purging a Database Audit Trail AUD$

  • Create a sample schema with 1millions rows in Oracle

    We always to test the database for various reasons we will need to create a tables  with a lot of data in it.We can use below script that will allow us to create a table and populate the table with 10,00,000 rows with simple plsql block. This is just for…

    Continue reading →: Create a sample schema with 1millions rows in Oracle

  • How to Add/Drop/Rename Standby Redolog file

     How to Drop/Rename Standby Redolog file in Oracle 11gWhile performing the dataguard Broker, we need to drop the standby database while switchover the standby . As it seems an easy task but it is bit tricky . Below are the steps to drop the redolog file from standby database :…

    Continue reading →: How to Add/Drop/Rename Standby Redolog file

  • Oracle Active Data Guard Or Oracle GoldenGate

    Oracle Active Data Guard and Oracle GoldenGate Oracle Active Data Guard and Oracle Golden Gate are strategic capabilities within Oracle’s software portfolio. While they generally fall into the category of replication technologies, each has a very different area of focus.Oracle Active Data Guard provides the best data protection and availability…

    Continue reading →: Oracle Active Data Guard Or Oracle GoldenGate

  • TOAD USER SCRIPT

    SCRIPT TO CREATE TOAD USER : I really had to struggle a lot to get this script.Creating these objects as toad user will allow u to gathers stats for disk ,data file and table spaces growth and trending. This scipt need to be run as toad user to create all…

    Continue reading →: TOAD USER SCRIPT

  • Monitoring standby database made easy

    we can use a simple trick to check if the standby database is up to date or not : The trick is we are going to create a table and populate it every minute on primary server with a scheduled job using a  simple procedure.When we query the standby server…

    Continue reading →: Monitoring standby database made easy

  • ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be created

    SQL> alter database add standby logfile ‘/u02/oracle/oradata/stdby01.log’ size 512M; Database altered. SQL> alter database add standby logfile ‘/u02/oracle/oradata/stdby02.log’ size 512M; Database altered. SQL> alter database drop standby logfile ‘/u02/oracle/oradata/stdby01.log’; Database altered. SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG; GROUP#    THREAD#  SEQUENCE# ARC STATU—— ———- ———- — —–     6          0          0 YES UNASS                                …

    Continue reading →: ORA-00301: error in adding log file ‘stdby02.log’ – file cannot be created

  • How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases

    How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases Lets now try to export tables from different schemas in Oracle 10g database on a Linux server. [oracle@localhost ~]$ sqlplus / as sysdba We are assuming that a1 and a2 are 2 schemas …

    Continue reading →: How to export tables from multiple schemas with Oracle Data Pump in Oracle 10g and 11g databases

  • Oracle Tablespace High water mark

    Oracle Tablespace High water mark Tablespace High water mark Tablespace HWM col tablespace_name format a15col file_size format 99999col file_name format a50col hwm format 99999col can_save format 99999 SELECT tablespace_name, file_name, file_size, hwm, file_size-hwm can_saveFROM (SELECT /*+ RULE */ ddf.tablespace_name, ddf.file_name file_name,ddf.bytes/1048576 file_size,(ebf.maximum + de.blocks-1)*dbs.db_block_size/1048576 hwmFROM dba_data_files ddf,(SELECT file_id, MAX(block_id) maximum…

    Continue reading →: Oracle Tablespace High water mark

  • RMAN Backup Optimization

    RMAN Backup Optimization From 11G R1 onwards only undo data blocks containing undo data for not yet committed — or rolled back — transactions are backed up. Undo data in the undo tablespace still required to satisfy the undo retention but only containing undo records for already committed transactions are…

    Continue reading →: RMAN Backup Optimization

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