Solved

how to make multi volumes Consistent

Posted on 2009-05-07
5
372 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_
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 22

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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

How to fix error ""Failed to validate the vCentre certificate. Either install or verify the certificate by using the vSphere Data Protection Configuration utility" when you are trying to connect to VDP instance from Vcenter.
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 the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

688 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