- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Restore database software from backup tape
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
тАО01-16-2003 07:13 PM
тАО01-16-2003 07:13 PM
If I lost all my oracle software ,let say /oracle/product was removed.
Can I restore all oracle software from backup test? It will work or not?
I understand that if I re-install , it will work, but I would like to test my backup stategies by restore it from backup.
Any idea or thought would be appreciated
Regards
Sonny
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 07:24 PM
тАО01-16-2003 07:24 PM
SolutionIf you have a test box available to you then do a backup and then move the /oracle/product/whatever_version directory somewhere else and try restoring it from tape. Testing is always the surest way to see if you backups will work.
Just keep in mind that unless you bring your database down, or are doing hot backups with the database in backup mode, you database (.dbf files, etc.) it will be difficult to restore your database itself, which is probably more important.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-16-2003 07:37 PM
тАО01-16-2003 07:37 PM
Re: Restore database software from backup tape
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2003 05:12 PM
тАО01-19-2003 05:12 PM
Re: Restore database software from backup tape
Yes when you want to test this backup/rstore make sure your oracle database for the version of the product that you want to restore is down. And also after the restore of the products directory, re-create any soft links that were pointing to the pfile (init_sid.ora) file and any for tnsnames.ora and listener.ora files. Once you have restored then check for all the links and try to startup the database and you can test by loging on to SQLPLUS or svrmgrl and selecting the datafile, log files and control files names and locations and verifing.
As a pre-cautionary, take a full cold backup of the database and make sure you have a successfull backup of the file system thta has the oracle/product.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-19-2003 06:29 PM
тАО01-19-2003 06:29 PM
Re: Restore database software from backup tape
A backup of the /oracle/product directory can be restored no problem. Make sure the database is down so there are no open file problems. Doesn't sound like thats an issue here.
Steve
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
тАО01-19-2003 07:33 PM
тАО01-19-2003 07:33 PM
Re: Restore database software from backup tape
1.Let's say you have only the Oracle installation files in the /oracle/product dir then restoration will bring back the oracle software.This is not a problem.
2.If you have oracle sofware + database files(control files,data files,log files) inside the /oracle/product dir.
then if only you had a proper cold backup of oracle your database will be restored completely.
1.If you had not done a cold backup(backup after shutting down of database) of oracle database, or a proper hot backup then your database restoration will be a incomplete recovery.