[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Amanda oracle backup

Posted on 2014-04-23
7
Medium Priority
?
404 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Using 'screen' for session sharing, The Simple Edition Step 1: user starts session with command: screen Step 2: other user (logged in with same user account) connects with command: screen -x Done. Both users are connected to the same CLI sessio…
Often times it's very very easy to extend a volume on a Linux instance in AWS, but impossible to shrink it. I wanted to contribute to the experts-exchange community a way of providing a procedure that works on an AWS instance. It can also be used on…
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.:
Suggested Courses
Course of the Month18 days, left to enroll

830 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