‹‹ 上一主题 | 下一主题 ››
发新话题
打印

Legato 备份ORACLE 问题，大家一起来讨论呀

本帖已经被作者加入个人空间
angle

神功盖世

Rank: 8Rank: 8

超级无敌存储大菜鸟

帖子
1311 
精华
10 
积分
18136 
金币
839  
1# 大 中 小 发表于 2006-2-21 16:23  只看该作者

Legato 备份ORACLE 问题，大家一起来讨论呀

原文摘自CU社区，作者：mlsm，msn:mlsm@eyou.com,Email:kissma@gmail.com


环境:
windows2000 server+oracle9i+legato networker 7.2
networker  已经配置好了,测试备份普通文件没有问题,oracle通过rman 手工备份也没有问题,可是用自动策略备份就不行,大家帮忙看看,分析分析会是那里出了问题呀
rman备份脚本：(保存到:c:\a.txt文件了)
connect target sys/oracle@ora22;
connect catalog rman/rman@rcat;
run {
    allocate channel t1 type 'SBT_TPAE' -------->这里应该是 SBT_TAPE 吧？
    parms 'ENV=(NSR_SERVER=SERVER2000,
    NSR_DATA_VOLUME_POOL=Default)';
    allocate channel t2 type 'SBT_TPAE' ; -------->同上
    parms 'ENV=(NSR_SERVER=server2000,
    NSR_DATA_VOLUME_POOL=Defaul)';
    backup full filesperset 4
    format '/full_%s_%p_%u/' (database include current controlfile);
    release channel t1;
    release channel t2;
}

