Database Administration & Monitoring OCM 12c preparation: restore Voting disks, OCR and ASM spfile 21.12.2015 by Oracle Team By Franck Pachot . As in the previous posts, here are a few commands I used to check that I know how to restore the cluster mandatory files in 12c. It's what I'm doing while preparing the OCM 12c exam,(…)
Database Administration & Monitoring OCM 12c preparation: RAT in multitenant 20.12.2015 by Oracle Team By Franck Pachot . I have several customers that have cases where Real Application Testing can be interesting, but they don't use it because it's an expensive option. Which is why it's probably the topic listed for OCM 12c exam(…)
Database Administration & Monitoring OCM 12c preparation: Data Guard with OEM 18.12.2015 by Oracle Team 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(…)
Database Administration & Monitoring OCM 12c preparation: Explain fast refresh 17.12.2015 by Oracle Team By Franck Pachot . There are some rules to be able to fast refresh a materialized view (which means, refresh it so that it is not stale, and without running the whole query). Documentation is in the Datawarehouse Guide, but(…)
Database Administration & Monitoring, Oracle OCM 12c preparation: Manage PDB 30.11.2015 by Oracle Team By Franck Pachot . Let’s see the different ways to create a PDB, with different tools. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what you(…)
Database Administration & Monitoring, Oracle OCM 12c preparation: Create CDB in command line 30.11.2015 by Oracle Team By Franck Pachot . This post starts a series about things I wrote while preparing the OCM 12c upgrade exam. Everything in those posts are written before taking the exam - so don't expect any clue about the exam here.