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@xxxxxxxxx> 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 >