下面是备份的日志,
复制内容到剪贴板
代码:
二月 17 11:47:48 server2000: * cluster2:C:\a.txt savegrp: suppressed 256 lines of output -
二月 17 11:47:48 server2000: check daemon.log for details.
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM Default value: NONE
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM Description: This variable needs to be set if Oracle Net configuration
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM                         files are not located in default locations.
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM  
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>SET TNS_ADMIN=C:\oracle\ora92\network\admin
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM Execute the backup command
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>SET args=-s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt E:\>nsrnmostart -s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:47:48 server2000: * cluster2:C:\a.txt
二月 17 11:47:48 server2000: * cluster2:C:\a.txt RMAN script execution is not successful. RMAN exited with return code '3'.
二月 17 11:47:48 server2000: --- Successful Save Sets ---
二月 17 11:47:48 server2000:   server2000: index:cluster2        level=9,        14 KB 00:00:04     10 files
二月 17 11:47:48 server2000:   server2000: bootstrap             level=full,     82 KB 00:00:02     95 files
二月 17 11:47:48 server2000: * server2000:bootstrap nsrlpr: Either a printer isn't defined for printing the Bootstrap for this savegroup,
二月 17 11:47:48 server2000: * server2000:bootstrap or the '-PPRINTER' part of the notification resource is absent.
二月 17 11:47:48 server2000: * server2000:bootstrap Please correct as appropriate.
二月 17 11:47:48 server2000: * server2000:bootstrap printing bootstrap information failed (reproduced below).
二月 17 11:47:48 server2000: * server2000:bootstrap
二月 17 11:47:48 server2000: * server2000:bootstrap
二月 17 11:47:48 server2000: * server2000:bootstrap 二月 17 11:47 2006  server2000's bootstrap information Page 1
二月 17 11:47:48 server2000: * server2000:bootstrap
二月 17 11:47:48 server2000: * server2000:bootstrap      date     time      level ssid        file  record   volume
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-15 10:41:12   full 4226979016    14       0   server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-15 10:44:39   full 4193424791    16       0   server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-15 14:13:19   full 4159882879    18       0   server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-15 14:32:07   full 4126329575    20       0   server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-15 14:37:23   full 4092775459    22       0   server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-15 14:38:39   full 4059221103    24       0   server2000.001
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-17 10:11:02   full 4260704438 4260704438  0   server2000.002
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-17 10:33:23   full 4227151347 4227151347  0   server2000.002
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-17 10:51:39   full 4193598011 4193598011  0   server2000.002
二月 17 11:47:48 server2000: * server2000:bootstrap    2006-02-17 11:47:45   full 4109715297 4109715297  0   server2000.002
二月 17 11:54:28 server2000: NetWorker savegroup: (alert) Default completed, total 2 client(s), 0 Hostname(s) Unresolved, 1 Failed, 1 Succeeded. (cluster2 Failed)
二月 17 11:54:28 server2000: Start time:   Fri Feb 17 11:53:28 2006
二月 17 11:54:28 server2000: End time:     Fri Feb 17 11:54:28 2006
二月 17 11:54:28 server2000: --- Unsuccessful Save Sets ---
二月 17 11:54:28 server2000: * cluster2:C:\a.txt savegrp: suppressed 254 lines of output -
二月 17 11:54:28 server2000: check daemon.log for details.
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM Default value: NONE
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM Description: This variable needs to be set if Oracle Net configuration
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM                         files are not located in default locations.
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM  
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>SET TNS_ADMIN=C:\oracle\ora92\network\admin
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM Execute the backup command
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>REM
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>SET args=-s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt E:\>nsrnmostart -s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
二月 17 11:54:28 server2000: * cluster2:C:\a.txt
二月 17 11:54:28 server2000: * cluster2:C:\a.txt RMAN script execution is not successful. RMAN exited with return code '3'.
二月 17 11:54:28 server2000: --- Successful Save Sets ---
二月 17 11:54:28 server2000:   server2000: index:cluster2        level=9,        14 KB 00:00:01     10 files
二月 17 11:54:28 server2000:   server2000: bootstrap             level=full,     83 KB 00:00:01     95 files
二月 17 11:54:28 server2000: * server2000:bootstrap nsrlpr: Either a printer isn't defined for printing the Bootstrap for this savegroup,
二月 17 11:54:28 server2000: * server2000:bootstrap or the '-PPRINTER' part of the notification resource is absent.
二月 17 11:54:28 server2000: * server2000:bootstrap Please correct as appropriate.
二月 17 11:54:28 server2000: * server2000:bootstrap printing bootstrap information failed (reproduced below).
二月 17 11:54:28 server2000: * server2000:bootstrap
二月 17 11:54:28 server2000: * server2000:bootstrap
二月 17 11:54:28 server2000: * server2000:bootstrap 二月 17 11:54 2006  server2000's bootstrap information Page 1
二月 17 11:54:28 server2000: * server2000:bootstrap
二月 17 11:54:28 server2000: * server2000:bootstrap      date     time      level ssid        file  record   volume
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-15 10:41:12   full 4226979016    14       0   server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-15 10:44:39   full 4193424791    16       0   server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-15 14:13:19   full 4159882879    18       0   server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-15 14:32:07   full 4126329575    20       0   server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-15 14:37:23   full 4092775459    22       0   server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-15 14:38:39   full 4059221103    24       0   server2000.001
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-17 10:11:02   full 4260704438 4260704438  0   server2000.002
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-17 10:33:23   full 4227151347 4227151347  0   server2000.002
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-17 10:51:39   full 4193598011 4193598011  0   server2000.002
二月 17 11:54:28 server2000: * server2000:bootstrap    2006-02-17 11:47:45   full 4109715297 4109715297  0   server2000.002
...
daemon日志
复制内容到剪贴板
代码:
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM $Id: nsrnmo.bat,v 1.1.2.1 2004/07/13 13:54:20 kowens Exp $  Copyright (c) 2004, Legato Systems, Inc.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM All rights reserved.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM nsrnmo.bat
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM This script is part of the Legato NetWorker Module for Oracle.  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Modification of this script should be done with care and only after reading
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM the administration manual included with this product.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Users should be aware that no system environment variables will be
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM inherited from a parent process. Any environment variables to be used
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM in this file have to be set in this file.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM This script should only be run as part of a scheduled savegroup.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Returns 0 on success; 1 on failure.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Make environment variable changes local
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SETLOCAL
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Configuration variables, modifiable by users.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM REQUIRED Variable: ORACLE_HOME
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: none (site specific)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: Specifies where the Oracle Server installation is located.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 It is a requirement that rman or rman80 be located in
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 \bin.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Samples:  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET ORACLE_HOME=e:\orant
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET ORACLE_HOME=c:\oracle\ora92
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM REQUIRED Variable: PATH
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: none (site and platform specific)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: Set up the PATH environment variable. This must be
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 configured to include the path to "nsrnmostart".
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Samples:  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET PATH=e:\orant\bin;c:\win32app\nsr\bin
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET PATH=e:\orant\bin;c:\Program Files\nsr\bin
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET PATH=e:\orant\bin;c:\Program Files\Legato\nsr\bin
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET PATH=C:\oracle\ora92\bin;e:\Program Files\Legato\nsr\bin
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: ORACLE_SID
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: NONE (site specific)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: Specifies the SID of the Oracle database being backed up.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM It is a requirement that rman be located in ORACLE_HOME/bin.  It is
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM required by proxy copy backups when catalog synchronization is enabled.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Samples:
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM       ORACLE_SID=orcl901
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET ORACLE_SID=ora22
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: NSR_RMAN_ARGUMENTS
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: none (site specific)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: Provide extra rman parameters.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 You must enclose the command in quotes or it will not be  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 passed correctly to rman.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Samples:  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET NSR_RMAN_ARGUMENTS="nocatalog msglog 'c:\Program Files\Legato\nsr\applogs\msglog.log' append"
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET NSR_RMAN_ARGUMENTS="nocatalog"
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET NSR_RMAN_ARGUMENTS=msglog 'e:\Program Files\Legato\nsr\applogs\msglog.log' append
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: NSR_RMAN_OUTPUT
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: NONE (site specific)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: Provide option to capture the RMAN standard output
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                  if RMAN "msglog" or "log" command line option is
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 not set. The connect strings will be hidden in this file.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Samples:
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM               SET NSR_RMAN_OUTPUT="c:\Program Files\Legato\nsr\applogs\msglog.log append"
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM               SET NSR_RMAN_OUTPUT="c:\Program Files\Legato\nsr\applogs\msglog.log"
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET NSR_RMAN_OUTPUT=e:\Program Files\Legato\nsr\applogs\msglog.log append
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: NSR_SB_DEBUG_FILE
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: none (site specific)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: To enable debugging output for NMO scheduled backups set
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 the following to an appropriate path and file name.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 Set this variable for debugging purposes only  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Samples:
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 SET NSR_SB_DEBUG_FILE=c:\Program Files\Legato\nsr\applogs\nsrnmostart.log
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET NSR_SB_DEBUG_FILE=e:\Program Files\Legato\nsr\applogs\nsrnmostart.log
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: PRECMD
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: NONE
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: This variable can be used to run a command or command script
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 before nsrnmostart. It will be launched once for every saveset
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 entered in the client setup.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET PRECMD=
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: POSTCMD
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: NONE
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: This variable can be used to run a command or command script
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 after nsrnmostart has completed. It will be launched once for
02/17/06 11:54:23 savegrp: cluster2:C:\a.txt will retry 0 more time(s)
02/17/06 11:54:24 nsrd: server2000:index:cluster2 saving to pool 'Default' (server2000.002)
02/17/06 11:54:25 nsrd: server2000:index:cluster2 done saving to pool 'Default' (server2000.002) 14 KB
02/17/06 11:54:26 nsrd: server2000:bootstrap saving to pool 'Default' (server2000.002)
02/17/06 11:54:27 nsrmmdbd: media db is saving its data.  This may take a while.
02/17/06 11:54:27 nsrmmdbd: media db is open for business.
02/17/06 11:54:27 nsrd: server2000:bootstrap done saving to pool 'Default' (server2000.002) 82 KB
02/17/06 11:54:28 nsrd: savegroup info: Added 'server2000' to the group 'Default' for bootstrap backup.
02/17/06 11:54:28 nsrd: savegroup alert: Default completed, total 2 client(s), 0 Hostname(s) Unresolved, 1 Failed, 1 Succeeded. (cluster2 Failed)
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                 every saveset entered in the client setup.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET POSTCMD=
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Optional Variable: TNS_ADMIN
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Default value: NONE
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Description: This variable needs to be set if Oracle Net configuration
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM                         files are not located in default locations.
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM  
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET TNS_ADMIN=C:\oracle\ora92\network\admin
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM Execute the backup command
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>REM
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>SET args=-s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
* cluster2:C:\a.txt
* cluster2:C:\a.txt E:\>nsrnmostart -s server2000 -g Default -LL -m cluster2 -l full -q -W 78 -N "C:\a.txt" "C:\a.txt"
* cluster2:C:\a.txt
* cluster2:C:\a.txt RMAN script execution is not successful. RMAN exited with return code '3'.
02/17/06 11:54:28 nsrd: runq: NSR group Default exited with return code 1.
02/17/06 11:55:03 nsrd: write completion notice: Writing to volume server2000.002 complete
mlsm：可以备oracle 了,改了脚本,不过legato的文档上好像写的有问题呀
修改后的脚本:
connect target sys/oracle@ora22;
connect catalog rman/rman@rcat;
run {
    allocate channel t1 type 'SBT_TAPE';
    allocate channel t2 type 'SBT_TAPE';
    send 'NSR_ENV=(NSR_SERVER=server2000,
    NSR_DATA_VOLUME_POOL=Default)';
    backup full filesperset 4
    format '/full_%s_%p_%u/' (database include current controlfile);
    release channel t1;
    release channel t2;
}

