Re: Duplicating from copy of a standby with standby controlfile
Date: Sat, 8 Feb 2014 19:37:51 +0000
Message-ID: <CABe10sZDe80ER6MWqVb1=K-b=jfHid_=zGok09c83nG5AvqnzA_at_mail.gmail.com>
With the right version (11.2.0.2 with a patch or 11.2.0.3) then you can run active duplicate from a standby db.
On Feb 7, 2014 9:54 PM, "Don Seiler" <don_at_seiler.us> wrote:
> Good afternoon everyone.
>
> Trying to work through a process where I can make a copy of our prod
> standby (plus archivelogs) and have it stand up as a new dev database. We
> have the process working but only when we use a backup controlfile from the
> primary. I know this is nothing new but thought by 11.2 we'd have some way
> to make this work.
>
> I did get it to work but only when the standby redo logs were also preset
> for the new instance. Then I could run the "activate standby database"
> which does a standby crash recovery and then I can open it.
>
> Anyone know offhand if there is a way around that so that?
>
> This is basically the process:
>
> 1. backup as copy database include current controlfile
> 2. backup as copy archivelogs
> 3. Remount NFS share to dev box.
> 4. Update dev pfile to point to controlfile copy on nfs share
> 5. Startup mount
> 6. Catalog datafiles on nfs share and switch to copy
> 7. Catalog archivelogs on nfs share and recover database
> 8. open resetlogs
>
> With the standby controlfile I'd have to first activate it before I could
> open it in step 8. Again that requires having the standby redo logs there
> and I don't think it would be valuable to copy those without stopping
> standby recovery which I don't want to do.
>
> I was hoping with the archivelog recovery done in step 7 that the new
> database would have all of the recovery it needs to allow me to open.
>
> --
> Don Seiler
> http://www.seiler.us
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 08 2014 - 20:37:51 CET