rman遭遇RMAN-03002 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017

原创黄宸宁 2014-02-20

2001

今天在写一RAC数据库的rman删除归档的脚本时，遭遇以下报错：

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 02/20/2014 10:26:51
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied

因为该脚本之前在另外一套RAC上是没问题的，为啥在这套库上出了问题？先查看了下RMAN的配置信息，发现与之前没问题的那套库之间还是有些差异，差异内容主要体现在configure channel上，根据官方文档的解释如下：

  
Symptoms
~~~~~~~~~
A RMAN command such as "delete" results in errors like these:
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 09/05/2006 17:26:51
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied
Changes
~~~~~~~~
Modification or addition of the persistent configuration parameter for 
connecting to the target database. 
Cause
~~~~~~
The RMAN "show all" command will show a setting like this one or with an incorrect 
password, incorrect userid, etc:
  CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
Solution
~~~~~~~~~
1) Return this persistent configuration parameter back to the default setting 
   as follows:
   RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
   of change the configuration to a correct value
   RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK  connect '<username/password>';
2) Re-submit the failing operation.

oracle

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

rman遭遇RMAN-03002 RMAN-12001 RMAN-10008 RMAN-10003 ORA-01017

评论