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 »
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 »
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 »
There have been many Blogs around Pluggable Databases and very often the bloggers (and DBAs of course) are complaining that the individual pluggable databases are competing for resources since there is only one SGA, one set of Redo logs and one Undo-Tablespace.That’s true and should be taken into account whenever production databases are being consolidated into one container. But for the CPU and degree of parallelism it is possible to limit the usage or prioritize some PDBs. In addition to the already existing Resource Plans (which can be used within any pluggable database as well) Oracle introduced CDB Resource plans
Resource Management with Pluggable Database Blogbeitrag lesen »
It was in 2001 when the Oracle Open World came to Germany and a well known representative from Oracle announced Oracle9i with the exciting new features. One of those was named “Flashback Query” and in his speech he said something similar to: “with our new Flashback technology you are able to query past data no matter if it is days, weeks or even months old”. Wow that’s ambitious and it will probably open the arena for new applications. Unfortunately the reality was slightly different to the announcement: Flashback Query is relying on the undo information stored in the Undo-Segments. Let’s
Flashback Query Blogbeitrag lesen »
Beginning with Oracle Database 12c Release 1, Oracle introduces the new Oracle Home User account under Windows. But why? Unitl now, everything runs really fine without any special accounts. Those who work with Oracle databases on UNIX-like operating systems knows the clear seperation of root user and Oracle DBA (oracle). Everyone has their tasks, the DBA takes care of the database or the software installation (usually oinstall group) and only the root can make changes tot he server. On Windows this is different so far. It is difficult to design a granular assignment of rights sometimes and in doubt the
12c, Windows and the new Oracle Home User Blogbeitrag lesen »
