Chinaunix

标题: legato 备份oracle的问题，请教大家 [打印本页]

作者: sqlinux218 时间: 2008-07-15 12:45
标题: legato 备份oracle的问题，请教大家
legato 备份oracle时出错，错误信息如下：

oracle：RMAN:e:\back.bat：在媒体数据库中没有找到此存储集的完全备份；正在进行完全备份
C:\>ECHO OFF
EMC NetWorker Module for Oracle v4.5
Tue Jul 15 20:27:37 2008
NULL no output found in C:\Program Files\Legato\nsr\tmp\nsrnmostart.1216124857.1360.000001
Exiting with error:
Could not find RMAN at specified location.
见附件图：

client设置如下：
储存集：RMAN:e:\back.bat
备份命令：nsrnmo.bat

截图00.jpg (53.56 KB, 下载次数: 59)

作者: redwaves 时间: 2008-07-15 14:41
path加进去了吗

作者: sqlinux218 时间: 2008-07-15 15:38
加进去了
SET PATH=C:\Program Files\Legato\nsr\bin

作者: redwaves 时间: 2008-07-15 16:05

原帖由 sqlinux218 于 2008-7-15 15:38 发表
加进去了
SET PATH=C:\Program Files\Legato\nsr\bin

加oracle 命令rman.exe的path

作者: sqlinux218 时间: 2008-07-15 16:47
SET PATH=C:\oracle\product\10.2.0\db_1\BIN\
还提示错误，而且出现消方块的错误提示
已重试 1 次。
oracle：RMAN:e:\rman_back.txt：在媒体数据库中没有找到此存储集的完全备份；正在进行完全备份

C:\>ECHO OFF
'nsrnmostart' ��ڲ��ⲿ��Ҳ��ǿ��еĳ��
��ļ��

脚本文件如下，在客户端使用RMAN，SEND 方式可以成功
connect target sys/oracle@orcl;
run {
set command id to 'xxx';
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
send 'NSR_ENV=(NSE_SERVER=backupserver,NSRNSR_DATA_VOLUME_POOL=Default)';
backup full filesperset 4
format '/FULL_%d_%U/'
(database);
release channel t1;
release channel t2;
}

作者: redwaves 时间: 2008-07-15 16:56
加到nsrnmo.bat中,把你的nsrnmo.bat贴出来

作者: sqlinux218 时间: 2008-07-15 17:06
networker的日志如下，请大家帮忙分析分析，谢谢

