clone – Oracle Adventures

Rolling Database Upgrade from 19.3.0.0 to 19.11.0.0 Using Transient Logical Standby

Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database. Approaches: There are several methods which can be used: Manually from command line Manually using phsyru.sh script which is available since 11g (Doc ID 949322.1) Use DBMS_ROLLING package which is available since 12.1.0.1 (Doc ID 2086512.1) Note: for both manual…

22/06/2021mardaffOracleclone, DBMS_ROLLING, goldimage, Logical Standby, phsyru.sh, Transient

How to clone ORACLE_HOME in 19c

I find that’s a good idea to have a different ORACLE_HOME when it comes to patching or maybe you want to have the same oracle home setup in a lower environment than PROD. The cloning comes in very handy rather doing the whole installation (including whatever patches have been deployed in the past) again. One…

16/06/2021mardaff1 CommentOracleclone, clone.pl, createGoldImage, golden image

How to clone a schema using different name at destination

Recently I had to make a clone of a schema and to move it from production to development using a different name at destination. First grab all the information you need: select username,default_tablespace from dba_users where username like ‘&USERNAME’; # Now get the tablespace name from the previous statement and get the datafiles below: select…

10/11/2015mardaffImport&Exportclone, different, expdp, impdp