Solved

how to make multi volumes Consistent

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

Give your grad a cloud of their own!

With up to 8TB of storage, give your favorite graduate their own personal cloud to centralize all their photos, videos and music in one safe place. They can save, sync and share all their stuff, and automatic photo backup helps free up space on their smartphone and tablet.

Question has a verified solution.

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

How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
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…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

920 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