EMC NetWorker Module for Oracle v4.5
Wed Jul 16 00:57:55 2008
nwora_agent_get_parameters: Entering.
nwora_agent_get_parameters_from_getopt: Entering.
nwora_agent_get_parameters_from_getopt: Exiting.
nwora_agent_get_parameters_from_env: Entering.
nwora_agent_get_parameters_from_env: Exiting.
nwora_agent_set_fields_using_lnm_parms: Entering.
nwora_agent_parse_msglog_name: Exiting.
nwora_agent_read_res_file: Entering.
nwora_find_nt_nwres: Using the path C:\Program Files\Legato\nsr\res.
nwora_find_nt_nwtmp: Using the path C:\Program Files\Legato\nsr\tmp.
nwora_get_resource_from_res_file: Entering.
nwora_read_res_file_image: Entering.
nwora_read_res_file_image: Opening the NWORA resource file for reading.
nwora_get_res_file_lock: Entering.
nwora_get_res_file_lock: Checking to see if the lock file 'C:\Program Files\Legato\nsr\tmp\nwora.res.lck' exists.
nwora_get_res_file_lock: Locking file 'C:\Program Files\Legato\nsr\tmp\nwora.res.lck'.
nwora_get_res_file_lock: Exiting.
nwora_open_res_file: Entering.
nwora_open_res_file: Opening the NWORA resource file for reading.
nwora_open_res_file: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA header resource.
nwora_set_resource: Exiting.
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 1
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Adding the NWORA resource to the front of the list.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_NWPATH=C:\Program Files\Legato\nsr\bin
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_NWPATH=C:\Program Files\Legato\nsr\bin
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_NWPATH=C:\Program Files\Legato\nsr\bin
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLECAT_MODE=enabled
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLECAT_MODE=enabled
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLECAT_MODE=enabled
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_REMOVE_ON_FAILURE=FALSE
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_REMOVE_ON_FAILURE=FALSE
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_REMOVE_ON_FAILURE=FALSE
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLE_NLS_LANG=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLE_NLS_LANG=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLE_NLS_LANG=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLECAT_LOG_FILE=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLECAT_LOG_FILE=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLECAT_LOG_FILE=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLECAT_DEBUG_FILE=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLECAT_DEBUG_FILE=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLECAT_DEBUG_FILE=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_TMPDIR=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_TMPDIR=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_TMPDIR=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_BUNDLING=disabled
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_BUNDLING=disabled
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_BUNDLING=disabled
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_INCR_EXPIRATION=disabled
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_INCR_EXPIRATION=disabled
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_INCR_EXPIRATION=disabled
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA SID resource.
nwora_set_resource: The NWORA resource has been set to:
type: 3
NSR_ORACLE_CONNECT_FILE=C:\oracle\product\10.2.0\connect.file
NSR_ORACLE_HOME=C:\oracle\product\10.2.0
NSR_ORACLE_LIB_PATH=Null
NSR_ORACLE_SID=orcl
NSR_ORACLE_TNS_ADMIN=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 3
NSR_ORACLE_CONNECT_FILE=C:\oracle\product\10.2.0\connect.file
NSR_ORACLE_HOME=C:\oracle\product\10.2.0
NSR_ORACLE_LIB_PATH=Null
NSR_ORACLE_SID=orcl
NSR_ORACLE_TNS_ADMIN=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 3
NSR_ORACLE_CONNECT_FILE=C:\oracle\product\10.2.0\connect.file
NSR_ORACLE_HOME=C:\oracle\product\10.2.0
NSR_ORACLE_LIB_PATH=Null
NSR_ORACLE_SID=orcl
NSR_ORACLE_TNS_ADMIN=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_close_res_file: Entering.
nwora_close_res_file: Closing the NWORA resource file.
nwora_close_res_file: Exiting.
nwora_release_res_file_lock: Entering.
nwora_release_res_file_lock: Releases the lock on 'C:\Program Files\Legato\nsr\tmp\nwora.res.lck'.
nwora_release_res_file_lock: Exiting.
nwora_read_res_file_image: Exiting.
nwora_get_resource_from_res_file: Getting the resource 'NSR_BUNDLING' of type '2' from the list.
nwora_get_resource_from_res_file: Exiting.
nwora_get_resource_from_res_file: Entering.
nwora_get_resource_from_res_file: Getting the resource 'NSR_INCR_EXPIRATION' of type '2' from the list.
nwora_get_resource_from_res_file: Exiting.
nwora_get_resource_from_res_file: Entering.
nwora_get_resource_from_res_file: Getting the resource 'NSR_TMPDIR' of type '2' from the list.
nwora_get_resource_from_res_file: Exiting.
The 'NSR_BUNDLING' and 'NSR_INCR_EXPIRATION' NWORA resource are both disabled.
nwora_agent_set_fields_using_lnm_parms: Exiting.
nwora_agent_check_parameters: Entering.
nwora_agent_check_parameters: Exiting.
nwora_agent_get_parameters: Exiting.
nwora_agent_setup_fds: Entering.
nwora_agent_setup_fds: Exiting.
The ID of the parent job is: 300
nwora_agent_setup_staging: Entering.
nwora_agent_setup_staging: Exiting.
nwora_agent_ss_start: Entering.
nwora_agent_start_rman: Entering.
nwora_set_RMAN_location: Entering.
nwora_set_RMAN_location: Setting the location of RMAN to 'C:\oracle\product\10.2.0\db_1\\bin'.
nwora_set_RMAN_location: Exiting with an error.
nwora_set_RMAN_location: Exiting.
nwora_agent_start_rman: Exiting with an error.
nwora_agent_start_rman: Exiting.
nwora_agent_ss_start: Exiting with an error.
nwora_agent_ss_start: Exiting.
nwora_agent_teardown_fds: Entering.
nwora_agent_load_message: Entering.
NULL no output found in C:\Program Files\Legato\nsr\tmp\nsrnmostart.1216141075.2600.000001
nwora_agent_load_message: Exiting.
nwora_agent_teardown_fds: Exiting.
nwora_agent_teardown_jobs: Entering.
Exiting with error:
Could not find RMAN at specified location.
nwora_agent_teardown_jobs: Exiting.
nwora_agent_teardown_staging: Entering.
nwora_agent_teardown_staging: Exiting.
Exiting with error:
Could not find RMAN at specified location.
Exiting with return code: -1
EMC NetWorker Module for Oracle v4.5
Wed Jul 16 00:57:55 2008
nwora_agent_get_parameters: Entering.
nwora_agent_get_parameters_from_getopt: Entering.
nwora_agent_get_parameters_from_getopt: Exiting.
nwora_agent_get_parameters_from_env: Entering.
nwora_agent_get_parameters_from_env: Exiting.
nwora_agent_set_fields_using_lnm_parms: Entering.
nwora_agent_parse_msglog_name: Exiting.
nwora_agent_read_res_file: Entering.
nwora_find_nt_nwres: Using the path C:\Program Files\Legato\nsr\res.
nwora_find_nt_nwtmp: Using the path C:\Program Files\Legato\nsr\tmp.
nwora_get_resource_from_res_file: Entering.
nwora_read_res_file_image: Entering.
nwora_read_res_file_image: Opening the NWORA resource file for reading.
nwora_get_res_file_lock: Entering.
nwora_get_res_file_lock: Checking to see if the lock file 'C:\Program Files\Legato\nsr\tmp\nwora.res.lck' exists.
nwora_get_res_file_lock: Locking file 'C:\Program Files\Legato\nsr\tmp\nwora.res.lck'.
nwora_get_res_file_lock: Exiting.
nwora_open_res_file: Entering.
nwora_open_res_file: Opening the NWORA resource file for reading.
nwora_open_res_file: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA header resource.
nwora_set_resource: Exiting.
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 1
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Adding the NWORA resource to the front of the list.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_NWPATH=C:\Program Files\Legato\nsr\bin
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_NWPATH=C:\Program Files\Legato\nsr\bin
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_NWPATH=C:\Program Files\Legato\nsr\bin
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLECAT_MODE=enabled
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLECAT_MODE=enabled
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLECAT_MODE=enabled
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_REMOVE_ON_FAILURE=FALSE
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_REMOVE_ON_FAILURE=FALSE
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_REMOVE_ON_FAILURE=FALSE
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLE_NLS_LANG=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLE_NLS_LANG=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLE_NLS_LANG=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLECAT_LOG_FILE=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLECAT_LOG_FILE=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLECAT_LOG_FILE=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_ORACLECAT_DEBUG_FILE=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_ORACLECAT_DEBUG_FILE=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_ORACLECAT_DEBUG_FILE=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_TMPDIR=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_TMPDIR=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_TMPDIR=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_BUNDLING=disabled
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_BUNDLING=disabled
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_BUNDLING=disabled
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA parameter resource.
nwora_set_resource: The NWORA resource has been set to:
type: 2
NSR_INCR_EXPIRATION=disabled
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 2
NSR_INCR_EXPIRATION=disabled
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 2
NSR_INCR_EXPIRATION=disabled
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_set_resource: Entering.
nwora_set_resource: Setting a NWORA SID resource.
nwora_set_resource: The NWORA resource has been set to:
type: 3
NSR_ORACLE_CONNECT_FILE=C:\oracle\product\10.2.0\connect.file
NSR_ORACLE_HOME=C:\oracle\product\10.2.0
NSR_ORACLE_LIB_PATH=Null
NSR_ORACLE_SID=orcl
NSR_ORACLE_TNS_ADMIN=Null
nwora_set_resource: Exiting.
nwora_read_res_file_image: Obtained resource:
type: 3
NSR_ORACLE_CONNECT_FILE=C:\oracle\product\10.2.0\connect.file
NSR_ORACLE_HOME=C:\oracle\product\10.2.0
NSR_ORACLE_LIB_PATH=Null
NSR_ORACLE_SID=orcl
NSR_ORACLE_TNS_ADMIN=Null
nwora_update_resource_list: Entering.
nwora_update_resource_list: Adding NWORA resource:
type: 3
NSR_ORACLE_CONNECT_FILE=C:\oracle\product\10.2.0\connect.file
NSR_ORACLE_HOME=C:\oracle\product\10.2.0
NSR_ORACLE_LIB_PATH=Null
NSR_ORACLE_SID=orcl
NSR_ORACLE_TNS_ADMIN=Null
nwora_update_resource_list: Dup'ing the NWORA resource.
nwora_update_resource_list: Exiting.
nwora_close_res_file: Entering.
nwora_close_res_file: Closing the NWORA resource file.
nwora_close_res_file: Exiting.
nwora_release_res_file_lock: Entering.
nwora_release_res_file_lock: Releases the lock on 'C:\Program Files\Legato\nsr\tmp\nwora.res.lck'.
nwora_release_res_file_lock: Exiting.
nwora_read_res_file_image: Exiting.
nwora_get_resource_from_res_file: Getting the resource 'NSR_BUNDLING' of type '2' from the list.
nwora_get_resource_from_res_file: Exiting.
nwora_get_resource_from_res_file: Entering.
nwora_get_resource_from_res_file: Getting the resource 'NSR_INCR_EXPIRATION' of type '2' from the list.
nwora_get_resource_from_res_file: Exiting.
nwora_get_resource_from_res_file: Entering.
nwora_get_resource_from_res_file: Getting the resource 'NSR_TMPDIR' of type '2' from the list.
nwora_get_resource_from_res_file: Exiting.
The 'NSR_BUNDLING' and 'NSR_INCR_EXPIRATION' NWORA resource are both disabled.
nwora_agent_set_fields_using_lnm_parms: Exiting.
nwora_agent_check_parameters: Entering.
nwora_agent_check_parameters: Exiting.
nwora_agent_get_parameters: Exiting.
nwora_agent_setup_fds: Entering.
nwora_agent_setup_fds: Exiting.
The ID of the parent job is: 300
nwora_agent_setup_staging: Entering.
nwora_agent_setup_staging: Exiting.
nwora_agent_ss_start: Entering.
nwora_agent_start_rman: Entering.
nwora_set_RMAN_location: Entering.
nwora_set_RMAN_location: Setting the location of RMAN to 'C:\oracle\product\10.2.0\db_1\\bin'.
nwora_set_RMAN_location: Exiting with an error.
nwora_set_RMAN_location: Exiting.
nwora_agent_start_rman: Exiting with an error.
nwora_agent_start_rman: Exiting.
nwora_agent_ss_start: Exiting with an error.
nwora_agent_ss_start: Exiting.
nwora_agent_teardown_fds: Entering.
nwora_agent_load_message: Entering.
NULL no output found in C:\Program Files\Legato\nsr\tmp\nsrnmostart.1216141075.2216.000001
nwora_agent_load_message: Exiting.
nwora_agent_teardown_fds: Exiting.
nwora_agent_teardown_jobs: Entering.
Exiting with error:
Could not find RMAN at specified location.
nwora_agent_teardown_jobs: Exiting.
nwora_agent_teardown_staging: Entering.
nwora_agent_teardown_staging: Exiting.
Exiting with error:
Could not find RMAN at specified location.
Exiting with return code: -1

