Improve company productivity with a Business Account.Sign Up

x
?
Solved

Amanda oracle backup

Posted on 2014-04-23
7
Medium Priority
?
418 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
  • 4
  • 3
7 Comments
 
LVL 14

Assisted Solution

by:ThomasMcA2
ThomasMcA2 earned 2000 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
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.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

587 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