- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Restoring database files, using mirroed disk.....
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 07:31 PM
тАО07-07-2002 07:31 PM
One of the database-datafile was deleted by mistake.
I've the backup of the databaes.
But I want to restore it from the mirrored disk, all the disks in system are mirrored.
How to do it?
Please help me to get it done.
Thanks in Adv
Regards
Shah
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 07:34 PM
тАО07-07-2002 07:34 PM
Re: Restoring database files, using mirroed disk...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 07:45 PM
тАО07-07-2002 07:45 PM
Re: Restoring database files, using mirroed disk...
Ok, that means, the only use of mirrored disks is when the master disk get crashed.
Can we see the mirroed-disk configuration?
What is the state of second disk (mirroed one) ?
If the master disk or the current disk, get crashed, how to activate the mirroed disk?
please ...
Thanks & Regards
Shah
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 08:45 PM
тАО07-07-2002 08:45 PM
Re: Restoring database files, using mirroed disk...
vgdisplay -v /dev/vg00
you can boot the mirrored disk
by rebooting the server.
interrupting the boot process.
boot from the mirrored disk.
Also you can use the setboot
command to set to boot from the mirrored disk.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 08:59 PM
тАО07-07-2002 08:59 PM
Re: Restoring database files, using mirroed disk...
1) If a database datafile on a mirrored filesystem was deleted by mistake, you won't be able to restore it from the mirrored disk simply because all changes (including the deletion) are synchronized with the mirrors. In this case, your only choice is to restore from offline backup tapes.
On the other hand, if a harddisk containing one of your mirrors had crashed, you have the harddisk replaced and you want to resynchronize the mirrors, you will need to use vgcfgrestore and vgsync to synchronize the mirror extents.
Check out the step-by-step HP technical document for restoring your data on a replaced harddisk:
http://support2.itrc.hp.com/service/ciss/doLogin.do?TargetPage=http://support2.itrc.hp.com/service/cki/docDisplay.do?docId=200000058036738
Hope this helps. Regards.
Steven Sim Kok Leong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 09:04 PM
тАО07-07-2002 09:04 PM
Re: Restoring database files, using mirroed disk...
>> If the master disk or the current disk, get crashed, how to activate the mirroed disk?
If one of the disks in your mirrored set crashes, your data will continue to be available via the other working disk in the mirror set. There is no need to manually activate the mirrored disk i.e. it is automatically used.
The manual effort needed is with resynchronizing the data on the mirrored disk to the new harddisk replacing the faulty one.
Hope this helps. Regards.
Steven Sim Kok Leong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 09:04 PM
тАО07-07-2002 09:04 PM
Re: Restoring database files, using mirroed disk...
The vast majority of reasons to restore data from backup copies is human error...someone typed the wrong command. You'll have to recover the datafile from your backup tape.
HOWEVER: databases often make changes to several at the same time and if you don't restore the entire set of database files, the one missing file may be out of sync with the rest of the data, thus creating database errrors.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 11:11 PM
тАО07-07-2002 11:11 PM
Re: Restoring database files, using mirroed disk...
Ok, that means, if one of the disk get crashed, then second will continue.
--But do we get any warning of disk crashed?
or we need to look into some log file ?
When we begin to work on a new server, setup, how should be know that the disks are mirrored?
or what RAID level is implemented?
Can any body, please sugguest me some good, simple notes on "Mirrong, RAID and Oracle".
Thanks
Regards
Shah
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-07-2002 11:30 PM
тАО07-07-2002 11:30 PM
SolutionUsually disk errors are reflected in /var/adm/syslog/syslog.log. If you have EMS or Predictive, they will flag the errors as well.
To check whether a logical volume is mirrored (RAI
D 1) or striped (RAID 0) at the software level, use lvdisplay. Example:
# lvdisplay -v /dev/vgora/lvu1
For I/O performance tuning with Oracle on HP-UX, a google search should suffice. There are quite a number of good performance tuning documents around.
Hope this helps. Regards.
Steven Sim Kok Leong