请求帮助，oracle 数据库做rman 备份时，备份的数据不完整。
OS: 5300-09oracle版本: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
架构： oracle RAC
问题：oracle 数据库做rman 在线备份时，备份前面几个数据文件后，自动断开，没完整备份完数据。
rman 脚本：
connect target /
run {
ALLOCATE CHANNEL t1 DEVICE TYPE DISK;
ALLOCATE CHANNEL t2 DEVICE TYPE DISK;
backup
incremental level 0
TAG 'HOT_DB_LEVEL0'
FILESPERSET 4
FORMAT '/data/olddump/DB_%d_s%s_p%p_t%t'
DATABASE;
RELEASE CHANNEL t1;
RELEASE CHANNEL t2;
ALLOCATE CHANNEL c1 DEVICE TYPE DISK CONNECT 'sys/oracletg@DB01';
ALLOCATE CHANNEL c2 DEVICE TYPE DISK CONNECT 'sys/oracletg@DB02';
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT '/data/olddump/archal_%s_%p_%t'
ARCHIVELOG ALL;
RELEASE CHANNEL c1;
RELEASE CHANNEL c2;
ALLOCATE CHANNEL ch00 TYPE DISK;
BACKUP
FORMAT '/data/olddump/cn_%d_s%s_t%t_p%p'
CURRENT CONTROLFILE;
RELEASE CHANNEL ch00;
}
rman备份产生日志:
connected to target database: OA (DBID=3112272670)
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=2148 instance=oa1 devtype=DISK
allocated channel: t2
channel t2: sid=2161 instance=oa1 devtype=DISK
Starting backup at 2014-03-14:11:42:44
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00029 name=/dev/roa_tdocattach15
input datafile fno=00078 name=/dev/roa_tdocattach57
input datafile fno=00127 name=/dev/roa_tdocattach96
input datafile fno=00156 name=/dev/roa_attach117
channel t1: starting piece 1 at 2014-03-14:11:42:46
channel t2: starting incremental level 0 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00030 name=/dev/roa_tdocattach16
input datafile fno=00079 name=/dev/roa_oadata06
input datafile fno=00128 name=/dev/roa_tdocattach97
input datafile fno=00157 name=/dev/roa_attach118
channel t2: starting piece 1 at 2014-03-14:11:42:47
Fri Mar 14 12:00:52 BEIST 2014 ----------------End of Script------------------
exit 129
数据库和数据文件共178个，只备了8个就停止了退出了。
一种可能是 报错的日志没有正常输出
一种是你的数据库的状态存疑 我查一下数据库状态都是正常的
SQL> select OPEN_MODE from v$database;
OPEN_MODE
----------
READ WRITE
SQL> select status from v$instance;
STATUS
------------
OPEN 光看一个 read write + open可不代表什么 正常 请教一下刘老师，怎样去判断数据库的运行是否正常？ 你重新备份 一下 脚本里加上debug on;
生成的log 上传 刘老师，我前几天出差了，今天才重新做调度，上传日志，请帮忙分析一下，谢谢。
页:
[1]