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

  • Applying CPU Patch On Primary Database Server Environment

     Applying CPU Patch On Primary Database Server Environment.  Step 1: Incase if you have standby server. Now disable log shipping on the primary database by setting the log_archive_dest_state_2 to disable. As I said earlier, parameter log_archive_dest_2 on my primary database is set to point to the standby database. SQL> alter…

    Continue reading →: Applying CPU Patch On Primary Database Server Environment

  • Applying CPU Patch in a dataguard (Physical Standby) environment

    Here is a brief explanation on how to apply CPU(Critical Patch Update) in a dataguard environmentIn this demo, I am applying PSU 11.2.0.4.2 on the Primary and standby databases. Standby  Database Name :ORCL_STBYPrimary  Database Name : ORCL Primary Server: [oracle@PRIM ~]$ sqlplus sys/oracle@srprim as sysdba SQL*Plus: Release 11.2.0.2.0 Production on…

    Continue reading →: Applying CPU Patch in a dataguard (Physical Standby) environment

  • Rman Recovery comands….

    Rman Time-based PITR run{allocate channel dev1 type disk;set until time “to_date(‘2014-03-24:00:00:00’, ‘yyyy-mm-dd:hh24:mi:ss’)”;restore database;recover database; } or run{allocate channel dev1 type disk;set until time “to_date(‘2014-03-25:00:00’, ‘yyyy-mm-dd:hh24:mi’)”;restore database;recover database; } Rman Time-based Controlfile PITR run{SET UNTIL TIME “TO_DATE(‘20140323:12:01′,’YYYYMMDD:HH24:MI’)”; RESTORE CONTROLFILE FROM AUTOBACKUP preview;}

    Continue reading →: Rman Recovery comands….

  • Oracle Database Load Capture

    [oracle@orcl01 dbcapture]$ sqlplus /”as sysdba” SQL*Plus: Release 10.2.0.4.0 – Production on Fri Dec 20 10:26:01 2013 Copyright (c) 1982, 2007, Oracle.  All Rights Reserved. Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options It looked like a nice…

    Continue reading →: Oracle Database Load Capture

  • CORRUPTION DETECTED: on Standby server

     CORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 Problem Summary  ————————————————— CORRUPTION DETECTED: In redo blocks starting at block 2049count 1679 for thread 1 sequence 7677 Problem Description ————————————————— Primary database is in MAXIMUM PERFORMANCE mode Thu Jun 05 13:38:37 2014 RFS[2849]: Assigned to RFS…

    Continue reading →: CORRUPTION DETECTED: on Standby server

  • Rman System datafile recovery scenerio

    System datafile recovery: Lets create a scenario where we will drop the system datafile, and we will recover using the rman restore and recover process.Since system datafile is key for database functioning. Before we start. Lets verify that database is functioning without any problems. [oracle@linux1 ~]$ sqlplus /”As sysdba” SQL*Plus:…

    Continue reading →: Rman System datafile recovery scenerio

  • RMAN FULL database recovery scenerio

    Full database recovery : We will create a scenerio where we will drop all the datafiles and do a full database recovery. Database name : ORCL Assuming that you have already taken the full database backup (if not please take the full backup before your perform this test/task). Database is…

    Continue reading →: RMAN FULL database recovery scenerio

  • How To Shrink Table AUD$

    The SYSTEM tablespace is created with manual segment allocation and as such it is not possible to run the SHRINK command for the objects that are located within. However, if the AUD$ table is moved to another tablespace (locally managed with automatic segment space management) then it can be shrunk.…

    Continue reading →: How To Shrink Table AUD$

  • Drop database including Rman backups in oracle

    Example –  Deleting a Database In this example, you want to delete a test database called test1 that is registered in the recovery catalog. You start the RMAN client, connect to database test1 as TARGET, and connect to the recovery catalog. You then run the following commands to delete the target…

    Continue reading →: Drop database including Rman backups in oracle

  • ORA-29516: Aurora assertion failure: Assertion failure

    ORA-29516: Aurora assertion failure: Assertion failure From Oracle 11g release 1 (11.1), Oracle introduces just-in-time(JIT) compiler for Oracle JVM environment, which results in faster execution because invalidation, recompilation, and storage of code is done dynamically. JIT is controlled by parameter java_jit_enabled, and if it is set to TRUE then the…

    Continue reading →: ORA-29516: Aurora assertion failure: Assertion failure

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