用RMAN能否实现定时备份?

anchen211

最初由 mugen 发布
[B]我现在做的就是每周日晚上23点做一次rman的全备份 [/B]

这位老兄,能否把你的脚本共享一下呀?

anchen211

最初由 NinGoo 发布
[B]# script:bakup.rcv
# creater:chenjiping
# date:5.8.2003
# desc:backup all database datafile in archive with rman

# connect database
connect rcvcat rman/rman@back;
connect target internal/virpure;

# start backup database
run{
allocate channel c1 type disk;
backup full tag 'dbfull' format 'd:\backup\full%u_%s_%p' database
include current controlfile;
sql 'alter system archive log current';
release channel c1;
}
# end [/B]

这是我的脚本:
# connect database
connect catalog rman/rman;
connect target sys/123456@cfmc;

# start backup database
run
{
allocate channel t1 type disk;
allocate channel t2 type disk;
backup
filesperset=20
format='/ora8/m01/app/oracle/oradatabak/archbak/al_%d_%t_%s_%p'
(archivelog like '/ora8/m01/app/oracle/admin/cfmc/arch/%' channel t1 delete input)
(archivelog like '/orabak/arch/%' channel t2 delete input);
}
sh /scripts/ftparch.sh

这是报的错:
[root@localhost scripts]# sh archbackup.sh
archbackup.sh: line 8: connect: command not found
archbackup.sh: line 9: connect: command not found
archbackup.sh: line 12: run: command not found
archbackup.sh: line 14: allocate: command not found
archbackup.sh: line 15: allocate: command not found
archbackup.sh: line 16: backup: command not found
archbackup.sh: line 19: archivelog: command not found
archbackup.sh: line 20: archivelog: command not found

xzh2000

你牛,在ROOT下运行,你要在ORACLE用户下运行。

xzh2000

#
# must by run in oracle env....
#
. .bash_profile

$ORACLE_HOME/bin/rman catalog rman/rman target sys/123456@cfmc;

# start backup database
run
{
allocate channel t1 type disk;
allocate channel t2 type disk;
backup
filesperset=20
format='/ora8/m01/app/oracle/oradatabak/archbak/al_%d_%t_%s_%p'
(archivelog like '/ora8/m01/app/oracle/admin/cfmc/arch/%' channel t1 delete input)
(archivelog like '/orabak/arch/%' channel t2 delete input);
}

anchen211

最初由 xzh2000 发布
[B]你牛,在ROOT下运行,你要在ORACLE用户下运行。 [/B]

请看报错:
[oracle@localhost scripts]$ su - oracle
Password:
[oracle@localhost oracle]$ sh /scripts/archbackup.sh
/scripts/archbackup.sh: line 8: connect: command not found
/scripts/archbackup.sh: line 9: connect: command not found
/scripts/archbackup.sh: line 12: run: command not found
/scripts/archbackup.sh: line 14: allocate: command not found
/scripts/archbackup.sh: line 15: allocate: command not found
/scripts/archbackup.sh: line 16: backup: command not found
/scripts/archbackup.sh: line 19: archivelog: command not found
/scripts/archbackup.sh: line 20: archivelog: command not found
[oracle@localhost oracle]$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR>

anchen211

是要ORACLE_HOME下在.bash_profile中加入这句话吗?
$ORACLE_HOME/bin/rman catalog rman/rman target sys/123456@cfmc;

xzh2000

你运行偶给你改后的那部分。

xzh2000

最初由 anchen211 发布
[B]是要ORACLE_HOME下在.bash_profile中加入这句话吗?
$ORACLE_HOME/bin/rman catalog rman/rman target sys/123456@cfmc; [/B]

不是。

xzh2000

$more test.sh
#!/bin/bash
$ORACLE_HOME/bin/rman catalog rman/rman target sys/123456@cfmc;

# start backup database
run
{
allocate channel t1 type disk;
allocate channel t2 type disk;
backup
filesperset=20
format='/ora8/m01/app/oracle/oradatabak/archbak/al_%d_%t_%s_%p'
(archivelog like '/ora8/m01/app/oracle/admin/cfmc/arch/%' channel t1 delete input)
(archivelog like '/orabak/arch/%' channel t2 delete input);
}

anchen211

最初由 xzh2000 发布
[B]$more test.sh
#!/bin/bash
$ORACLE_HOME/bin/rman catalog rman/rman target sys/123456@cfmc;

# start backup database
run
{
allocate channel t1 type disk;
allocate channel t2 type disk;
backup
filesperset=20
format='/ora8/m01/app/oracle/oradatabak/archbak/al_%d_%t_%s_%p'
(archivelog like '/ora8/m01/app/oracle/admin/cfmc/arch/%' channel t1 delete input)
(archivelog like '/orabak/arch/%' channel t2 delete input);
} [/B]

我执行您以上的脚本,结果如下:
[oracle@localhost oracle]$ sh /scripts/archbackup.sh
/scripts/archbackup.sh: line 11: test.sh: command not found

Recovery Manager: Release 8.1.7.0.1 - Production

RMAN-06005: connected to target database: CFMC (DBID=1791010199)
RMAN-06008: connected to recovery catalog database

RMAN>

就停在这不动了,我看了看备份的目的地,也没有新备份的文件呀.