Solved

how to make multi volumes Consistent

Posted on 2009-05-07
5
367 Views
Last Modified: 2012-05-06
How to make Oracle volumes(data, logfiles, control files)Consistent  to take a snapshot.
0
Comment
Question by:Ocean_
  • 3
5 Comments
 
LVL 5

Expert Comment

by:0ren
ID: 24328265
if you need to take snapshots while the database is running you should use a snapmanger for oracle .
i think its not free.
for a cold backup you should take the database down using your dbshut script.
0
 
LVL 5

Expert Comment

by:0ren
ID: 24328283
on the oracle server you can create a script which take down the database
running ssh to the storage and take a snapshot
start the datatbase.

BTW what storage do you have ?
i assumed its netapp because of the term snapshot
0
 

Author Comment

by:Ocean_
ID: 24329974
Actually snapmanager doesn't support our environment. We are using IBM vio's on  p6 595 servers. We dont want to shutdown our database during snapshoting. we are using netapp storage. is there any script  that we can run in hotback mode, which can quience  the database during snapshot.
0
 
LVL 5

Expert Comment

by:0ren
ID: 24329991
i think thats a question for dba
0
 
LVL 21

Accepted Solution

by:
robocat earned 125 total points
ID: 24331030


You can simply put the database in hot backup mode and snapshot all volumes sequentially. Lots of example scripts are available on the netapp website.

E.g. example scripts for Unix/Oracle:

http://media.netapp.com/documents/tr-3130.pdf

0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question