There are many things that Microsoft do not put on the 'support statement' for their products, the technical ability and capability is frequently different from this.
I understand that Microsoft will not provide support on Oracle or any generic data source because they did not make the generic APP, nor does Microsoft have a support agreement or intend to have a support agreement with Oracle or other third parties so they
can follow through on support.
That is understood.
What we want is what was quoted as 'creating and XML file' for a custom application with a VSS writer, we want that documentation on the creation, placement and registration of that XML file with some examples.
The XML file is supposed to, and I quote
Allows basic protection/recovery support of any referential data source
Supports Full Application Backup (Express Full, Delta Replication and Consistency Check) for any application
Supports Original location recovery & Restore as Files to a network location
Capability to use Xml to support applications which do not have a VSS writer
I understand that any custom app that we create an XML file is unsupported, but last I checked on the technet
http://technet.microsoft.com/library/hh758173.aspx there was no documentation on this feature - at all - and this is considering it was a major feature that was advertised repeatedly in the lead
up to release, and all but
To be clear Wicresoft/Microsoft - I'm asking for DPM 2012 feature support/documentation, not 3rd party product support.
After a bit of looking around I finally found in the teched SIM341 video @ 47:23
http://channel9.msdn.com/Events/TechEd/NorthAmerica/2011/SIM341 the VSS register command for generic data sources which is
Set-DPMGlobalProperty -RegisteredWriters @('VSSWriterID') -DPMservername DPMServerName
I've successfully registered a test Oracle DB in our environment, and can see it and the DPM protection group data source now after using the below doc to register a Test DB SID with the Oracle VSS writer in addition to the PS command above.
http://docs.oracle.com/cd/B28359_01/win.111/b32010/vss.htm
After getting all that done I appear to have done a successful backup of our little test Oracle database using DPM2012 with the RC...I'm currently downloading the RTM, but it shouldn't be any different.
It's fairly painless to get going with 11gr2 fejesjoco<abbr class="affil"></abbr>, see how you go.
In short for Oracle DB in a very very quick test which I'll need to get verified by my Oracle DBA colleague.
- Install VSS writer into the desired SID ie. C:\>oravssw TESTDB /i /user:.\oracle /password:********
- use C:\>vssadmin list writers
- copy the writer ID listed against your SID
- Set-DPMGlobalProperty -RegisteredWriters @('VSSWriterID') -DPMservername DPMServerName
- Create a protection group, select the Oracle VSS Writer - SID and the object under it
- Watch Microsoft backup an Oracle product with a grin on your face
When you do a restore for the source I can see the following items:
- All tablespaces (with granular DBF restore)
- Control File
- Flash Recovery Area
- Server Parameter File
Wicresoft/Microsoft, please get on to the product team and hastle them for documentation.
I'm going to play with the RTM tomorrow, I should get the same results. I'll put another post otherwise with any notes from my Ora DBA colleague.
Regards,
David
-
Proposed as answer by
Bob Scratchit
Wednesday, February 06, 2013 11:43 AM