• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

how to make multi volumes Consistent

How to make Oracle volumes(data, logfiles, control files)Consistent  to take a snapshot.
0
Ocean_
Asked:
Ocean_
  • 3
1 Solution
 
0renCommented:
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
 
0renCommented:
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
 
Ocean_Author Commented:
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
 
0renCommented:
i think thats a question for dba
0
 
robocatCommented:


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

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now