浏览
帮助
登录
未解决
此帖子已超过 5 年
wangjgh
3 消息
0
2050
2013年11月30日 01:00
Redhat Linux下oracle RAC备份数据和归档均备份到一半报错,如附件求指导
1个附件
oracle - 副本.log
回复(6)
born_chen
1.8K 消息
2013年11月30日 06:00
看上去像是权限问题。脚本的账户权限赋予了么?
Permission denied, user 'oracle' on 'erpdb2-vip' does not have 'Operate NetWorker' OR 'Change Application Settings' privilege to perform this operation- NSR.
liulei_it
2 Intern
•
3.2K 消息
2013年11月30日 08:00
# oerr ora 27192
27192, 00000, "skgfcls: sbtclose2 returned error - failed to close file"
// *Cause: sbtclose2 returned an error. This happens while closing a backup
// file during a backup or restore operation.
// *Action: This error is returned from the media management software which is
// linked with Oracle. There should be additional messages which
// explain the cause of the error. This error usually requires
// contacting the media management vendor.
# oerr ora 19511
19511, 00000, "Error received from media manager layer, error text:\n %s"
// *Cause: An error occurred in the media management software which
// is linked with the Oracle server to perform backup and restore
// in cooperation with Recovery Manager.
// *Action: If the text of message 19511 does not provide enough
// information to resolve the problem, then you should contact the
// vendor of the media management software.
# oerr ora 19506
19506, 00000, "failed to create sequential file, name=\"%s\", parms=\"%s\""
// *Cause: call to create the sequential file returned an error
// *Action: check additional messages, check access permissions
# oerr ora 27028
27028, 00000, "skgfqcre: sbtbackup returned error"
// *Cause: sbtbackup returned an error. This happens when creating a backup
// file during a backup operation.
# oerr ora 19566
19566, 00000, "exceeded limit of %s corrupt blocks for file %s"
// *Cause: The user specified limit of allowable corrupt blocks was exceeded
// while reading the specified datafile for a datafile copy or backup.
// *Action: None. The copy or backup operation fails.
// The session trace file contains detailed information
// about which blocks were corrupt.
查看/dev/raw/raw1这个是不是对于networker所在的节点的权限是不是正确或者所有的节点有没有许可。
2013年11月30日 18:00
我的备份存储池是昆腾的物理带库,也尝试了往备份服务器的本地磁盘备份,问题依旧.....
2个节点的归档日志备份没有问题,但是2个节点的数据文件备份都会出现附件问题,备份用户的权限是够的啊
2013年11月30日 22:00
同一个在存储上的数据文件都要被两个节点共同访问,至于归当日志是跟随instance也就是节点走的,除非您的归档日志也是放到存储中给所有节点共享。简单一点就是说,例如你的数据库只有一个数据文件,那么两个或者多个节点的Instance都要能正确识别这个数据文件才能让这两个节点的instance同时对这个数据文件进行读写操作,否则的话就不是RAC这种share everything结构了。
至于归档日志那么是随着instance的节点走的,你有两个节点,那么同一个数据库就有可能有两份分别放在不同节点的本地硬盘上的归档日志,这个RAC环境有几个节点就有几份归档日志。所以说您反映的对归档日志文件应该是房子Local节点的本地硬盘上的而不是共享存储上的。而数据文件是需要被所有节点共同正确访问的。让您的DBA和您一起检查一下对于共享存储的权限问题
o17Uu33DCF12520
1.1K 消息
2013年12月2日 00:00
添加oracle帐号管理networker的权限看看,
nsraddadmin -u oracle@
>
免费订阅论坛每月简报请点击
戴尔支持资源
查看更多
查看全部
Top
born_chen
1.8K 消息
0
2013年11月30日 06:00
看上去像是权限问题。脚本的账户权限赋予了么?
Permission denied, user 'oracle' on 'erpdb2-vip' does not have 'Operate NetWorker' OR 'Change Application Settings' privilege to perform this operation- NSR.
liulei_it
2 Intern
2 Intern
•
3.2K 消息
0
2013年11月30日 08:00
# oerr ora 27192
27192, 00000, "skgfcls: sbtclose2 returned error - failed to close file"
// *Cause: sbtclose2 returned an error. This happens while closing a backup
// file during a backup or restore operation.
// *Action: This error is returned from the media management software which is
// linked with Oracle. There should be additional messages which
// explain the cause of the error. This error usually requires
// contacting the media management vendor.
# oerr ora 19511
19511, 00000, "Error received from media manager layer, error text:\n %s"
// *Cause: An error occurred in the media management software which
// is linked with the Oracle server to perform backup and restore
// in cooperation with Recovery Manager.
// *Action: If the text of message 19511 does not provide enough
// information to resolve the problem, then you should contact the
// vendor of the media management software.
# oerr ora 19506
19506, 00000, "failed to create sequential file, name=\"%s\", parms=\"%s\""
// *Cause: call to create the sequential file returned an error
// *Action: check additional messages, check access permissions
# oerr ora 27028
27028, 00000, "skgfqcre: sbtbackup returned error"
// *Cause: sbtbackup returned an error. This happens when creating a backup
// file during a backup operation.
// *Action: This error is returned from the media management software which is
// linked with Oracle. There should be additional messages which
// explain the cause of the error. This error usually requires
// contacting the media management vendor.
# oerr ora 19511
19511, 00000, "Error received from media manager layer, error text:\n %s"
// *Cause: An error occurred in the media management software which
// is linked with the Oracle server to perform backup and restore
// in cooperation with Recovery Manager.
// *Action: If the text of message 19511 does not provide enough
// information to resolve the problem, then you should contact the
// vendor of the media management software.
# oerr ora 19566
19566, 00000, "exceeded limit of %s corrupt blocks for file %s"
// *Cause: The user specified limit of allowable corrupt blocks was exceeded
// while reading the specified datafile for a datafile copy or backup.
// *Action: None. The copy or backup operation fails.
// The session trace file contains detailed information
// about which blocks were corrupt.
查看/dev/raw/raw1这个是不是对于networker所在的节点的权限是不是正确或者所有的节点有没有许可。
wangjgh
3 消息
0
2013年11月30日 18:00
我的备份存储池是昆腾的物理带库,也尝试了往备份服务器的本地磁盘备份,问题依旧.....
wangjgh
3 消息
0
2013年11月30日 18:00
2个节点的归档日志备份没有问题,但是2个节点的数据文件备份都会出现附件问题,备份用户的权限是够的啊
liulei_it
2 Intern
2 Intern
•
3.2K 消息
0
2013年11月30日 22:00
同一个在存储上的数据文件都要被两个节点共同访问,至于归当日志是跟随instance也就是节点走的,除非您的归档日志也是放到存储中给所有节点共享。简单一点就是说,例如你的数据库只有一个数据文件,那么两个或者多个节点的Instance都要能正确识别这个数据文件才能让这两个节点的instance同时对这个数据文件进行读写操作,否则的话就不是RAC这种share everything结构了。
至于归档日志那么是随着instance的节点走的,你有两个节点,那么同一个数据库就有可能有两份分别放在不同节点的本地硬盘上的归档日志,这个RAC环境有几个节点就有几份归档日志。所以说您反映的对归档日志文件应该是房子Local节点的本地硬盘上的而不是共享存储上的。而数据文件是需要被所有节点共同正确访问的。让您的DBA和您一起检查一下对于共享存储的权限问题
o17Uu33DCF12520
2 Intern
2 Intern
•
1.1K 消息
0
2013年12月2日 00:00
添加oracle帐号管理networker的权限看看,
nsraddadmin -u oracle@
>
免费订阅论坛每月简报请点击