Solved

Amanda oracle backup

Posted on 2014-04-23
7
355 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 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Why VNC doesn't work in Redhat? 11 42
How to install software on a provisioned vagrant image 3 62
Virtualizing very old guest OS 4 80
Backup & Restore 3 46
This is the error message I got (CODE) Error caused by incompatible libmp3lame 3.98-2 with ffmpeg I've googled this error message and found out sometimes it attaches this note "can be treated with downgrade libmp3lame to version 3.97 or 3.98" …
Network Interface Card (NIC) bonding, also known as link aggregation, NIC teaming and trunking, is an important concept to understand and implement in any environment where high availability is of concern. Using this feature, a server administrator …
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.:
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now