oracle | Vinicius DBA

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Hi everyone, Hope you’re doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and meeting Service Level Agreements (SLAs). Oracle Enterprise Manager (OEM) provides a comprehensive way for monitoring and managing database uptime. With that said, I received a…

Vinicius, 3 months ago 0 4 min read

Administration, Database

Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits

Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading the table using the INSERT statement for each agency (agency_id), with thousands of records for each agency. They complained that…

Vinicius, 4 months ago 0 9 min read

Administration, Database

How to Efficiently Export a Large List of Tables with DataPump

Hi everyone, hope you’re doing good! I’m a member of a WhatsApp Group in Brazil for DBAs (not only Oracle), and one of the members asked about how to export a large list of tables with DataPump. This question may sound a little bit basic,…

Vinicius, 4 months ago 0 3 min read

Administration, Database

STARTUP MOUNT failed with ORA-00210 ORA-00202 ORA-27086

Hi everyone, Hope you’re doing good. I’m working for a client which has Oracle DB for SAP applications. Those DB’s are not using RAC, yes, I know 🙂 SAP does not support use RAC in its fullness, as cannot use services…

Vinicius, 1 year ago 0 6 min read

Administration

Duplicate Database Hanging on “remote db file read”

Hi guys, Hope to you are good! I am working in a project to migrate some databases to Oracle RAC, and we decided to move to the RAC Databases using DataGuard approach, since a Switchover usually finishes really fast and the downtime window it will…

Vinicius, 5 years ago 0 2 min read

Architecture, Architecture, Clusterware

DiskGroup GRID: Understanding its contents

Hey all! In this blog post we’ll basically check what is the content for DiskGroup that was created by default when you install Oracle Grid Infrastructure in a Standalone Cluster configuration. This post applies to: Versions: 12.2.0.1; 18c; 19c. Environments: OnPremises; Cloud. When you install…

Vinicius, 5 years ago 0 5 min read

Administration

RMAN-03002 RMAN-05501 RMAN-04014 ORA-27528 when Duplicating Database

Hey all, Hope you are OK! A great friend from mine call me some days ago because he was with a issue with Duplicate Database, with the following error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db…

Vinicius, 5 years ago 0 2 min read

Administration

Shell Script to create copy of OCR Backup to a filesystem

Hey all! Hope you are OK! In the most recent versions of Grid Infrastructure, Oracle has changed the default location for OCR Backup from filesystem to an ASM DiskGroup. One of the goals is to make sure that the backup will be stored in a…

Vinicius, 6 years ago 1 2 min read

Tag: oracle

How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views

Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits

How to Efficiently Export a Large List of Tables with DataPump

STARTUP MOUNT failed with ORA-00210 ORA-00202 ORA-27086

Duplicate Database Hanging on “remote db file read”

DiskGroup GRID: Understanding its contents

RMAN-03002 RMAN-05501 RMAN-04014 ORA-27528 when Duplicating Database

Shell Script to create copy of OCR Backup to a filesystem

About

Blog recognized by:

Disclaimer

Find

Archive

Blogroll Internacional

Blogroll Nacional

Links

Visitors