rman脚本中参数问题

与晶之恋

想使用脚本自动恢复控制文件.但是rman怎么都使用不了shell中的参数，请问下哪里有问题了？

10g的rman确实不具备传递参数的功能.还有没有其他办法去使用变量？
http://blog.ronnyegner-consulting.de/2010/08/02/rman-and-variables/

oracle： 10.2.0.5.0
环境：hpux 11.31


两个脚本如下
oracle@nms[/rman/shell]$vi ctlbak.sh
#! /bin/sh
connect target /
run{
restore controlfile from '/rman/&1';
}

oracle@nms[/rman/shell]$vi ctl.sh
export ORACLE_SID=nmdb
$ORACLE_HOME/bin/rman <<EOF
@/rman/shell/ctlbak.sh "cf_c-2883472017-20131111-05"
EOF



文件路径是对的
oracle@nms[/rman]$ll
total 278032
-rw-r----- 1 oracle dba  14352384 2013-11-10 23:18 cf_c-2883472017-20131110-02
-rw-r----- 1 oracle dba  14352384 2013-11-11 00:40 cf_c-2883472017-20131111-03
-rw-r----- 1 oracle dba  14352384 2013-11-11 00:41 cf_c-2883472017-20131111-04
-rw-r----- 1 oracle dba  14647296 2013-11-11 11:56 cf_c-2883472017-20131111-05

