[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

Backup Oracle Installation Directory (Not the actual DB)

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
Bigchingan
Asked:
Bigchingan
  • 2
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
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
 
Richard OlutolaConsultantCommented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
Richard OlutolaConsultantCommented:
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now