Blog Posts

DELETE OS AUDIT FILES IN ORACLE

February 9, 2019

[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, Data Mining and Real Application…
Extracting Tablespace DDLs in Oracle Database

December 12, 2018

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 (DDL) statements for tablespaces using…
Understanding and Managing Oracle ASH Emergency Flushes

June 25, 2018

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.
create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line

June 19, 2017

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 environmental path: In my…
ORA-01113: file string needs media recovery

April 23, 2015

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.