Unsolved
This post is more than 5 years old
3 Posts
0
2113
November 9th, 2009 06:00
How to backup Oracle in Windows 2003 ?
Hello all,
I don't have a problem to backup an Oracle database in Linux environment but i have a problem in Windows.
I've installed NMO 4.5 on Oracle Server which was already Networker client. Another server is Networker server 7.4.3.
In backup command, I've write nsrnmo, is it ok ?
In saveset, I've write script path (for example: D:\legato\nsr\bin\nsrnmo.bat). is ok or not ?
The nsrnmo.bat script is not the same between Windows and Linux. In Linux, I have a script like this one:
set echo on;
spool log to /tmp/rman_output_NeTW.txt;
connect target user/password@oracledatabase;
connect catalog rman/rman@rman;
run {
allocate channel t1 type sbt PARMS
'ENV=(NSR_SERVER=srv-im-01,NSR_DATA_VOLUME_POOL=Pool,NSR_CLIENT=srv_oracle)';
backup full as backupset
tag SbD_Prd_Linux_full_backup
format 'NetW_full_backup_SbD_Prd_Linux_df_t%t_s%s_p%p'
(database include current controlfile) plus archivelog;
release channel t1;
}
My commands in networker server are ok ? What type of script is ok for Oracle Windows Server? And which extension ? (.bat ?)
Regards
I don't have a problem to backup an Oracle database in Linux environment but i have a problem in Windows.
I've installed NMO 4.5 on Oracle Server which was already Networker client. Another server is Networker server 7.4.3.
In backup command, I've write nsrnmo, is it ok ?
In saveset, I've write script path (for example: D:\legato\nsr\bin\nsrnmo.bat). is ok or not ?
The nsrnmo.bat script is not the same between Windows and Linux. In Linux, I have a script like this one:
set echo on;
spool log to /tmp/rman_output_NeTW.txt;
connect target user/password@oracledatabase;
connect catalog rman/rman@rman;
run {
allocate channel t1 type sbt PARMS
'ENV=(NSR_SERVER=srv-im-01,NSR_DATA_VOLUME_POOL=Pool,NSR_CLIENT=srv_oracle)';
backup full as backupset
tag SbD_Prd_Linux_full_backup
format 'NetW_full_backup_SbD_Prd_Linux_df_t%t_s%s_p%p'
(database include current controlfile) plus archivelog;
release channel t1;
}
My commands in networker server are ok ? What type of script is ok for Oracle Windows Server? And which extension ? (.bat ?)
Regards
No Events found!



ble1
4 Operator
•
14.3K Posts
0
November 9th, 2009 08:00
What you listed is not nsrnmo script, but rather RMAN script... Are you sure your Linux backup works?
Anyway, check installation guide as it gives you nice step by step guide.
adv2
3 Posts
0
November 10th, 2009 01:00
backup command: nsrnmo.bat
saveset: RMAN:D:\legato\nsr\bin\Rman_script.bat
I have this messages when I launch my group:
1 retry attemped
No full backups of this save were found in the media database, performing a full backup
C:\>ECHO OFF
EMC Netwroker Module For Oracle v4.5
Tue Nov 10 10:15:04 2009
NULL no output found in D:\Legato\nsr\tmp\nsrnmostart.1257844054.6056.000001
Exiting with error
Could not fin RMAN at specified location
My Rman_script:
connect target system/manager@solv
connect catalog rman/rman@rman
run{
set command id to 'xxx';
allocate channel t1 type 'SBT_TAPE';
send 'NSR_ENV=(NSR_DATA_VOLUME_POOL=Mensuel)';
backup full filesperset 4 format '/FULL_%d_%u/' (database);
release channel t1
}
Do you have any idea ?
amediratta
2 Intern
•
2K Posts
0
November 10th, 2009 02:00
adv2
3 Posts
0
November 10th, 2009 04:00
ECHO ON
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=D:\oracle\ora92
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=D:\oracle\ora92\bin;D:\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=SOLV
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
REM SET NSR_RMAN_ARGUMENTS=
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
REM SET NSR_RMAN_OUTPUT=
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
REM SET NSR_SB_DEBUG_FILE=
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
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
REM SET TNS_ADMIN=
REM
REM Execute the backup command
REM
SET args=%*
nsrnmostart %args%
REM
REM Cleanup from the command
REM
ENDLOCAL
ble1
4 Operator
•
14.3K Posts
0
November 10th, 2009 16:00