Unsolved
This post is more than 5 years old
2 Intern
•
643 Posts
0
1077
October 18th, 2012 23:00
Snap/Clone off of an Oracle Dataguard Standby?
A question about Snap/Clone off of an Oracle Dataguard Standby:
VNX Customer has a single standby Data Guard node. They would like to generate snaps and clones from this standby.
My understanding is that Replication Manager might not work as a Data Guard standby is always in recovery mode and not in normal “open” mode.
The ASM group is spread across 6 VNX 5300 arrays. The customer understands that the snap/clone timing will not be perfectly in sync when the snap/clone occurs on each unique array. All functions are to be controlled and coordinated via EMC Replication Manager. Can RM achieve consistency across multiple VNX's?
Are there steps (e.g. turning Data Guard off?) that need to be done in order to accomplish what the customer is asking for from us?
zhaos2
2 Intern
•
643 Posts
0
October 21st, 2012 19:00
Answer from Oracle Specialist community:
Ideally the customer should re-org the standby onto one VNX. And with ASM this should be relatively easy to do, if they have the capacity.
Yes, RM is not going to work. But in a parallel thread that has developed, see attached, shutting down the standby database has been suggested before creating the clones of the underlying LUNs.
Maybe something like this will work:
"Alter database recover managed standby database cancel" and "shutdown immediate" on the standby before the clones or snap of the standby.
And then "startup mount" and "alter database recover managed standby database disconnect" on the standby after the clones.
On the clone issue "startup" and then "alter database activate standby database" and "alter database open"
zhaos2
2 Intern
•
643 Posts
0
October 21st, 2012 19:00
Answer from Oracle Specialist community:
You said the database is using ASM and is spread over 6 LUNs on different VNX arrays. RM is not able to create consistent clones across VNX arrays, as far as I know and this was not possible in the past.
The way you might get this to work is after the below:
"Alter database recover managed standby database cancel" and "alter database open" on the standby
issue "alter database begin backup" then create the clone/snap and issue "alter database end backup" after the clone is created.
The rest should be the same except on the clone you may have to issue "alter database end backup" or need to do database recovery on the clone.