作者: sqlinux218 时间: 2008-07-15 17:09
nsrnmo.bat如下：
ECHO OFF

REM

REM $Id: nsrnmo.bat,v 1.2.32.3.4.2 2007/04/19 18:45:14 lecoue Exp $  Copyright (c) 2004-2007 EMC Corporation.

REM

REM All rights reserved.

REM

REM nsrnmo.bat

REM

REM This script is part of the EMC NetWorker Module for Oracle.

REM Modification of this script should be done with care and only after reading

REM the administration manual included with this product.

REM

REM Users should be aware that no system environment variables will be

REM inherited from a parent process. Any environment variables to be used

REM in this file have to be set in this file.

REM

REM This script should only be run as part of a scheduled savegroup.

REM

REM Returns 0 on success; 1 on failure.

REM

REM

REM Make environment variable changes local

REM

SETLOCAL

REM

REM Configuration variables, modifiable by users.

REM

REM

REM REQUIRED Variable: ORACLE_HOME

REM

REM Default value: none (site specific)

REM

REM Description: Specifies where the Oracle Server installation is located.

REM    It is a requirement that rman or rman80 be located in

REM    %ORACLE_HOME%\bin.

REM

REM Samples:

REM    SET ORACLE_HOME=e:\orant

REM

SET ORACLE_HOME=C:\oracle\product\10.2.0\db_1\

