Re: Duplicate DB
Date: Thu, 22 Mar 2018 00:58:22 +0000 (UTC)
Message-ID: <1489260630.5137337.1521680302196_at_mail.yahoo.com>
Thanks, Stefan and Niall
Sorry I didn't post the command. I actually saw the Metalink docs but didn't go thru in details and after Stefan reference check it and planned for the failure but the last attempt was successful.
Can you provide some guidance on Multitenant Architecture and the point was that if you have a 12c container DB with multiple pluggable databases? If someone accidentally overwrites some of the files of single PDB while executing Duplicate on the same server using Duplicate Target database with the different name and using convert parameter. Control file was not damaged but somehow duplicated command was issued to restore one PDB and it damaged some of the live Datafile causing Original Live container CDB crashed and then asking for recovery
Can we be able to bring the Container which crashed up with only taking one PDB down? If yes any scenario or link that can be shared. I tried to open and it failed and asking for recovery which may be that open CDB might also be like to open all PDB and need to disassociate. Oracle version is 12.1.0.2.
Thanks for your time
Sanjay
On Wednesday, March 21, 2018, 10:54:47 AM EDT, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
Sanjay
Stefan has posted the appropriate MOS note. For future reference it might have helped to include the rman commands you issued, rather than a text description.
On Wed, Mar 21, 2018 at 1:36 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:
Hi
Need some expert advice on Oracle Duplication database command. I had 20Tb multitenant database where the need to recover some old data for multiple schema and so restoring one out of 5 pluggable to new Server and is Exadata server.
Started the restore using Tape and it has to restore 2.5 Tb and failed after 500 files due to one missing Path in ASM and so added the directory and started again and saw it skipped those 500 files.
It then worked and completed the restore and then started the Recover with Archivelog and failed after few recoveries due to Shared pool error.
Restarted again but then it skipped some file but had to restore more than 300 files which even skipped in the second attempt. Is it because those might be recovered to new SCN as some recovery was done. Again it failed at the even end while creating Redolog as missing online log.
Can I use the environment at this stage without going for another Restart of Duplicate? like adding Log file manually and doing any recover or open reset logs. I can see the PDB I am looking is still shown as some UNDEFINED name
Anyway I restarted the Restore again and it is using the same controlfile backup to restore and started but this time restoring all files and didn't skipped any. SO again the question is if this comes due to Recovery completed earlier.
Please share your thought on the process for better understanding
TIA Sanjay
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 22 2018 - 01:58:22 CET