Re: RMAN duplicate RAC to single instance - how to not duplicate redo threads and temp tablespace
From: kathryn axelrod <kat.axe_at_gmail.com>
Date: Thu, 29 Mar 2012 23:47:25 -0700
Message-ID: <CAEbHM4797YucEzwca+4L3qmgDBqng9Dkf4cZ_Hwq=R7u4MpV6Q_at_mail.gmail.com>
Hi,
Date: Thu, 29 Mar 2012 23:47:25 -0700
Message-ID: <CAEbHM4797YucEzwca+4L3qmgDBqng9Dkf4cZ_Hwq=R7u4MpV6Q_at_mail.gmail.com>
Hi,
If you are duplicating it to a set time/sequence number such that all post-backup-data would be from archivelogs and it would do an open resetlogs, does this work:
duplicate database PROD to TEST pfile='pfile.TEST' backup
location='/backup/PROD' LOGFILE GROUP 1 ('+DATA_TEST','+DATA_TEST')
SIZE 1000M, GROUP 2 ('+DATA_TEST','+DATA_TEST') SIZE 1000M;
On Thu, Mar 29, 2012 at 5:20 PM, neil campbell
<campbell.neil_at_hotmail.com> wrote:
>
>
>...
>
> I am using the syntax
>
> duplicate database PROD to TEST pfile='pfile.TEST' backup location='/backup/PROD' LOGFILE INSTANCE 'TEST1' GROUP 1 ('+DATA_TEST','+DATA_TEST') SIZE 1000M, INSTANCE 'TEST2' GROUP 2 ('+DATA_TEST','+DATA_TEST') SIZE 1000M;
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 30 2012 - 01:47:25 CDT