REM

REM REQUIRED Variable: PATH

REM

REM Default value: none (site and platform specific)

REM

REM Description: Set up the PATH environment variable. This must be

REM    configured to include the path to "nsrnmostart" and "save".

REM

REM Samples:

REM    SET PATH=e:\orant\bin;c:\win32app\nsr\bin

REM    SET PATH=e:\orant\bin;c:\Program Files\nsr\bin

REM    SET PATH=e:\orant\bin;c:\Program Files\Legato\nsr\bin

REM

SET PATH=C:\Program Files\Legato\nsr\bin;C:\Program Files\Legato\nsr\bin

REM

REM Optional Variable: ORACLE_SID

REM

REM Default value: NONE (site specific)

REM

REM Description: Specifies the SID of the Oracle database being backed up.

REM It is a requirement that rman be located in ORACLE_HOME/bin.  It is

REM required by proxy copy backups when catalog synchronization is enabled.

REM

REM Samples:

REM    ORACLE_SID=orcl901

REM

SET ORACLE_SID=orcl

REM

REM Optional Variable: NLS_LANG

REM

REM Default value: NONE (site specific)

REM

REM Description: This environment variable specifies the language,

REM territory, and character set used by the Oracle Database.

REM See Oracle National Language Support for more information.

REM

REM Example:

