Database management

12c nologging and Data Guard

By Franck Pachot . The title sounds weird because Data Guard synchronisation is based on the redo stream, so it makes no sense to do nologging operations on the primary. And this is the reason why we set FORCE LOGGING(…)

12cR2 partial PDB backup

By Franck Pachot . I had a recent question about the following mention from the 12cR2 Multitenant book, about Partial PDB backups: . Here is an example in 12.2 with local undo to illustrate the(…)

Listener and Virtual IP

By Franck Pachot . When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That's the role of Transparent Application Failover, but this requires configuration on the client side. If(…)

12cR2 RMAN> REPAIR

By Franck Pachot . Do you know the RMAN Recovery advisor? It detects the problems, and then you: RMAN> list failure; RMAN> advise failure; RMAN> repair failure; You need to have a failure detected. You can run Health Check if(…)

Data Pump LOGTIME, DUMPFILE, PARFILE, DATA_PUMP_DIR in 12c

By Franck Pachot . Data Pump is a powerful way to save data or metadata, move it, migrate, etc. Here is an example showing few new features in 12cR1 and 12cR2.

SecureFiles on multi-datafiles tablespaces

By Franck Pachot . When we have a tablespace with multiple datafiles, we are used to seeing the datafiles filled evenly, the extents being allocated in a round-robin fashion. In the old time, we used that to maximize performance, distributing(…)

SQLcl on Bash on Ubuntu on Windows

By Franck Pachot . I'm running my laptop on Windows, which may sound weird, but Linux is unfortunately not an option when you exchange Microsoft Word documents, manage your e-mails and calendar with Outlook and present with Powerpoint using dual(…)

Service “696c6f76656d756c746974656e616e74” has 1 instance(s).

By Franck Pachot . Weird title, isn't it? That was my reaction when I did my first 'lsnrctl status' in 12.2: weird service name... If you have installed 12.2 multitenant, then you have probably seen this strange service name registered(…)

12cR2 DML monitoring and Statistics Advisor

By Franck Pachot . Monitoring DML to get an idea of the activity on our tables is not new. The number of insert/delete/update/truncate since last stats gathering is tracked automatically. The statistics gathering job use it to list and prioritize(…)

12cR2 DBCA, Automatic Memory Management, and -databaseType

By Franck Pachot . This post explains the following error encountered when creating a 12.2 database with DBCA: [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB. or when creating the(…)