Database administrators (DBAs) play a critical and often underappreciated role in the world of information technology.
Sharing knowledge is the ultimate key to gaining knowledge…
The only two things that stay with you for life are you & your knowledge...
Live while you can! Teach & inspire while you could & Smile while you have the teeth.
-
ASM
- Creating ASM Instance and diskgroups manually without DBCA
- 20 ASM Realtime | Interview Questions
- How to make a cold backup for database running on ASM ( using RMAN )
- Moving a Single Datafile from File System to ASM System (METHOD 1)
- Moving a Single Datafile from File System to ASM System (METHOD 2)
- Things to consider while adding new disk/ Rebalancing existing Disk Group
-
Dataguard
- Dataguard Modes
- Dataguard Modes - II
- Oracle DataGuard Setup
- invalid archived log deletion policy
- recover from the Loss of a Datafile on a Standby Database ?
- MRP terminated with ORA-00600: internal error code, arguments
- Recover archive gaps in standby database - using 2 methodss
- Gap Resolution in Dataguard
- Convert Physical Standby to Snapshot Standby and Vice Versa
- Re-create Redo-logs on Standby/ Primary
- Pre-check for DataGuard switchover Process
- ORA-19815: WARNING: db_recovery_file_dest_size
- How do you purge old archivelogs which are applied on Standby DB
- Pre-check For SWITCHOVER using DG Broker
- https://oracle-dba-help.blogspot.com/2016/03/data-guard-modes.html
- ORA-01274 : RENAME THE UNKNOW FILE IN THE STANDBY DATABASE
- Database Creation in Easy 6 Steps
- Oracle Networking
- Tablespace management
- Housekeep : Quick Tips for DBA
- Health check for DB
- ORA-12537 While Connecting To Database Via Listener
- How to identify the applied patche-set of your Oracle Home
- Accessing a schema without knowing the password
- ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
- Session Related Scripts
- How to check ORA Error on DB Server – Beginner Tip
- Working with Redo Logs
- Decommission of Oracle Database
- Roles in Oracle - Managing Users
- Oracle Release Number Format
- Troubleshooting Handy-Guide
- Understanding the Upgradation Process
- Query to find the session creating more redo
- Audit in Oracle
- Troubleshooting Internal Errors and Error-Look-up Tool on MOS
- Troubleshooting Issues with Undo Tablespace
- User Management
- User Management - II
- Data Pump Gets Better
- MEMORY_TARGET Parameter
- Installing PostgreSQL Server on CentOS, RHEL 6 / 7 Systems
- Creating a database in Postgres
- Initialize multiple Postgres instance on the same RHEL server
- How to stop starting of clusters while starting up services
- Setup a streaming replication
- Switchover- master server and warm standby (with streaming replication)
- All About Physical Replication and Log shipping
- PostgreSQL Upgrade and troubleshooting
- Timeline Switch issue
- Query to identify the lag in replication
- Drop table : ERROR: must be owner of relation table_name
- PgBadger
- PgCenter
- PgTune
- Internals of Toast Table
- Influencing Query Execution Plan
- Create Extension ERROR
- Find Uptime in PostgreSQL
- Set DB Timezone
- Clear RAM Cache, Buffer
- Read-Only User in Postgres
- Everything you need to know about Streaming Replication
- Ora2Pg Migrate Oracle to Postgres
- Total Page Cost
- PostgreSQL 13 - Everything you need to know
- Startup Failure - .conf file
- All About Postgres Upgrade
- Basic Guide
- Session Related Scripts
- AWR :: Beginners Guide
- All About ASH - Active Session History
- Wait Events : checkpoint busy waits or archiver busy waits
- Find sessions performing sort operations : TEMP Tablespace occupants
- Generate ADDM task and generate its report for Tuning
- Database Performance Tuning Scripts -Keep Handy
- Buffer Busy Wait
- Simulating the Deadlock
- Latches
- Steps to Schedule any RMAN Jobs In Windows Server
- ORA-01194: file 1 needs more recovery to be consistent
- Loss of Current Online Redo-Log
- RMAN "baby Steps"
- Recovery of ControlFiles
- Loss of Datafile
- Recovery from complete loss of all online redo log files
- Block Change Tracking
- RMAN Questions
- Instance Recovery
- Redundancy and Recovery window in RMAN
- Cold Backup
- Database Cloning
- Contact
- Drop Database using RMAN
- PITR to older Incarnation
Saturday 11 November 2023
Friday 29 September 2023
Agile is NOT FAST….
Agile is a widely adopted and highly effective approach to software development and project management in the IT environment. It has gained popularity for several reasons, and its principles and practices have proven to be beneficial for many organizations.
Friday 4 February 2022
Tracing Oracle Data Guard
Tracing can also be enabled in dataguard using the parameter "Log_Archive_Trace"
The values can be set using DG-Broker (if configured) or at SQL prompt as below.
Saturday 15 January 2022
Feedspot - Top database blog list
Dear All,
I am pleased to inform that I received this recognition from Feedspot and I'm proud to be part of the awesome family- Thank you Anuj and Team for this recognition!
Saturday 18 December 2021
12c Wallet creation and tablespace encryption
The following article describes the steps to create the wallet and perform a tablepsace encryption.
Saturday 4 December 2021
Datapump Errors and Solutions
SCOPE
The article covers common & complex error occurs during the Datapump Export and Import operations
Friday 19 November 2021
Oracle Instance Startup Failure | Instance terminated by GEN0
SCOPE
Recently a server running both Oracle databases with version 11.1.0.2 had to be forced powered cycled due to a NFS issue. Since it wasn’t possible to login to the O/S to shutdown the DBs an instance recovery was required on both the 11.2 databases.
Saturday 6 November 2021
Resmgr:Cpu Quantum | Oracle wait event
SCOPE
Application job are running slow and DBA finds out the wait event as "Resmgr:Cpu Quantum" for multiple sessions running in database.
Sunday 17 October 2021
ASM Diskspace utilization categorized by Database/File names
SCOPE
Below script helps to identify the space utilization of Databases including the files such as Datafiles, Redologfiles, Archivelog files on ASM diskgroup categorized by Database names and their files.
Saturday 2 October 2021
ORA-12519: TNS:no appropriate service handler found (followed by ORA-00020)
SCOPE
Application complains about the error ORA-12519: TNS:no appropriate service handler found while connection to the database.
Sunday 19 September 2021
Saturday 4 September 2021
Open Resetlog Failure : ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
SCOPE
Restoring
the database using RMAN backup.
After completion of cloning to the staging environment, OPEN RESETLOGS fails with error as below.
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
Saturday 14 August 2021
ORA-20001: Job failed: ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS
SCOPE
Application jobs fails with messages as below.
ORA-20001:
Job failed
ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS
Sunday 1 August 2021
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init]
Below document explains the issue faced after the upgrade, troubleshooting and need for timezone files.
Friday 30 July 2021
Oracle or PostgreSQL
At the point when you take a gander at PostgreSQL versus Prophet data set administration frameworks, the primary distinction between these two information bases is that PostgreSQL is an open-source data set, while Oracle is a shut data set framework.
Friday 16 July 2021
Shutdown is taking forever, can only do a SHUTDOWN ABORT
We recently performed the cloning of the staging Database from a production database, but unfortunately we faced an issue.
Once the restore is complete, we were not able to stop the database to rename it and perform the post checks.
Wednesday 14 July 2021
Identifying PID/SPID for killed session in 11g
Many times when we kill a session with alter system kill session command ( or Toad )
Friday 4 June 2021
Uncommitted transactions in Oracle
Lets assume that we have an update, insert or delete statement that running but has not been committed yet. So question is how to show uncommitted transactions ?
Friday 28 May 2021
Read the sqlnet trace files
While troubleshooting sqlnet issue a week back and we used very same article to read trace files. It was very useful.
Friday 21 May 2021
Open Oracle Database with Delay Option
Found an interesting event, that helps to open the database with delay option. The event db_open_begin delay (opening database with delay) is undocumented event ( read unsupported )