-
Oracle Shrink Table – regain your space back
Continue reading →: Oracle Shrink Table – regain your space backI believe this is better explained with an example.Sql code: lets first check if your database table spaces that re in manual and auto segment space management. SELECT tablespace_name, extent_management, segment_space_management FROM dba_tablespaces; TABLESPACE_NAME EXTENT_MANAGEMENT SEGMENT_SPACE_MANAGEMENT—————————— —————– ————————SYSTEM …
-
OCA 1Z0-051 dumps
Continue reading →: OCA 1Z0-051 dumps1Z0-051 dump pdf free download – Oracle 11g SQL Fundamentals I Download Here: 1Z0-051-1 Download Here: 1Z0-051-2 Exam Details : Oracle Database 10g and 11g: SQL Fundamentals I 1Z0-051 Exam Number: 1Z0-051 Associated Certifications: Oracle Database 11g Administrator Certified Associate …
-
1Z0-052 dump pdf free download
Continue reading →: 1Z0-052 dump pdf free downloadOracle Certified Associate – OCA 1Z0-052 dump pdf free download – Oracle 11g Database Administration I Download Here : 1Z0-052Exam Details :Oracle Database 11g: Administration I 1Z0-052 Exam Number: 1Z0-052 Associated Certifications: Oracle Database 11g Administrator Certified Professional Exam Product Version:…
-
Applying CPU Patch On Primary Database Server Environment
Continue reading →: Applying CPU Patch On Primary Database Server EnvironmentApplying 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…
-
Applying CPU Patch in a dataguard (Physical Standby) environment
Continue reading →: Applying CPU Patch in a dataguard (Physical Standby) environmentHere 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…
-
Rman Recovery comands….
Continue reading →: 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…
-
Oracle Database Load Capture
Continue reading →: 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…
-
CORRUPTION DETECTED: on Standby server
Continue reading →: CORRUPTION DETECTED: on Standby serverCORRUPTION 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…
-
Rman System datafile recovery scenerio
Continue reading →: Rman System datafile recovery scenerioSystem 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…
-
RMAN FULL database recovery scenerio
Continue reading →: RMAN FULL database recovery scenerioFull 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…
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
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.
