Infrastructure at your Service

Tag

Oracle 12.2 Archives - Page 2 of 3 - Blog dbi services

Mouhamadou Diaw

Oracle 12.2 Dataguard : PDB Flashback on the Primary

By | Database Administration & Monitoring | No Comments

The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle 12.2 is used. DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 35 seconds ago) DGMGRL> The primary database has the…

Read More
Mouhamadou Diaw

Dataguard: QUIZZ on Snapshot Standby

By | Database Administration & Monitoring | One Comment

In oracle documentation we can find this about snapshot standby: A snapshot standby database is a fully updatable standby database that provides disaster recovery and data protection benefits that are similar to those of a physical standby database. The concept of snapshot standby is that we can temporary convert a physical standby to an updatable database for different purposes and then convert back to a physical standby. During the time that the database is a…

Read More
Mouhamadou Diaw

Grid Infrastructure 12.2: Are all Redhat 7 kernels compatible?

By | Database Administration & Monitoring | No Comments

In this blog I am going to share an issue I had when installing grid infrastructure 12.2 on Redhat 7.3. I was configuring grid infrastructure 12.2 for a standlone server. Below the release and the version of my operating system [email protected] /etc $ cat redhat-release Red Hat Enterprise Linux Server release 7.3 (Maipo) [email protected] ~ $ uname -a Linux dbserver 3.10.0-514.21.2.el7.x86_64 #1 SMP Sun May 28 17:08:21 EDT 2017 x86_64 x86_64 x86_64 GNU/Linux [email protected] ~…

Read More
Oracle Team

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up

By | Database Administration & Monitoring | No Comments

By William Sescu My blog about listener rotation caused some discussion, which is great. 🙂 It sounds like an easy stuff, but in case of listener logging it isn’t. https://blog.dbi-services.com/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What happens when the log file reaches 4G? What are the performance implications? What happens if I move the listener.log while…

Read More
Oracle Team

Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8

By | Database Administration & Monitoring | 7 Comments

By William Sescu Nowadays, since the cloud is becoming more and more important, the PL/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, which is still available even with Oracle 12.2, or you can use DBMS_DATAPUMP. The Data Pump API is quite good…

Read More
Oracle Team

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF)

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

By William Sescu The listener log file contains a lot of very useful information, like the program which was used for the connection, the IP address where the connection is coming from, the OS user which was used on the client  and many many more. 05-JUN-2017 12:36:19 * service_update * DBIT122 * 0 05-JUN-2017 12:36:19 * (CONNECT_DATA=(SERVICE_NAME=DBIT122_SITE1_DGMGRL)(UR=A)(CID=([email protected])(HOST=dbidg01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=42619)) * establish * DBIT122_SITE1_DGMGRL * 0 05-JUN-2017 12:36:19 * (CONNECT_DATA=(SERVICE_NAME=DBIT122_SITE1_DGMGRL)(UR=A)(CID=([email protected])(HOST=dbidg01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=42620)) * establish * DBIT122_SITE1_DGMGRL…

Read More
Mouhamadou Diaw

Upgrade to Oracle 12.2 with dbupgrade utility

By | Database Administration & Monitoring | 6 Comments

Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility. Of course the dbua tool is still available and can be also used. Oracle Database 12.1 introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple…

Read More
Oracle Team

Oracle 12cR2 – DataGuard and Backups to NFS

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

By William Sescu From the RMAN point of view, you have generally two possibilities to store your backups, on Disk or on Tape. In case of a single instance, it doesn’t really matter from the accessible or inaccessible point of view. However, in a DataGuard environment it makes a huge difference. Per default, backups to Tape are always accessible and backups to disk always inaccessible. But what do you do in case you backup to…

Read More
Mouhamadou Diaw

Dataguard Oracle 12.2 : Support for Multiple Observers

By | Database Administration & Monitoring | 4 Comments

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