Solved

how to make multi volumes Consistent

Posted on 2009-05-07
5
358 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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Run test on Flash Drive 2 TB 5 108
Deep Freeze 2 73
Robocopy Question 5 65
VMware - Cluster of VM and physical server 7 83
Problem We are doing a daily copy of data in file system in Linux manually and I want to automate the same . We need many features in this automation:    1. We want to be able to exit in case of errors    2. We want the copy to happen via …
Replication has always been one of those technologies that people run scared from. The main reason is usually cost. When you think of replication, your mind drifts to solutions that replicate from one disk frame to another using block level technolo…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now