Search

Top 60 Oracle Blogs

Recent comments

Standby

18c PDB switchover

In multitenant, the recovery and availability are at CDB level. But customers asked for a switchover at PDB level so Oracle has done that in 18c, based on refreshable PDBs.

For this test I have two multitenant database on an Oracle Cloud service in 18c: CDB1 and CDB2. The only special thing I did was disable the mandatory TDE encryption, because I was not able to have the switchover working. With TDE encryption, I got the “ORA-46697: Keystore password required”. But there is no ‘keystore identified by’ option in the ‘alter pluggable database’. Then If you came upon this post from a search on this error, I’ve no solution yet (SR 3-17001228251 opened on the Oracle Cloud Support – see update at the end of the post when solved).

Delete Archived Logs from Standby

This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system.  (Specifically, a RAC/thread aware script.)

There are a few scripts published:

Delete Archived Logs from Standby

This is a little surprising to me because it’s so simple – but I couldn’t find a script anywhere on oracle support or on the internet which elegantly (IMHO) cleaned up archived logs on a standby system.  (Specifically, a RAC/thread aware script.)

There are a few scripts published:

Dbvisit Reporting…

I try to stick close to core Oracle technologies and steer clear of product endorsements, but over the years I’ve bumped into the ladies and gents from Dbvisit a number of times and they have been consistently cool and consistently on the money with their products. At Oracle OpenWorld 2012 I bumped into Arjen Visser who told me about their new product called Dbvisit Reporting, so I asked him to keep nagging me until I tried it out. When we met at UKOUG 2012 I still hadn’t tried it, but he had been too polite to bug me about it. This weekend it made it to the top of my list. :)