Rman备份中常见的问题

1：ORA-01031insufficient privileges

gpasswd  -d oracle dba --将oracle移除出dba组

查看oracle属性

uid=500(oracle) gid=500(oinstall) groups=500(oinstall)

[oracle@oracle10g ~]$ rman target  /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 21 14:07:11 2013
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

解决：

usermod  -d /home/oracle/ -G dba  oracle --将oracle用户加入dba组

[root@oracle10g ~]# usermod  -d /home/oracle/ -G dba oracle
[root@oracle10g ~]# su - oracle
[oracle@oracle10g ~]$ rman target  /
Recovery Manager: Release 10.2.0.1.0 - Production