Re: RMAN Duplicate - Is this Possible?
Date: Tue, 31 May 2022 09:02:00 +0000 (UTC)
Message-ID: <1021257880.5069134.1653987720721_at_mail.yahoo.com>
Hi Leng,
Thanks for the confirmation that this is not going to be possible! (I had been playing with the DBMS_BACKUP_RESTORE package to try to set the DBID but got nowhere as the control file was not current).
Charlotte
On Sunday, May 29, 2022, 11:45:13 AM GMT+1, Leng <lkaing_at_gmail.com> wrote:
Hi Charlotte,
You can only create a standby from an existing db or it’s backup. U cannot create a new standby for a primary that has yet to be created in the first place. The db_name and dbid are what ties the primary and standby together.
Cheers,Leng
On 26 May 2022, at 2:14 am, Charlotte Hammond <dmarc-noreply_at_freelists.org> wrote:
Hello All,
We have a requirement to build a test Primary / Standby pair from a production backup (this is 19c EE Data Guard).
The current 2-step process goes like this:
* RMAN Duplicate Production Backup to Create New Primary* RMAN Duplicate New Primary to Create New Standby
I was hoping to speed this up to a single step by creating the new standby *concurrently* to the new primary (i.e. duplicate both from the Production backup at the same time). However, I don't think I can make this work since part of the RMAN Duplicate renames the database and changes the DBID which means the new Primary and new Standby will look like different databases even though the contents are identical.
Is there any way to achieve this?
Thanks,Charlotte
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 31 2022 - 11:02:00 CEST