client端的 msglog日志
复制内容到剪贴板
代码:
Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN> connect target sys/oracle@ora22;
2> connect catalog rman/rman@rcat;
3> run {
4>     allocate channel t1 type 'SBT_TAPE';
5>     allocate channel t2 type 'SBT_TAPE';
6>     send 'NSR_ENV=(NSR_SERVER=server2000,
7>     NSR_DATA_VOLUME_POOL=Default)';
8>     backup full filesperset 4
9>     format '/full_%s_%p_%u/' (database include current controlfile);
10>     release channel t1;
11>     release channel t2;
12> }
13>
connected to target database: ORA22 (DBID=4174030182)

connected to recovery catalog database

allocated channel: t1
channel t1: sid=16 devtype=SBT_TAPE
channel t1: NMO v4.2.0.0
sent command to channel: t1

allocated channel: t2
channel t2: sid=17 devtype=SBT_TAPE
channel t2: NMO v4.2.0.0
sent command to channel: t2

sent command to channel: t1
sent command to channel: t2

Starting backup at 19-FEB-06
channel t1: starting full datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=C:\ORACLE\ORADATA\ORA22\EXAMPLE01.DBF
input datafile fno=00010 name=C:\ORACLE\ORADATA\ORA22\XDB01.DBF
input datafile fno=00006 name=C:\ORACLE\ORADATA\ORA22\INDX01.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\ORA22\CWMLITE01.DBF
channel t1: starting piece 1 at 19-FEB-06
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00002 name=C:\ORACLE\ORADATA\ORA22\UNDOTBS01.DBF
input datafile fno=00009 name=C:\ORACLE\ORADATA\ORA22\USERS01.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\ORA22\DRSYS01.DBF
input datafile fno=00007 name=C:\ORACLE\ORADATA\ORA22\ODM01.DBF
channel t2: starting piece 1 at 19-FEB-06
channel t2: finished piece 1 at 19-FEB-06
piece handle=/full_11_1_0bhbq6mu/ comment=API Version 2.0,MMS Version 4.2.0.0
channel t2: backup set complete, elapsed time: 00:00:56
channel t2: starting full datafile backupset
channel t2: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\ORA22\SYSTEM01.DBF
input datafile fno=00008 name=C:\ORACLE\ORADATA\ORA22\TOOLS01.DBF
channel t2: starting piece 1 at 19-FEB-06
channel t1: finished piece 1 at 19-FEB-06
piece handle=/full_10_1_0ahbq6mt/ comment=API Version 2.0,MMS Version 4.2.0.0
channel t1: backup set complete, elapsed time: 00:01:02
channel t2: finished piece 1 at 19-FEB-06
piece handle=/full_12_1_0chbq6om/ comment=API Version 2.0,MMS Version 4.2.0.0
channel t2: backup set complete, elapsed time: 00:03:20
Finished backup at 19-FEB-06

