CarajanDB Experten-Blog

Filter posts by category

Uncategorized

Easy replication with SharePlex

shareplex migration

It was in 1999 when I first got some information about a replication tool for Oracle database. At that time I worked for a small consultancy company and had some experience with Oracle Advanced Replication because of a telecommunication project. SharePlex looked exciting and I began to dig into the features and functions and within the next years I became more and more familiar with that product. In 2002 we had a project where the customer already used Oracle standby for disaster recovery and was not satisfied because of the following problem. Even though there was a process to create […]

Easy replication with SharePlex Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Multitenant Snapshot Copy

snapshot copy

Snapshot clones are available with various techniques, like clonedb with 11.2.0.3 or the already mentioned software company Delphix. The most common ones are using storage technologies like ZFS or NetApp. Starting with Oracle 12.1.0.1 it was also possible using snapshot clones with pluggable databases within the multitenant database architecture. But it was limited to file systems that support sparseness and ACFS. With the first patch set 12.1.0.2 it’s possible to use direct NFS as well for snapshot copies. As direct NFS becomes more and more popular for database storage this is a real shift towards the usage of snapshot copies.

Multitenant Snapshot Copy Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Toad – My DBA Tool

database browser

For more than 20 years my profession is the Oracle database administration. Starting in the early 90th on DEC VMS with a VT-100 terminal I’ve worked with many different tools. SQL*Plus is of course the most important one because it’s available from the beginning and replaced sqldba and later on srvmgrl. But in 1999 I had the pleasure working with a tool which was intended to help Oracle PL/SQL developers: Tool for Oracle Application Development (T.O.A.D).

Toad – My DBA Tool Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Oracle Direct NFS configuration using Linux or Windows with 11g and 12c

Starting with Database Version 11g, Oracle offers with Direct NFS an integrated NFS-Client, which is independent from the underlying OS-based NFS-Client. This allows direct access to the NFS storage for the Oracle Instance and realizes Oracle’s own optimizations. In addition, one can implement multipathing over four parallel ports, independently from any switches, NIC bonding or teaming. The Oracle Instance configures the communication with the NFS automatically and thus facilitates the configuration under RAC. Using Oracle Direct NFS, shortly dNFS, also provides using NFS Storage with Oracle Instances on Windows systems.

Oracle Direct NFS configuration using Linux or Windows with 11g and 12c Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

Automatic Maintenance and Optimizer Statistic Collection managing with 12c and 11g

AMT 01

Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is that, with version 12c, the database comes by standard only with the Enterprise Manager Database Express 12c. With EM Express you can only get to know that Automatic Maintenance is in use or it is not (Configuration > Used database features). In the “standard” Enterprise Manager 11g the appropriate configuration option still was installed (Server > Automated Maintenance Tasks). So the only way with 12c beside Cloud Control is the command line. The following works with both 12c and 11g.

Automatic Maintenance and Optimizer Statistic Collection managing with 12c and 11g Blogbeitrag lesen »

By • • 3 minutes of reading
Oracle

Extended Data Types with VARCHAR2(32767)

JA-Blog-042514-1

In the Oracle 12 New Features Guide you will find this sentence: “The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes“ Increasing the allotted size for these data types allows users to store more information in character data types before switching to large objects (LOBs). This is especially useful for brief textual data types and the capabilities to build indexes on these types of columns.” ( Oracle® Database New Features Guide 12c Release 1 (12.1) E17906-16 Page 1-13 What great news! Especially if you want to upgrade your database to

Extended Data Types with VARCHAR2(32767) Blogbeitrag lesen »

By • • 7 minutes of reading
Uncategorized

Flashback Archive second Edition

Flashback Archive becomes more and more my top Oracle feature as it is easy to implement and has a huge advantage for all kind of applications and compliance of course. So in my blog from January 2014 I already explained the idea of flashback data archive. Some of you might found some time to test and wondering about additional features or behaviors they wouldn’t have expected.

Flashback Archive second Edition Blogbeitrag lesen »

By • • 5 minutes of reading
Uncategorized

Dbvisit Standby 7.0 the refurbished standby database solution for Oracle

01 Dbvisit Standby 7

The new version of Dbvisit Standby is released, so I will take this cause to describe the “Smart Alternative” in detail. Of course this release will bring us also new features. Now we do not only create a standby database with some clicks by minutes. With the new version we can define an exact point in time, which our standby database shall reflect. Altogether the DBA gets a simple opportunity to provide reporting and testing databases. In the next lines I will give an overview how you can create a new database composed of your existing data within 10 minutes.

Dbvisit Standby 7.0 the refurbished standby database solution for Oracle Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

Table Recovery

Very many customers are using export / import or data pump as a backup solution in case they are losing a table or some content for several years now. But as the database size increases the size of the export and more problematic the time needed for the export increases as well. Most recently one of my customers was facing the problem that the time window he specified for the ordinary backup, the export and some batches was no longer sufficient. Instead the batch run hasn’t finished when the users came back to work in the morning. So the question

Table Recovery Blogbeitrag lesen »

By • • 4 minutes of reading
Scroll to Top