Highlighted
wangjgh
1 Copper

Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

Redhat Linux下oracle RAC备份数据和归档均备份到一半报错,如附件求指导

标签 (1)
0 项奖励
6 条回复6
born_chen
4 Tellurium

Re: Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

看上去像是权限问题。脚本的账户权限赋予了么?

Permission denied, user 'oracle' on 'erpdb2-vip' does not have 'Operate NetWorker' OR 'Change Application Settings' privilege to perform this operation- NSR.

0 项奖励
liulei_it
4 Germanium

Re: Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

# 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所在的节点的权限是不是正确或者所有的节点有没有许可。

0 项奖励
wangjgh
1 Copper

Re: Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

2个节点的归档日志备份没有问题,但是2个节点的数据文件备份都会出现附件问题,备份用户的权限是够的啊

0 项奖励
wangjgh
1 Copper

Re: Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

我的备份存储池是昆腾的物理带库,也尝试了往备份服务器的本地磁盘备份,问题依旧.....

0 项奖励
liulei_it
4 Germanium

Re: Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

同一个在存储上的数据文件都要被两个节点共同访问,至于归当日志是跟随instance也就是节点走的,除非您的归档日志也是放到存储中给所有节点共享。简单一点就是说,例如你的数据库只有一个数据文件,那么两个或者多个节点的Instance都要能正确识别这个数据文件才能让这两个节点的instance同时对这个数据文件进行读写操作,否则的话就不是RAC这种share everything结构了。

至于归档日志那么是随着instance的节点走的,你有两个节点,那么同一个数据库就有可能有两份分别放在不同节点的本地硬盘上的归档日志,这个RAC环境有几个节点就有几份归档日志。所以说您反映的对归档日志文件应该是房子Local节点的本地硬盘上的而不是共享存储上的。而数据文件是需要被所有节点共同正确访问的。让您的DBA和您一起检查一下对于共享存储的权限问题

0 项奖励

Re: Redhat linux 下oracle RAC备份数据和归档均备份到一半报错,如附件,求指导

添加oracle帐号管理networker的权限看看,

nsraddadmin -u oracle@<db named>


>

免费订阅论坛每月简报请点击

0 项奖励