REM             NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

REM

REM SET NLS_LANG=

REM

REM Optional Variable: NSR_RMAN_ARGUMENTS

REM

REM Default value: none (site specific)

REM

REM Description: Provide extra rman parameters.

REM    You must enclose the command in quotes or it will not be

REM    passed correctly to rman.

REM

REM Samples:

REM    SET NSR_RMAN_ARGUMENTS="nocatalog msglog 'c:\Program Files\Legato\nsr\applogs\msglog.log' append"

REM

REM    SET NSR_RMAN_ARGUMENTS="nocatalog"

REM

SET NSR_RMAN_ARGUMENTS="nocatalog msglog 'c:\Program Files\Legato\nsr\applogs\msglog.log' append"

REM

REM Optional Variable: NSR_RMAN_OUTPUT

REM

REM Default value: NONE (site specific)

REM

REM Description: Provide option to capture the RMAN standard output

REM    if RMAN "msglog" or "log" command line option is

REM    not set. The connect strings will be hidden in this file.

REM

REM Samples:

REM    SET NSR_RMAN_OUTPUT="c:\Program Files\Legato\nsr\applogs\msglog.log append"

REM

REM    SET NSR_RMAN_OUTPUT="c:\Program Files\Legato\nsr\applogs\msglog.log"

REM

SET NSR_RMAN_OUTPUT="c:\Program Files\Legato\nsr\applogs\msglog.log"

REM

REM Optional Variable: NSR_SB_DEBUG_FILE

REM

REM Default value: none (site specific)

REM

REM Description: To enable debugging output for NMO scheduled backups set

REM    the following to an appropriate path and file name.

REM    Set this variable for debugging purposes only

REM Samples:

REM    SET NSR_SB_DEBUG_FILE=c:\Program Files\Legato\nsr\applogs\nsrnmostart.log

REM

SET NSR_SB_DEBUG_FILE=c:\Program Files\Legato\nsr\applogs\nsrnmostart.log

REM

REM Optional Variable: PRECMD

REM Default value: NONE

REM Description: This variable can be used to run a command or command script

REM    before nsrnmostart. It will be launched once for every saveset

REM    entered in the client setup.

REM

SET PRECMD=

REM

REM Optional Variable: POSTCMD

REM Default value: NONE

REM Description: This variable can be used to run a command or command script

REM    after nsrnmostart has completed. It will be launched once for

REM    every saveset entered in the client setup.

REM

SET POSTCMD=

REM

REM Optional Variable: TNS_ADMIN

REM Default value: NONE

REM Description: This variable needs to be set if Oracle Net configuration

REM files are not located in default locations.

REM

SET TNS_ADMIN=

REM

REM Execute the backup command

REM

SET args=%*

nsrnmostart %args%

REM

REM Cleanup from the command

REM

ENDLOCAL

作者: sqlinux218 时间: 2008-07-15 17:12
ORACLE_HOME和PATH参数是按文档中的提示设置的啊

