[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Amanda oracle backup

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
xeroxzerox
Asked:
xeroxzerox
  • 4
  • 3
2 Solutions
 
ThomasMcA2Commented:
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
 
xeroxzeroxAuthor Commented:
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
 
xeroxzeroxAuthor Commented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
ThomasMcA2Commented:
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
 
ThomasMcA2Commented:
Is your Oracle server/database working correctly? Your "could not resolve" error implies that it might not be.
0
 
xeroxzeroxAuthor Commented:
Thanks thomas,issue in tns file.
0
 
xeroxzeroxAuthor Commented:
Issue in tns file.i
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now