Data Guard

ODA X6 database classes and shapes

By Franck Pachot . On the Oracle Database Appliance, like on the Oracle public Cloud, you define the CPU capacity with ‘shapes’. On the latest ODA, the X6, we have a new interface to provision a database. Let’s look(…)

DB_FLASHBACK_RETENTION_TARGET may hang your database

By Franck Pachot . DB_FLASHBACK_RETENTION_TARGET is set to keep enough flashback logs to be able to flashback database within the specified retention window. But it's supposed to be a target only, meaning that on space pressure some files can be(…)

SYS password on Oracle Cloud Service managed database

By Franck Pachot . When you create a DBaaS on the Oracle Cloud services you have to provide an administration password in the database configuration form. You do not need a password to connect to the VM. You use SSH(…)

Data Guard as a Service

By Franck Pachot . A 'Data Guard' checkbox is available for a long time on the Oracle Public Cloud Database as a Service, but it's only for a few days that it does something: create a service with an database(…)

Cloning a PDB to the Oracle Cloud Service

By Franck Pachot . When you create a DBaaS on the Oracle Cloud Service you have only one way to access to your database: ssh with the public rsa key you provide. Then you can open some ports to access(…)

12c Multitenant: PDB spfile parameters for standby database

By Franck Pachot . In multitenant, the spfile parameters at pluggable database level are not stored in the spfile but in the CDB$ROOT table SYS.PDB_SPFILE$ If you open the standby database in read only for reporting, which is one reason(…)

PDB snapshot copy for continuous integration testing

By Franck Pachot . How do you manage your continuous integration tests on the database? You need to restart at the same state for probably a hundred of tests. Recreating the schema and test data takes too long. Oracle is(…)

OCM 12c preparation: Data Guard with OEM

By Franck Pachot . I never create a Data Guard configuration from Enterprise Manager. It's not that I don't like GUI, but it is a lot easier to document it when doing from command line: copy paste the commands (actually(…)

OCM 12c preparation: documentation

By Franck Pachot . The OCM exam advice says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. I've checked that I can find quickly the documentation related with each topic listed. Here(…)

SQL> alter database switchover to …

By Franck Pachot . In 12c the manual switchover to physical standby requires only one command (ALTER DATABASE SWITCHOVER) instead of two (ALTER DATABASE COMMIT TO SWITCHOVER on each database). We usually recommend to use the broker and I(…)