BE SHARING

Standby

Considerations when backing up from the Oracle Standby Database (Data Guard) with rman to shared storage (NFS)

28.03.2023 by Clemens Bleile

To reduce load on the Primary DB in a Data Guard configuration you may decide to do your rman backups from the Standby site. A very common approach today is to use NFS as the backup location, especially when using(…)

Oracle

Handling unified auditing spillover files on the standby-site

08.01.2021 by Clemens Bleile

Switching to Oracle Unified Auditing may produce lots of data when e.g. auditing activities of the SYS-user. I.e. according the documentation you can do the following to audit similarly as in traditional auditing with audit_sys_operations=TRUE: SQL> CREATE AUDIT POLICY TOPLEVEL_ACTIONS(…)

Database Administration & Monitoring

Having multiple standby databases and cascading with dbvisit

23.10.2019 by Marc Wagner

Dbvisit standy is a disaster recovery solution that you will be able to use with Oracle standard edition. I have been working on a customer project where I had to setup a system having one primary and two standby databases.

Oracle

18c PDB switchover

11.03.2018 by Oracle Team

By Franck Pachot . In multitenant, the recovery and availability are at CDB level. But customers asked for a switchover at PDB level so Oracle has done that in 18c, based on refreshable PDBs. For this test I have two(…)

Database Administration & Monitoring

How to patch Postgres Plus Advanced Server in a Standby configuration

09.10.2016 by Daniel Westermann

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn't it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled(…)

Database Administration & Monitoring

Maintenance scenarios with EDB Failover Manager (3) – Witness node

19.04.2016 by Daniel Westermann

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance(…)

Database Administration & Monitoring

Maintenance scenarios with EDB Failover Manager (2) – Primary node

18.04.2016 by Daniel Westermann

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I'll look on how(…)

Database Administration & Monitoring

Maintenance scenarios with EDB Failover Manager (1) – Standby node

08.04.2016 by Daniel Westermann

Recently at a customer we again implemented a PostgreSQL architecture as described some time ago. When we delivered the first draft of the documentation the question popped up how to handle maintenance tasks in a failover cluster(…)

Database Administration & Monitoring

12c Multitenant: PDB spfile parameters for standby database

16.03.2016 by Oracle Team

By Franck Pachot . In multitenant, the spfile parameters at pluggable database level are not stored in the spfile but in the CDB$ROOT table SYS.PDB_SPFILE$ If you open the standby database in read only for reporting, which is one reason(…)

Technology Survey

OOW Day 1: Oracle 12c – Data Guard new features

02.10.2012 by Jérôme Witt

What a sunny day at the Oracle OpenWorld in San Francisco, temperatures over 30 degrees Celsius … don’t be jealous ;=) What should I start speaking about? Oracle Entreprise Manager Cloud Control 12c? Oracle VM or Oracle Database 12c? Well,(…)