Re: Duplicating from copy of a standby with standby controlfile

You can always go back to a basic restore instead of rman duplicate.  Restore the controlfile, catalog the remounted disk of the copy, switch and recover.

You may then need update the dbid, name and other config if need be. It will still let you use the backup as copy method and save some time.

Can be scripted.

Regards,

-- 
Stojan
www.stojanveselinovski.com/blog





On Tue, Feb 11, 2014 at 8:38 AM, Don Seiler <don_at_seiler.us> wrote:



> OK I've played a little more with the duplicate steps (using target-less

> duplication with BACKUP LOCATION specification) and so far it seems to only

> work with backups, not with datafile copies. I'd like to keep using the

> datafile copy method as it saves time, and our database is nearly 25Tb.

> Creating a "backup as copy" of the database and remounting the disks saves

> us from having to backup and then restore the datafiles which would take

> far too much time.

>

> Like I said, this method works great but so far requires a primary

> controlfile. It's really only an extra step when we do the refresh from the

> standby side but I'd like to see if we can do it without having to do that

> step, just to simplify and script as much as possible.

>

>

> On Sat, Feb 8, 2014 at 1:46 PM, Don Seiler <don_at_seiler.us> wrote:

>

>> Version is 11.2.0.3. I'll explore the duplicate options. Anyone done it

>> with data file copies target than backup set? I'd rather not do active our

>> require connection to primary or standby other than the initial backup as

>> copy.

>>

>> Thanks again.

>> On Feb 8, 2014 1:37 PM, "Niall Litchfield" <niall.litchfield_at_gmail.com>

>> wrote:

>>

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

>>>>

>>>

>

>

> --

> Don Seiler

> http://www.seiler.us

>


--
http://www.freelists.org/webpage/oracle-l