ORACLE_HOME
此参数是每个定时备份的强制参数。在 nsrnmo 脚本文件中，将 ORACLE_HOME 设
置为 Oracle Server 安装的主目录。 RMAN 可执行文件 rman 必须位于
$ORACLE_HOME 的子目录 bin 中。
例如，如果 Oracle Server 安装位于目录 /disk3/oracle/app/oracle/product/9.2 中，
则必须按如下所示在 nsrnmo 脚本中设置 ORACLE_HOME：
ORACLE_HOME=/disk3/oracle/app/oracle/product/9.2
PATH
此参数是每个定时备份的强制参数。在 nsrnmo 脚本文件中，将 PATH 设置为包含
Oracle Server 主机上 NMO nsrnmostart 程序和 NetWorker save 程序的目录的路径名。
例如，在 Solaris Oracle Server 上，如果 nsrnmostart 程序位于 /usr/sbin 目录中，而
save 程序位于 /usr/sbin/nsr 中，则在 nsrnmo 脚本中将 PATH 设置为以下类型的值：
PATH=/usr/sbin:/usr/sbin/nsr

作者: myguangzhou 时间: 2008-07-15 17:48
把ORACLE -HOME/BIN加进PATH去

作者: 跟帖回复 时间: 2008-07-15 21:54
好长，懒的看

你的nsrnmo没看出来加了rman.exe所在的PATH啊

另外，windows下写PATH变量的时候注意目录和文件名称中的空格
比如写成:
c:\progra~1\legato\nsr\bin
或者用"\\"代替"\"

作者: sqlinux218 时间: 2008-07-16 13:02
加入：
SET PATH=C:\oracle\product\10.2.0\db_1\bin;C:\Program Files\Legato\nsr\bin

还是出现同样的问题：

已重试 1 次。
oracle：RMAN:c:\rman_back.txt：在媒体数据库中没有找到此存储集的完全备份；正在进行完全备份
C:\>ECHO OFF
EMC NetWorker Module for Oracle v4.5
Wed Jul 16 19:41:39 2008
NULL no output found in C:\Program Files\Legato\nsr\tmp\nsrnmostart.1216208499.3956.000001
Exiting with error:
Could not find RMAN at specified location.

命令提示符下输入nsrnmoadmin -r list后如下显示：
C:\>nsrnmoadmin -r list

NSR_NWPATH=C:\Program Files\Legato\nsr\bin

NSR_ORACLECAT_MODE=enabled

NSR_REMOVE_ON_FAILURE=FALSE

NSR_ORACLE_NLS_LANG=

NSR_ORACLECAT_LOG_FILE=

NSR_ORACLECAT_DEBUG_FILE=

NSR_TMPDIR=

NSR_BUNDLING=disabled

NSR_INCR_EXPIRATION=disabled

C:\>

请高手帮忙

作者: myguangzhou 时间: 2008-07-16 14:14
找不到RMAN路径？你CMD下能用RMAN么？试看看

作者: Chinese_Dragon 时间: 2008-07-16 18:08
Setting the location of RMAN to 'C:\oracle\product\10.2.0\db_1\\bin'.

感觉不对

作者: redwaves 时间: 2008-07-16 20:02
nsrnmoadmin -r list

[ 本帖最后由 redwaves 于 2008-7-18 23:00 编辑 ]

作者: sqlinux218 时间: 2008-07-17 13:31
cmd下是可以用rman的

作者: sqlinux218 时间: 2008-07-17 13:35
补充：
C:\>nsrnmoadmin -l
nsrnmoadmin: 无法识别参数“-l”。
usage:
      nsrnmoadmin [-D] -r list [ResourceName] | [SidName]

      nsrnmoadmin [-D] -r add ResourceName ResourceValue

      nsrnmoadmin [-D] -r add sid=SidName home=OracleHome
            connect=ConnectFilePath [tns=TNSpath] [lib=LibraryPath]

      nsrnmoadmin [-D] -r update ResourceName ResourceValue

      nsrnmoadmin [-D] -r update sid=SidName [home=OracleHome]
            [connect=ConnectFilePath] [tns=TNSpath] [lib=LibraryPath]

      nsrnmoadmin [-D] -r delete SidName

C:\>nsrnmoadmin -r list

NSR_NWPATH=C:\Program Files\Legato\nsr\bin

NSR_ORACLECAT_MODE=enabled

NSR_REMOVE_ON_FAILURE=FALSE

