Solved

Amanda oracle backup

Posted on 2014-04-23
7
380 Views
Last Modified: 2014-05-21
Hi,

i've configured amanda backup server.Now i'm getting below error.

Either oracle-oracle-sids or oracle-sids should be set in amanda-client.conf.
ERROR: 192.168.1.2: Application 'amrman': exited with status 1

Thanks & Regards,
xerox
0
Comment
Question by:xeroxzerox
[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
  • 4
  • 3
7 Comments
 
LVL 14

Assisted Solution

by:ThomasMcA2
ThomasMcA2 earned 500 total points
ID: 40017374
You need to tell the Amanda configuration which Oracle SIDs to backup. Here's how:

On the Amanda client you must manually add entries to /etc/amanda/amanda-client.conf that define the Oracle SIDs being backed up, as well as the "SID List" that will be used to select the databases in the ZMC Backup What page. The syntax for entries is as follows:

    property "SID-list-name-BACKUP-DIRECTORY" "Backup_path_on_client"
    property "SID-list-name-ORACLE-SIDS" "SID_1" "[SID_2" ...]
    property "SID-ORACLE-HOME" "Oracle_Home_Directory_for_SID"
    property "SID-ORACLE-PATH" "Oracle_Path_for_SID"
    property "SID-ORACLE-CONNECT-STRING" "Connect_string_for_SID"

More details about those properties can be found here.
0
 
LVL 6

Accepted Solution

by:
xeroxzerox earned 0 total points
ID: 40019461
Thanks ThomasMcA2,

i've configured all entries in amanda.conf file
Now i'm below error msg.
ERROR: 192.168.1.2: RMAN returned error for SID test: please check
/var/log/amanda/client/Oracle-Backup/amrman_rman.18134.log on client for
more details.  
In amrman_rman.18134.log file
ORA-12154: TNS:could not resolve the connect identifier specified

I've followed http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm page & confirm all entry in tnsnames.ora.
 
Thanks,
XeroxZerox
0
 
LVL 6

Author Comment

by:xeroxzerox
ID: 40019710
second issue.

FAILURE DETAILS:
  /-- 192.168.1.2 Oracle lev 0 FAILED [sendbackup: error [amrman failed]
  sendbackup: info BACKUP=APPLICATION
  sendbackup: info APPLICATION=amrman
  sendbackup: info RECOVER_CMD=/usr/lib/amanda/application/amrman restore [./file-to-restore]+
  sendbackup: info end
  sendbackup: error [sendbackup: error [amrman failed]]

Thanks & Regards,
Xeroxzerox
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40021638
It sounds like your backup server can't find (connect to) the "test" server.

What happens when you run tnsping test on the backup server?
0
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40031045
Is your Oracle server/database working correctly? Your "could not resolve" error implies that it might not be.
0
 
LVL 6

Author Comment

by:xeroxzerox
ID: 40069709
Thanks thomas,issue in tns file.
0
 
LVL 6

Author Closing Comment

by:xeroxzerox
ID: 40079978
Issue in tns file.i
0

Featured Post

The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

Question has a verified solution.

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

If you have a server on collocation with the super-fast CPU, that doesn't mean that you get it running at full power. Here is a preamble. When doing inventory of Linux servers, that I'm administering, I've found that some of them are running on l…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:

705 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