All articles

Dbvisit replicate when you flashback the target

By Franck Pachot . I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is(…)

12c online move datafile in same filesystem.

By Franck Pachot . On Linux, when you move a datafile, with "mv" within the filesystem it's just a rename. There is no copy. In 12c you can move a datafile online where oracle takes care of the move at(…)

Momentum16 – Day 2 – C6, Load Testing and REST API

So today is the second day of the Momentum 16 in Barcelona and as expected, this day contained many more technical presentations and discussions than the first day. I attended several interesting presentations and hackathon/hands on sessions as well so(…)

Momentum16 – Day 2 – What’s new in Documentum 7.3 ?

As described in my last post related to Momentum 16, I was excited to see the session “What’s new in Documentum 7.3”. Do not worry, I could slept last night. But are my expectations fulfilled?   So yesterday I wrote(…)

Documentum story – Documentum JMS Log Configuration

The aim of this blog is to provide you a way to configure the JMS Logs in order to align all applications logging with date information, log rotation and retention. Some changes have to be done on the jboss container(…)

SQL Server 2016 – R Services Tips: How to find installed packages using T-SQL?

If you have restricted access to the server and you do not know if your packages are installed on the SQL Server with the R Services, you have the possibility to do it by T-SQL. The R command/function to(…)

SQL Server 2016: New useful function STRING_SPLIT()

Now, in the latest version of SQL Server, you have one of the most expected function as well as for developers as for administrators, splitting a string natively in T-SQL: STRING_SPLIT(<character expression>,<separator>) This function has 2 parameters: The(…)

Oracle 12c – Difference between ‘%F’ #default and ‘%F’

By William Sescu Do you see any differences between these two RMAN SHOW commands? RMAN> SHOW CONTROLFILE AUTOBACKUP FORMAT; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default(…)

Oracle 12c – Automatic Control File Backups

By William Sescu By default, automatic control file backups are disabled (even with 12c), maybe for performance reasons. RMAN> SHOW CONTROLFILE AUTOBACKUP; RMAN configuration parameters for database with db_unique_name OCM121 are: CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default And also good(…)

Oracle 12c – When the RMAN Dummy Instance does not start up …

By William Sescu Not too often, but sometimes you might run into a situation when you lose everything, your DB Files, your Controlfiles and even your spfile. In situations like that, you need to restore first your spfile, then your(…)