求RMAN数据文件备份的教本？

bingcha320

为什么备份和镜像拷贝在我的库里都不行呢？
RMAN>  run{
2>  allocate channel dev1 type disk;
3> copy datafile '/rdbm/orasrv/user_tbs/tbs_fyfy.dbf' to '/rdbm/orasrv/tbs_fyfy
4> .bak';
5> }

分配的通道: dev1
通道 dev1: sid=17 devtype=DISK

启动 copy 于 03-2月 -05
释放的通道: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of copy command at 02/03/2005 11:03:36
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target data
base incarnation not found in recovery catalog。

为什么在我的库里，backup和copy都不行呢？高手指点啊！

bingcha320

很是疑惑，自己顶吧!

bingcha320

在RMAN 库中执行了reset database命令后，备份数据文件的教本已经可以运行，但恢复的时候又报错，这是语法错误么？
RMAN>  run{
2>  allocate channel dev1 type disk;
3> sql "alter database datafile '/rdbm/orasrv/user_tbs/tbs_fyfy.dbf' offline";
4>  restore datafile '/rdbm/orasrv/user_tbs/tbs_fyfy.dbf';
5>  recover datafile '/rdbm/orasrv/user_tbs/tbs_fyfy.dbf';
6> sql "alter database datafile '/rdbm/orasrv/user_tbs/tbs_fyfy.dbf' online";
7> release channel dev1;}

分配的通道: dev1
通道 dev1: sid=15 devtype=DISK

sql 语句: alter database datafile '/rdbm/orasrv/user_tbs/tbs_fyfy.dbf' offline
释放的通道: dev1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 02/03/2005 16:30:49
RMAN-10015: error compiling PL/SQL program
RMAN-10014: PL/SQL error 103 on line 4 column 67: 出现符号 " offline"在需要下列
之一时：
. ( ) , * @ % & = - +
   < / > at in is mod not rem <an exponent (**)> <> or != or ~=
   >= <= <> and or like between ||
符号 "." 被替换为 " offline" 后继续。