Solved

Backup Oracle Installation Directory (Not the actual DB)

Posted on 2011-03-23
4
325 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

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

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

691 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