Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

1

好友

5

主题
1#
发表于 2017-8-28 17:32:22 | 查看: 8722| 回复: 0
本帖最后由 chen1999 于 2017-8-28 17:44 编辑

linux平台的oracle 12.2 做RMAN全备,平台挂载了一个windows的CIFS文件,作为备份目录。备份目录的用户组是 oracle oinstall

RMAN备份日志:
RMAN-03009: failure of backup command on c2 channel at 08/28/2017 08:48:34
ORA-19510: failed to set size of 7185353 blocks for file "/rman/JXCDB/20170828/arch_JXCDB_20170828_26_0qsd17q3_1_1" (block size=512)
ORA-27045: unable to close the file
Linux-x86_64 Error: 5: Input/output error
Additional information: 4
channel c2 disabled, job failed on it will be run on another channel

rman 备份脚本:
rman target / msglog=/rman/JXCDB/20170828/bak_20170828.log

run{
allocate channel c1  DEVICE TYPE DISK MAXPIECESIZE=10240m rate 50M;
allocate channel c2  DEVICE TYPE DISK MAXPIECESIZE=10240m rate 50M;
allocate channel c3  DEVICE TYPE DISK MAXPIECESIZE=10240m rate 50M;
backup full database include current controlfile tag 'dbk_level_0' format '/rman/JXCDB/20170828/df_level_0_%d_%T_%s_%U'  plus archivelog format '/rman/JXCDB/20170828/arch_%d_%T_%s_%U';

sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
sql 'alter system archive log current';
backup filesperset 3 format '/rman/JXCDB/20170828/arch_level_0_%d_%T_%s_%U' archivelog all delete input;
release channel c1;
release channel c2;
release channel c3;
}
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-2 23:24 , Processed in 0.046592 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569