Solved

Backup Oracle Installation Directory (Not the actual DB)

Posted on 2011-03-23
4
321 Views
Last Modified: 2012-05-11
So I have my Oracle database on a RAID 10 SAN, but my Oracle Home installation directory (OraHome10G) is currently only on a local RAID 5 array. I'd like to have a seamless as possible transition if I were to lose my Oracle server, so I'm trying to figure out the best practices for backing up the OraHome10g directory. I'd like to think that I can just copy the entire contents with Symantec Backup Exec 12.5 and it will skip any locked files?
0
Comment
Question by:Bigchingan
  • 2
  • 2
4 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35197838
There are likely some files in ORACLE_HOME that cannot be backed up with a filesystem backup.  If the files are 'open' and 'locked' they are likely important.  For example, an Oracle control file.

Where are your database files?

I'm guessing Windows?  There are important registry keys you need as well.

RMAN should take care of the database files and as long as you make sure to grab the other files (typically under the database and/or dbs directories) properly you should be fine.

There might be some other files depending on what Oracle products you have installed.
0
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 35201600
slightwv,

I think Bigchingan is asking about backing up the Oracle_Home rather than the database files.

Yes you can/should backup your ORACLE_HOME and no files should be locked except perhaps console files but that is not critical.

R.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 250 total points
ID: 35201641
I got that part of it as well.  

There is also the Inventory files stored outside Oracle Home on Windows.

I just wanted to make sure we covered:
"seamless as possible transition if I were to lose my Oracle server"
0
 
LVL 16

Assisted Solution

by:Richard Olutola
Richard Olutola earned 250 total points
ID: 35201773
You're right.

So backup ORACLE_HOME and Inventory location. Although Inventory can be recreated if lost, but it is a pain so please back that up too.

R.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Facing problems with you memory card? Cannot access your memory card? All stored data, images, videos are lost? If these are your questions...than this small article might help you out in retrieving your lost or inaccessible data.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…

832 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