Backing Up Oracle on Oracle Enterprise Linux 5.5

Posted on 2011-05-01
Medium Priority
Last Modified: 2012-05-11
I have an immediate need to backup an Oracle database which is running on Oracle Enterprise Linux 5 update 5 64bit.

I talked to Symantec Sales before I purchased it and was assured that Backup Exec 2010 agent for Oracle on Windows/Linux would work.   I purchased Backup Exec 2010 R2 and installed it on the Windows Server then tried to install it on the Oracle Linux and was unable to decompress the file.  

If I use tar I get:
skipping to next header
tar archive contains obsolescent base-64 headers
incomplete literal tree

If I use gzip I get :
stdin invalid compressed data format violated
tar child returned status 1

I contacted Symantec technical support and after multiple calls I finaly got a call back and was told they could not help me because it is not supported on 5.5.  They told me that they do have some customers who have gotten it to work but it is not supported and it will not be supported in their upcoming Backup Exec 2010 R3 in May.   The only suggestion they gave me was to try unpacking it elsewhere to see if the file was corrupt.  

I would appreciate any suggestions.  I need to get this working as soon as possible.   We are going live with a conversion tomorrow and we want to be able to back up the data on the new system.  

Anybody get BE2010 agent to work on Oracle Enterprise Linux 5 update 5?

Is there a better way to go about this.  I had planned on using a Windows 2003 server as the media server backing up to a LTO3 tape drive
Question by:qvfps
  • 2
  • 2
LVL 40

Accepted Solution

mrjoltcola earned 1600 total points
ID: 35502744
I advise you to get both datapump epxorts and an RMAN backup until you figure out Backup Exec.

How large is the database? You can do an RMAN backup like this, from the oracle OS user:

rman target /
RMAN> configure controlfile autobackup on;
RMAN> backup database plus archivelog;

Open in new window

That will get you a hot backup that you can use to restore or relocate the database.

You can also export the database via exp or expdp to give you a portable, logical dump of the data. Which Oracle version?

Export example:
exp system/admin file=full.dmp full=y

Open in new window

expdp system/admin full=y

Open in new window


Author Comment

ID: 35502874
Would there being any problem in running RMAN to get a backup of the database and then using FTP to transfer the backup file(s) to a Windows Server to be backed up to tape?    Would this cause any issues if a restore was needed?  

Is Datapump included with 11g?  I did not see it in the manual.
LVL 40

Expert Comment

ID: 35502902
No problem, just make sure you get everything. As always, before trusting a backup, you need to test it by restoring it on another server, if possible.

RMAN backs up to the Flash Recovery Area, by default, see below how to find the location.

C:\Users\msmith>sqlplus / as sysdba

SQL*Plus: Release Production on Mon May 2 01:55:32 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release - Production

SQL> show parameter db_recov

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      C:\oracle\flash_recovery_area
db_recovery_file_dest_size           big integer 16000M

Open in new window

Datapump is part of Oracle. expdp and impdp are the command utilities.

Author Comment

ID: 35502904
The example looks like it is running on Windows.  Does it make any difference if it is running on Linux?
LVL 35

Assisted Solution

johnsone earned 400 total points
ID: 35505513
The example is showing you how to get the location.  Those commands will work regardless of operating system.

One thing to add.  If you are using FTP to transfer the files to a Windows server, make sure you transfer them in binary mode.  This gets forgotten more times than I care to remember and makes for useless backups.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Fine Tune your automatic Updates for Ubuntu / Debian
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

839 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