- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Recover Database
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-22-2008 03:49 AM
тАО07-22-2008 03:49 AM
Recover Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2008 03:54 AM
тАО07-22-2008 03:54 AM
Re: Recover Database
Seems that you are pretty screwed.
At this point I would suggest contacting support from the database vendor to see if anything can be done.
Knowing the version of Oracle if that is what is installed would be helpful.
Knowing the version of HP-UX and if any backup tapes at all would be helpful as well.
But it would seem its time to admit a screw up and see about an old backup tape that at least limits the amount of data lost.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2008 05:18 AM
тАО07-22-2008 05:18 AM
Re: Recover Database
HP 11 64 tru
last backup is 31st May
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2008 09:05 AM
тАО07-22-2008 09:05 AM
Re: Recover Database
are you on Oracle Support? If yes, please contact them for a more prompt response.
good luck!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-22-2008 02:45 PM
тАО07-22-2008 02:45 PM
Re: Recover Database
Sorry for bad news.
If your database is not in archivelog mode you cannot restore just system.dfn file from your last backup. You need full consistent (cold) backup (including all *.ctl , redo log and data files).
Regards
Vadim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2008 12:11 AM
тАО07-25-2008 12:11 AM
Re: Recover Database
first of all:
Take a cold backup of all what you have right now ! This includes Controlfiles, Online redologfiles and all datafiles.
Then, if you are very lucky, you might be
successfull to recover the database from the online redologs.
sqlplus / as sysdba
startup mount
recover database
In case you are lucky, since you hopefully do not have a defective file, the recovery will not require an archive log, but will be able to recover from what is in the online redologs (because you just had a system shutdown, an not a defective harddisk).
After successfull recovery, you should be able to open the db normally.
If the file is media coruppted, you will be in trouble, and I have doubts, that the DB will ever be opened again in a consistent way. (This is the case, where you might need the cold backup I mentioned first to give Oracle support several tries to repair it).
In case all goes bad in consistent opening of the database, there are some parameters, that allow to open the database inconsistent.
After that you might be able to export some tables and re-import them to a new created database, but this would require additional logical checks for consitency.
Good luck
Volker