Upgrading sn Migrating

 Study the Mike Dietricht’s blog, with a lot of videos, in particular Zero Downtime Migration tool (ZDM). :

https://mikedietrichde.com/

Itinerary to Data Scientist

This is the list of certifications I have followed on the path from DBA to data scientist:

Oracle Cloud Infrastructure 2021 Certified Architect Professional (1Z0-997-21)

Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)

Oracle Cloud Database Migration and Integration Specialist (1Z0-1094–21)

Oracle Autonomous Database 2021 Specialist (1Z0-931-21)

Oracle Machine Learning using Autonomous Database 2021 Specialist (1Z0-1096-21)

Oracle Cloud Infrastructure Security 2021 Associate (1Z0-1104-21)

Oracle Cloud Platform Application Integration 2021 Specialist (1Z0-1042-21)

Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21) 1Z0-1042-21)

Oracle Cloud Infrastructure 2021 Certified Architect Professional (1Z0-997-21)

Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)

Oracle Cloud Database Migration and Integration Specialist (1Z0-1094–21)

Oracle Autonomous Database 2021 Specialist (1Z0-931-21)

Oracle Machine Learning using Autonomous Database 2021 Specialist (1Z0-1096-21)

Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21)

Oracle Clourd Infrastructure 2021 Certified Architect Professional (1Z0-997-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=B210042D42359D33CB260E79DAE54808650FA4901D32CA89E7D8EEC3940EC3FA

Oracle Cloud Platform Application Integration 2021 Specialist (1Z0-1042-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=3F7FF037F3DBCFDE13DFB8E87735A396565AFC12F79E19B705F0EA58FEC274C2

————————————-

Oracle Cloud Infrastructure Security 2021 Associate (1Z0-1104-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=FA5557BF6EFD2F7F15FBB5FAF2B4791D20CD9A381CC22F24799B5264A76F4BA5

Oracle Cloud Database Services 2021 Certified Specialist (1Z0-1093-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=815B21E3AA29FB32D3E58748E12AC11010285923C28E3A328F8F1ED367B7E366

Oracle Cloud Database Migration and Integration Specialist (1Z0-1094–21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=BF1401EFB019FFFB05BDFB6C9E269997CC73995D4A29A2C07C30925F5F21F9C9

Oracle Autonomous Database 2021 Specialist (1Z0-931-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=E531555B94E028BC9D21327CBD99BC0AE9393A521CCD6E82E516AA8F8A4DECFB

Oracle Machine Learning using Autonomous Database 2021 Specialist (1Z0-1096-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=51995BB3D53949C1BBED2525FBDC5498E42AB63A76211AEC598D7DFA9769C380

Oracle Cloud Infrastructure 2021 Certified Architect Associate (1Z0-1072-21)

https://catalog-education.oracle.com/pls/certview/sharebadge?id=A0B291E7CBA58AB58A3DDCC627ED321D88B16F38B19C01D56995387ACD85C361

How to create a Data Guard Broker Configuration in Oracle 19c

 Here an article from my colleague Fernando:

https://rootfan.com/data-guard-broker-configuration-oracle-19c/#more-1677

And just another useful one, in a virtualized environment:

https://oracledbwr.com/step-by-step-guide-to-install-oracle-19c-rac-installation-using-virtualbox/

Oracle Clusterware 19C

Official documentation, all you need to know about all the architectures and possibilities of Oracle Clusterware 19C.

Here you will find Fleet Patching and Provisioning.

https://docs.oracle.com/en/database/oracle/oracle-database/19/cwadd/clusterware-administration-and-deployment-guide.pdf

DATAGUARD 19C

Official documentation, all you need to know about all the architectures and possibilities of Oracle Dataguard 19C.

https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/data-guard-concepts-and-administration.pdf

Fleet Patching and Provisioning commands

Formerly “Rapid Home Provisioning (RHP)”, thats the reason for the command rhpctl.

This artefact consists of a server connected to an ACFS where clusterware and RDBMS binaries are stored for distribution and installation on client nodes.

The following is a summary of the main commands that will help us install and update the software

srvctl start rhpserver

srvctl add rhpserver -storage /// -diskgroup xxx

rhpctl import image… -imagetype -path

rhpctl add image -image abc -workingcopy abcwc

rhpctl add workingcopy -workingcopy WC1 -image iii -storagetype LOCAL -path /ora19

rhpctl upgrade gihome -sourcewc aa -destwc bb

rhpctl upgrade database

rhpctl zdtupgrade database…

rhpctl addpdb database…

rhpctl deletepdb database…

Bynaries:rhpctl add workingcopy -image db19 -path /u01…. -client xxx -oraclebase /u01.. - workingcopy w1

RDBMS:rhpctl add database -workingcopy w1 -dbname db - node a,b -dbtype RAC- datafiledestination xx_DG

rhpctl move database -sourcewc a -patchedwc a_psu