oracle database | Vinicius DBA

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, 3 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, Database, RAC

Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 3

Hi all, Hope you are all good. This is the last post showing how to create a clone of ASM Disks to do your DB clone very quickly to use it as a target for GoldenGate. Just to recap what we did in the last…

Vinicius, 3 years ago 0 3 min read

Administration, Database, RAC

Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 2

Hi all, Hope you are all good. This is the second post showing how to create a clone of ASM Disks to do your DB clone very quickly to use it as a target for GoldenGate. Just to recap what we did in the last…

Vinicius, 3 years ago 0 1 min read

Administration, Database, RAC

Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 1

Hi all, Hope you are all good. I was working in an Upgrade project where some DB’s the downtime must be reduced. So, we decided to use GoldenGate. In this blog post I will not show how to configure and setup GoldenGate replication. This…

Vinicius, 3 years ago 0 4 min read

RAC

Oracle RAC Database Backup: Backup Scheduling on All Nodes

Hey all, Hope you are safe and healthy during pandemic. This post can be very simple for some people, but, it will be useful to another ones. Some weeks ago a client had asked for our support. Their issue was with a cluster node that…

Vinicius, 4 years ago 0 3 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, 5 years ago 1 2 min read

Tag: oracle database

How to Efficiently Export a Large List of Tables with DataPump

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

Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 3

Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 2

Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 1

Oracle RAC Database Backup: Backup Scheduling on All Nodes

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