oracle11g备份脚本,oracle11G的全库备份脚本,求指教

鄙人脚本如下:

# script.:BackFull.sh

# creater:zhangzehui

# date:2013/8/21

# desc:backup full database datafile in archive with rman

# connect database

export ORACLE_BASE=/home/oracle/app

export ORACLE_HOME=$ORACLE_BASE/oracle/product/11.2.0/dbhome_1

export ORACLE_SID=orcl

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

rman  target/ << EOF_RMAN

run{

allocate channel cl type disk;

backup incremental level 0 tag 'db0' format

'/home/oracle/app/RmanBackup/db0_%d_%T_%s' database include current controlfile;

delect noprompt obsolete;

release channel c1;

}

# end

报错如下:

./BackupFull.sh: line 18: warning: here-document at line 10 delimited by end-of-file (wanted `EOF_RMAN')

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Aug 21 19:31:24 2013

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

connected to target database: ORCL (DBID=1350755061)

RMAN> 2> 3> 4> 5>

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: "advise, allocate, alter, backup, @, catalog, change, configure, convert, copy, crosscheck, delete, duplicate, execute, flashback, host, mount, open, recover, release, repair, report, restore, resync, send, set, show, shutdown, sql, startup, switch, transport, validate, }"

RMAN-01008: the bad identifier was: delect

RMAN-01007: at line 5 column 1 file: standard input

RMAN>

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: ";"

RMAN-01008: the bad identifier was: c1

RMAN-01007: at line 1 column 17 file: standard input

RMAN>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found "}": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "

RMAN-01007: at line 1 column 1 file: standard input

RMAN> 2>

Recovery Manager complete.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值