Maclean Liu(刘相兵

具体运行了报什么错 总要说一下吧？

Maclean Liu(刘相兵

给一个例子

Example 2-128 Specifying Substitution Variables

Suppose that you want to create a Linux shell script that backs up the database. You want to use shell variables so that you can pass arguments to the RMAN backup script at run time. Substitution variables solve this problem. First, you create a command file named whole_db.cmd with the following contents:

cat > /tmp/whole_db.cmd <<EOF
# name: whole_db.cmd
CONNECT TARGET /
BACKUP TAG &1 COPIES &2 DATABASE FORMAT '/disk2/db_%U';
EXIT;
EOF
Next, you write the following Linux shell script, which sets csh shell variables tagname and copies. The shell script starts RMAN, connects to target database prod1, and runs whole_db.cmd. The USING clause passes the values in the variables tagname and copies to the RMAN command file at execution time.

#!/bin/csh
# name: runbackup.sh
# usage: use the tag name and number of copies as arguments
set tagname = $argv[1]
set copies = $argv[2]
rman @'/tmp/whole_db.cmd' USING $tagname $copies LOG /tmp/runbackup.out
# note that the preceding line is equivalent to:
# rman @'/tmp/whole_db.cmd' $tagname $copies LOG /tmp/runbackup.out
Finally, you execute the shell script runbackup.sh from a Linux shell as follows to create two backups of the database with the tag Q106:

与晶之恋

Maclean Liu(刘相兵 发表于 2013-11-11 23:47
具体运行了报什么错 总要说一下吧？

sorry 报错信息如下，

oracle@nms[/rman/shell]$./ctl.sh

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Nov 11 16:51:56 2013

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

RMAN>
RMAN> #! /bin/sh
2> connect target *
connected to target database: nmdb (not mounted)

RMAN> run{
2> restore controlfile from '/rman/&1';
3> }
Starting restore at 11-NOV-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1091 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/11/2013 16:51:57
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> **end-of-file**

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "double-quoted-string": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 0 column 2 file: standard input

RMAN>

Recovery Manager complete.
oracle@nms[/rman/shell]$

Maclean Liu(刘相兵

去掉双引号试试 "cf_c-2883472017-20131111-05"， 或者这个并非有效的 控制文件备份

与晶之恋

Maclean Liu(刘相兵 发表于 2013-11-11 23:58
去掉双引号试试 "cf_c-2883472017-20131111-05"， 或者这个并非有效的 控制文件备份 ...

试过，去掉后的报错，
oracle@nms[/rman/shell]$./ctl.sh

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Nov 11 17:00:06 2013

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

RMAN>
RMAN> #! /bin/sh
2> connect target *
connected to target database: nmdb (not mounted)

RMAN> run{
2> restore controlfile from '/rman/&1';
3> }
Starting restore at 11-NOV-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1094 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/11/2013 17:00:07
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN> **end-of-file**

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01008: the bad identifier was: cf_c
RMAN-01007: at line 0 column 2 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol "-"

RMAN>

Recovery Manager complete.
oracle@nms[/rman/shell]$

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
控制文件备份是有效的
oracle@nms[/rman/shell]$rman target /

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Nov 11 17:02:45 2013

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

connected to target database: nmdb (not mounted)

RMAN> restore controlfile from '/rman/cf_c-2883472017-20131111-05';

Starting restore at 11-NOV-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1094 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/oracle/oradata/nmdb/ctl/control01.ctl
output filename=/oracle/oradata/nmdb/ctl/control02.ctl
output filename=/oracle/oradata/nmdb/ctl/control03.ctl
Finished restore at 11-NOV-13

Maclean Liu(刘相兵

1、cat ctl.sh

2、 对于autobackup 如果没特殊要求 ， 其实可以不指定文件名，当然有前提

3、 毫无疑问是低级错误， 目前没有 时间帮你测

与晶之恋

1.
oracle@nms[/rman/shell]$cat ctl.sh
export ORACLE_SID=nmdb
$ORACLE_HOME/bin/rman <<EOF
@/rman/shell/ctlbak.sh cf_c-2883472017-20131111-05
EOF

自动恢复不是自动备份.需要恢复一个最新的备份文件.这不是完整的脚本，挑出这段有问题来专门测试的.

我对了你之前文章的格式来的，看报错就是参数传不进去不然就是传进去因为符号之类的原因表达错误了.但是找不出来为啥.http://www.askmaclean.com/archives/%E4%BD%BF%E7%94%A8oracle-rman%E8%84%9A%E6%9C%AC.html

kevinlin.ora

test on:Vbox linux 32bit oracle 11.2.0.3
变量需要加单引号

1. 
   
2. [oracle@localhost ~]$ cat ctlbak.rman
   
3. connect target /
   
4. run{
   
5. restore controlfile from '/oracle/product/dbs/&1';
   
6. }
   
7. [oracle@localhost ~]$ cat ctl.sh
   
8. export ORACLE_SID=nmdb
   
9. $ORACLE_HOME/bin/rman <<EOF
   
10. @ctlbak.rman 'c-4173336992-20131112-00'
    
11. EOF
    
12. 
    
13. 
    
14. [oracle@localhost ~]$ ./ctl.sh
    
15. 
    
16. Recovery Manager: Release 11.2.0.3.0 - Production on Tue Nov 12 14:54:24 2013
    
17. 
    
18. Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
    
19. 
    
20. RMAN>
    
21. 
    
22. RMAN> connect target *
    
23. connected to target database: NMDB (not mounted)
    
24. 
    
25. RMAN> run{
    
26. 2> restore controlfile from '/oracle/product/dbs/c-4173336992-20131112-00';
    
27. 3> }
    
28. Starting restore at 12-NOV-13
    
29. using target database control file instead of recovery catalog
    
30. allocated channel: ORA_DISK_1
    
31. channel ORA_DISK_1: SID=20 device type=DISK
    
32. 
    
33. channel ORA_DISK_1: restoring control file
    
34. channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
    
35. output file name=/oracle/oradata/nmdb/control01.ctl
    
36. Finished restore at 12-NOV-13
    
37. 
    
38. RMAN> **end-of-file**
    
39. 
    
40. RMAN>
    
41. 
    
42. Recovery Manager complete.
    

复制代码

与晶之恋

kevinlin.ora 发表于 2013-11-12 14:59
test on:Vbox linux 32bit oracle 11.2.0.3
变量需要加单引号

谢谢，难打版本不一样么？我之前就试过单引号的.一样传递不进去.

与晶之恋

kevinlin.ora 发表于 2013-11-12 14:59
test on:Vbox linux 32bit oracle 11.2.0.3
变量需要加单引号

真心感谢你还专程搭了实例才测试.
oracle@nms[/rman/shell]$cat ctl.sh
export ORACLE_SID=nmdb
$ORACLE_HOME/bin/rman <<EOF
@/rman/shell/ctlbak.sh 'cf_c-2883472017-20131111-05'
EOF

oracle@nms[/rman/shell]$cat ctlbak.sh
#! /bin/sh
connect target /
run{
restore controlfile from '/rman/&1';
}

1. 
   
2. Recovery Manager: Release 10.2.0.5.0 - Production on Tue Nov 12 11:03:01 2013
   
3. 
   
4. Copyright (c) 1982, 2007, Oracle.  All rights reserved.
   
5. 
   
6. RMAN>
   
7. RMAN> #! /bin/sh
   
8. 2> connect target *
   
9. connected to target database: nmdb (not mounted)
   
10. 
    
11. RMAN> run{
    
12. 2> restore controlfile from '/rman/&1';
    
13. 3> }
    
14. Starting restore at 12-NOV-13
    
15. using target database control file instead of recovery catalog
    
16. allocated channel: ORA_DISK_1
    
17. channel ORA_DISK_1: sid=1094 devtype=DISK
    
18. 
    
19. RMAN-00571: ===========================================================
    
20. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
21. RMAN-00571: ===========================================================
    
22. RMAN-03002: failure of restore command at 11/12/2013 11:03:01
    
23. RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
    
24. 
    
25. RMAN> **end-of-file**
    
26. 
    
27. RMAN-00571: ===========================================================
    
28. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
29. RMAN-00571: ===========================================================
    
30. RMAN-00558: error encountered while parsing input commands
    
31. RMAN-01009: syntax error: found "single-quoted-string": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
    
32. RMAN-01007: at line 0 column 2 file: standard input
    
33. 
    
34. RMAN>
    
35. 
    
36. Recovery Manager complete.

复制代码

Maclean Liu(刘相兵

11.2
[oracle@mlab2 ~]$ cat ctl.sh
#!/bin/bash
export ORACLE_SID=G11R204
export ORACLE_HOME=/s01/oracle/app/oracle/product/11.2.0.4/dbhome_1
$ORACLE_HOME/bin/rman  cmdfile='/home/oracle/ctlbak.cmd' 'maclean'

[oracle@mlab2 ~]$ cat ctlbak.cmd

connect target /
run{
restore controlfile from  '/s01/fast_recovery_area/G11R204/backupset/2013_11_12/&1.bkp';
}


[oracle@mlab2 ~]$ ./ctl.sh

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Nov 12 08:50:30 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN>
RMAN> connect target *
2> run{
3> restore controlfile from  '/s01/fast_recovery_area/G11R204/backupset/2013_11_12/macleanbkp';
4> }
5>
6>
connected to target database: G11R204 (DBID=2438469611)

Starting restore at 12-NOV-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11 device type=DISK

Maclean Liu(刘相兵

结论 ： 10.2 当路径中存在SHELL输入变量时可能存在问题

workaround:使用 restore controlfile from autobackup;

与晶之恋

Maclean Liu(刘相兵 发表于 2013-11-11 23:47
具体运行了报什么错 总要说一下吧？

额，10g的rman确实没有传递参数的功能,还有其他的办法么？是在是需要制定控制文件的文件名去恢复最新的控制文件
http://blog.ronnyegner-consulting.de/2010/08/02/rman-and-variables/

Maclean Liu(刘相兵

为什么不能用restore controlfile from autobackup;?

与晶之恋

Maclean Liu(刘相兵 发表于 2013-11-12 22:12
为什么不能用restore controlfile from autobackup;?

备份文件是从异地复制过来了，restore controlfile from autobackup;可以识别到和恢复么？

Maclean Liu(刘相兵

当然可以

与晶之恋

Maclean Liu(刘相兵 发表于 2013-11-12 22:19
当然可以

谢谢 尝试了可以.问题解决了.