NSR_ORACLE_NLS_LANG=

NSR_ORACLECAT_LOG_FILE=

NSR_ORACLECAT_DEBUG_FILE=

NSR_TMPDIR=

NSR_BUNDLING=disabled

NSR_INCR_EXPIRATION=disabled

C:\>

手动备份可以备份：

C:\>rman cmdfile 'e:\backup.txt' send '"NSR_ENV=(NSR_SERVER=backupserver,NSR_GRO
UP=qqq)"'

恢复管理器: Release 10.2.0.1.0 - Production on 星期四 7月 17 21:03:51 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target *
2> run{
3> allocate channel t1 type 'sbt_tape';
4> send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=Default)';
5> backup full filesperset 4
6> format '/FULL_%d_%U/'
7> (database);
8> release channel t1;
9> }
10>
连接到目标数据库: TEST (DBID=1958482343)

使用目标数据库控制文件替代恢复目录
分配的通道: t1
通道 t1: sid=142 devtype=SBT_TAPE
通道t1: NMO v4.5.0.0
向通道发命令: t1

向通道发命令: t1

启动 backup 于 17-7月 -08
通道 t1: 启动全部数据文件备份集
通道 t1: 正在指定备份集中的数据文件
输入数据文件 fno=00001 name=C:\ORACLE\PRODUCT\ORADATA\TEST\SYSTEM01.DBF
通道 t1: 正在启动段 1 于 17-7月 -08
通道 t1: 已完成段 1 于 17-7月 -08
段句柄=/FULL_TEST_0ajlo3pt_1_1/ 标记=TAG20080717T210356 注释=API Version 2.0,MMS
Version 4.5.0.0
通道 t1: 备份集已完成, 经过时间:00:01:45
通道 t1: 启动全部数据文件备份集
通道 t1: 正在指定备份集中的数据文件
输入数据文件 fno=00003 name=C:\ORACLE\PRODUCT\ORADATA\TEST\SYSAUX01.DBF
输入数据文件 fno=00005 name=C:\ORACLE\PRODUCT\ORADATA\TEST\EXAMPLE01.DBF
输入数据文件 fno=00002 name=C:\ORACLE\PRODUCT\ORADATA\TEST\UNDOTBS01.DBF
输入数据文件 fno=00004 name=C:\ORACLE\PRODUCT\ORADATA\TEST\USERS01.DBF
通道 t1: 正在启动段 1 于 17-7月 -08
通道 t1: 已完成段 1 于 17-7月 -08
段句柄=/FULL_TEST_0bjlo3t6_1_1/ 标记=TAG20080717T210356 注释=API Version 2.0,MMS
Version 4.5.0.0
通道 t1: 备份集已完成, 经过时间:00:00:45
通道 t1: 启动全部数据文件备份集
通道 t1: 正在指定备份集中的数据文件
备份集中包括当前控制文件
在备份集中包含当前的 SPFILE
通道 t1: 正在启动段 1 于 17-7月 -08
通道 t1: 已完成段 1 于 17-7月 -08
段句柄=/FULL_TEST_0cjlo3uj_1_1/ 标记=TAG20080717T210356 注释=API Version 2.0,MMS
Version 4.5.0.0
通道 t1: 备份集已完成, 经过时间:00:00:09
完成 backup 于 17-7月 -08

释放的通道: t1

恢复管理器完成。

C:\>

作者: sqlinux218 时间: 2008-07-19 15:14
问题出在pool的设置上，为备份组创建除Default外的pool，现以解决，非常感谢redwaves 的在线支持，谢谢！

作者: edision 时间: 2008-07-21 14:43
标题: 回复 #1 sqlinux218 的帖子
是你的PATH路经配置有问题

作者: xiaomao2006 时间: 2008-07-22 11:59
标题: 回复 #18 sqlinux218 的帖子
报的错和真正的问题不一样?

作者: myguangzhou 时间: 2008-07-22 13:30

原帖由 sqlinux218 于 2008-7-19 15:14 发表
问题出在pool的设置上，为备份组创建除Default外的pool，现以解决，非常感谢redwaves 的在线支持，谢谢！

不是吧？把DATA放在DEFAULT池里不行么？LEGATO太诡异了吧。
建议你把问题理顺一下，个人认为问题不出在POOL这里

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)