clone scripts for pdb from different container
From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 21 Mar 2019 09:01:27 +1100
Message-ID: <CAFeFPA9yCHgDCyVJFOtg3_Om2TH2K0T7wH5P_fAznW_iMuQA9A_at_mail.gmail.com>
Hi All,
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
Date: Thu, 21 Mar 2019 09:01:27 +1100
Message-ID: <CAFeFPA9yCHgDCyVJFOtg3_Om2TH2K0T7wH5P_fAznW_iMuQA9A_at_mail.gmail.com>
Hi All,
Instead of reinventing the wheel I would like to ask if people have automated the the process of cloning a pdb from a standby database in an oracle RAC environment
currently we stop the log apply manually
drop the PDB we are refreshing
stop one node of the cluster
create pdb across the link from standby
start apply on standby manually
start second node
I am not very good with scripting and would spend a fair bit of time if I was to do this from scratch so if someone has a starting point that would be great
Jack van Zanen
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 20 2019 - 23:01:27 CET