Unsolved

This post is more than 5 years old

3 Posts

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

4 Operator

 • 

14.3K Posts

November 9th, 2009 08:00

You do it in a same way as with Linux which means backup command is nsrnmo* (if changing default one that nsrnmo.bat), your saveset is RMAN:path_to_rman_script.

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.

3 Posts

November 10th, 2009 01:00

I write:

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 ?

2 Intern

 • 

2K Posts

November 10th, 2009 02:00

You need to check your nsrnmo script. There is something wrong with some parameter like Oracle home, Oracle library etc here OR RMAN has not been configured on the Oracle server.

3 Posts

November 10th, 2009 04:00

This is my nrsnmo.bat script:

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

4 Operator

 • 

14.3K Posts

November 10th, 2009 16:00

Can you verify that rman binary is inside D:\oracle\ora92\bin? Because it seems to indicate it can't find rman to execute the script.
No Events found!

Top