released channel: t1

released channel: t2

Recovery Manager complete.
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
现在单独备archive log日志出问题,帮忙看看是那里出了问题,脚本改了好几次也不行
备份脚本:
connect target sys/oracle@ora22;
connect catalog rman/rman@rcat;

run {
     allocate channel t1 type 'SBT_TYPE';
     allocate channel t2 type 'SBT_TYPE';
     send 'NSR_ENV=(NSR_SERVER=server2000,
     NSR_DATA_VOLUME_POOL=Default)';
     sql 'alter system switch logfile';
     backup filesperset 4
     format 'archive_%s_%p_%u'
     archivelog all delete input;
   
     release t1;
     release t2;
}

client 端msglog日志:

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN>
RMAN> connect target sys/oracle@ora22;
2> connect catalog rman/rman@rcat;
3>
4> run {
5>      allocate channel t1 type 'SBT_TYPE';
6>      allocate channel t2 type 'SBT_TYPE';
7>      send 'NSR_ENV=(NSR_SERVER=server2000,
8>      NSR_DATA_VOLUME_POOL=Default)';
9>      sql 'alter system switch logfile';
10>      backup filesperset 4
11>      format 'archive_%s_%p_%u'
12>      archivelog all delete input;
13>     
14>      release t1;  -------->release channel t1;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "channel"
RMAN-01008: the bad identifier was: t1
RMAN-01007: at line 15 column 9 file: C:\b.txt
RMAN> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>

