Infrastructure at your Service

Data Guard Archives - Page 2 of 3 - Blog dbi services

Mouhamadou Diaw

Dataguard Oracle 12.2 : Support for Multiple Observers

By | Database Administration & Monitoring | One Comment

With Oracle 12cR2 it is now possible to configure multiple observers within a single Oracle Data Guard broker configuration. Multiple observers provide an immediate benefit for High Availability. If one observer fails, there are additional observers that can continue to monitor the status of the configuration. In this blog we are going to talk about this new feature. Our configuration have 3 servers: primaserver.localdomain with db_unique_name ORCL_SITE standserver1.localdomain with db_unique_name ORCL_SITE1 standserver2.localdomain with db_unique_name ORCL_SITE2…

 
Read More
Oracle Team

Oracle 12cR2 – DataGuard Switchover with Oracle Wallets

By | Database Administration & Monitoring, Database management | No Comments

I would like to make my DataGuard environment more secure, by eliminating the typing of “connect sys/Manager1″ for my DGMGRL commands. Especially the ones, that I have in my scripts. For example: oracle@dbidg01:/home/oracle/ [DBIT122] dgmgrl <<-EOF > connect sys/Manager1 > show configuration verbose; > EOF or something like that: oracle@dbidg01:/u01/app/oracle/local/dg/ [DBIT122] cat show_config.dg connect sys/Manager1; show configuration; oracle@dbidg01:/u01/app/oracle/local/dg/ [DBIT122] dgmgrl @show_config.dg DGMGRL for Linux: Release 12.2.0.1.0 – Production on Wed Jan 4 12:54:11 2017 Copyright…

 
Read More
Franck Pachot

SYS password on Oracle Cloud Service managed database

By | Database Administration & Monitoring | No Comments

When you create a DBaaS on the Oracle Cloud services you have to provide an administration password in the database configuration form. You do not need a password to connect to the VM. You use SSH key for it: on creation you provide the public key that will allow you to connect as the oracle user or the opc user (which can ‘sudo su’). But for the database you need to provide a password which…

 
Read More
Franck Pachot

Franck Pachot: OCM 12c preparation: Data Guard with OEM

By | Database Administration & Monitoring | One Comment

I never create a Data Guard configuration from Enterprise Manager. It’s not that I don’t like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually I write the commands in the documentation and then copy to execute them so that I’m sure about the documentation). But for OCM 12c preparation, I want to be sure I can do it from OEM as it can…

 
Read More
Franck Pachot

Franck Pachot: SQL> alter database switchover to …

By | Database Administration & Monitoring, Oracle | One Comment

In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I wanted to see if the broker uses that new command or not. Let’s compare the alert.log for both manual and broker switchover. One simple command I have the broker configured, but try a manual switchover with that simple command: SQL>…

 
Read More
Franck Pachot

Franck Pachot: set state=apply-off and datafile consistency

By | Database Administration & Monitoring, Oracle | One Comment

In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a consistent state? We know the answer, but want to prove it. This is the kind of question you may have, as I did last Friday morning in the train with Ludovico Caldara when going to the Paris Oracle Meetup….

 
Read More
Franck Pachot

Franck Pachot: DataGuard broker properties – Part I: imported parameters

By | Database Administration & Monitoring, Oracle | One Comment

When you are using the DataGuard Broker, you should always use the broker (with DGMGRL or OEM) to change the parameters that are managed, rather than changing them with ALTER SYSTEM. But do you know which parameters are concerned? I’ve divided the parameters in two parts. All are set by the broker, but only some of them are read when you add a new database to the configuration.  

 
Read More