Home » RDBMS Server » Backup & Recovery » Oracle Disaster recovery query - Veritas Volume replicator and Flashsnap
Oracle Disaster recovery query - Veritas Volume replicator and Flashsnap [message #232673] Sun, 22 April 2007 22:57 Go to next message
kumarpk108
Messages: 7
Registered: December 2006
Junior Member
Hi all,
We are running Oracle 9.2.0.7 on
Solaris and the company is going
with the veritas volume replicator and
flashsnap to make a DR solution and also
a means to copy Production data to a Test system.

System people have installed VVR (veritas
volume replicator) and the changes are going
to a staging system/volume group and from there
using flashsnap a Test envrionment is being
built.

Our involvement comes in terms of DBA
actions on the database.

a)What do I have to do in terms of
bringing up oracle at the Test envrionment for
DR situation? In this case the oracle SID
will be maintained as the same as Production one.

b)Once the flashsnap synchronises all the
data files, can I login to sqlplus and
and bringup the database without any
recovery commands? Since this is DR
situation, I am assuming I do not have
to recreate the control etc? Is that correct?

c)If I have to bring the up the database
for making a copy of Production database
and need to rename the SID. What actions
should I take in terms of bringing up
of oracle?

I was told by the system team that
when VVR or flashsnap is executed
there is no "Alter tablespace Begin backup"
or "end backup" executed at all.

My doubt is:
How do I bring up the database consistently
if there is no "begin / end " backups issued?
Does this mean the way VVR/flashsnap works
automatically takes care of the Begin/End backups
and the datafiles are consistent and database
can be opened without any issues?

Please forgive my terminology on VVR / flashsnap,
I do not have any experience or exposure to them.
The system people have installed
and we are the end where we are looking after
the oracle from DBA point of view.

I would appreciate if any of you could shed some
light on the subject or point me in the correct direction.

Best Regards
Kumar
Re: Oracle Disaster recovery query - Veritas Volume replicator and Flashsnap [message #232674 is a reply to message #232673] Sun, 22 April 2007 23:05 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
Are you honestly willing to bet your company's future on postings from anonymous strangers with ZERO stake in your results?

If I were you, I'd test, test & re-test while documenting every action between taking the flashsnap & (re)opening the recovered database.
Re: Oracle Disaster recovery query - Veritas Volume replicator and Flashsnap [message #232691 is a reply to message #232674] Mon, 23 April 2007 00:53 Go to previous message
kumarpk108
Messages: 7
Registered: December 2006
Junior Member
Thanks for your answer. We are not betting our company's future. we are doing rigorous testing of the solution.
In the mean time we are trying to understand how the whole solution is implemented in other companies. I do learn many useful and valuable things from these forums. That was the reason why I posted the question here.

Regards
Previous Topic: Need help
Next Topic: recovering deleted records..!
Goto Forum:
  


Current Time: Fri Dec 02 20:37:03 CST 2016

Total time taken to generate the page: 0.09103 seconds