mlsm：legato 的networker只有nsrnmo的脚本,没有rman备份oracle的脚本呀,只有自已写呀,有脚本就省事多了,不过这个只要对oracle的rman有的点了解看看其它的脚本慢慢试就行了,重要的是要细心呀,像我有点马虎了.

mlsm：再请教恢复的问题,用legato备份了oracle,不能用legato恢复呀, 只能用rman自身恢呀,那个nsrnmoinfo的命令里提到的备份片在那个文件里能找到呀,怎么使用呀?

进入偶的Blog妈妈说，不要和不在Space开博客的人说话，他们是坏蛋。

TOP

angle

神功盖世

Rank: 8Rank: 8

超级无敌存储大菜鸟

帖子
1311 
精华
10 
积分
18136 
金币
839  
2# 大 中 小 发表于 2006-2-22 14:11  只看该作者
奇怪了，怎么没人反应？

进入偶的Blog妈妈说，不要和不在Space开博客的人说话，他们是坏蛋。

TOP

存储之家

小有成就

Rank: 3Rank: 3Rank: 3

帖子
54 
精华
0 
积分
498 
金币
0  
3# 大 中 小 发表于 2006-7-17 16:11  只看该作者
我支持你,我不是很懂

TOP

clarcli

稳扎稳打

Rank: 4

帖子
122 
精华
1 
积分
1403 
金币
29  
4# 大 中 小 发表于 2006-8-4 20:41  只看该作者
太大意了，我也在研究。

TOP

clarcli

稳扎稳打

Rank: 4

帖子
122 
精华
1 
积分
1403 
金币
29  
5# 大 中 小 发表于 2006-8-14 14:26  只看该作者
如何备份控制文件？这样在oracle服务器宕机，重新安装系统之后，能否恢复？rman能否list backup？

[ 本帖最后由 clarcli 于 2006-8-14 14:32 编辑 ]

TOP

clarcli

稳扎稳打

Rank: 4

帖子
122 
精华
1 
积分
1403 
金币
29  
6# 大 中 小 发表于 2006-8-15 13:42  只看该作者
没有以文件级的方式单独备份控制文件安全不？

TOP

aaron_pc

拜师学艺

Rank: 1

帖子
3 
精华
0 
积分
39 
金币
0  
7# 大 中 小 发表于 2007-6-3 21:48  只看该作者
我们公司用的LEGATO 的CO-STANDBY软件做ORACLE的热备

TOP

‹‹ 上一主题 | 下一主题 ››
发新话题