Tag: Oracle
-
How to create your own Oracle database merge patch
How to create your own Oracle database merge patch A little bit scary title, isn't it? Please keep in mind that definitely it is neither supported nor advised method to solve your problems and you should be really careful while doing it – hopefully not on production environment. But it may sometimes happen that you
-
Oracle 12c – causing problem by solving it!?!
Oracle 12c – causing problem by solving it!?! Regular readers of our blog probably already know that for most of our databases we’re using two storage layers to keep our backups – NAS volumes as a primary layer and tapes as secondary one – please check “Datafile without backups – how to restore?” for more
-
Nuances of Oracle Managed Files (OMF) and RMAN
Nuances of Oracle Managed Files (OMF) and RMAN Oracle Managed Files (OMF) have many advantages, but the fact that such files could coexist in the same database with manually added (and named) ones, could sometimes lead to confusion. Situation is made worse by the fact, that there is no straightforward way (at least of which
-
Which shared memory segments belong to my database instance?
Which shared memory segments belong to my database instance? I’ve already described how important is to test your backup strategy and restore/recovery procedures, but while doing so, you could of course encounter some problems, not really related with the recoverability as such. Recently, we’ve got such a problem on our recovery server, at the very
-
Potential of “import catalog” command
Potential of “import catalog” command Since version 11.1 of Oracle database, there is very useful command available, allowing DBAs to easily move RMAN recovery catalog schemas between databases. Its functionality is even broader, as it also allows one catalog schema to be merged into another – either the whole schema or just the metadata of
-
Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization
Latest updates to PerfSheet4, a tool for Oracle AWR data mining and visualization Topic: This post is about the latest updates to PerfSheet4 v3.7 (February 2015). PerfSheet4 is a tool aimed at DBAs and Oracle performance analysts. It provides a simplified interface to extract and visualize AWR time series data using Excel pivot charts. Why
-
Datafile without backups – how to restore?
Datafile without backups – how to restore? Have you ever had a problem with restoring datafiles without any backups available? It’s easy, of course if you have all archived logs from the time datafile was created. Please check it here: Re-Creating Data Files When Backups Are Unavailable. Moreover, RMAN is clever enough to create empty
-
Importance of testing yours backup strategy
Importance of testing yours backup strategy Most of you for sure know, that ability to restore data in case of failure is a primary skill for each DBA. You should always be able to restore and recover data you’re responsible for. This is an axiom. To be sure, that you’re able to do it, you
-
Backups in Data Guard environment
Backups in Data Guard environment Physical standby databases seem to be ideal candidates for offloading backups from primary ones. Instead of "wasting" resources (unless you're already using Active Data Guard for example), you could avoid affecting primary performance while backing up your database, especially if your storage is under heavy load even during normal (user-
-
GoldenGate Veridata for Data Consistency in WLCG Distributed Database Environment
GoldenGate Veridata for Data Consistency in WLCG Distributed Database Environment Reaching the end of my internship as an Openlab student at CERN, I think it’s appropriate to write a summary of my project in our blog. I will try to give a good overview for the past weeks. Our department provides replication services between CERN