数据库的system的用户密码被修改后，备份报用户名和密码错误

dingshihong58

1、\r\n在clinet上个system赋权限：\r\nPHS_SERV$[</oracle/product/9.2.0.6>]sqlplus \'/ as sysdba\'\r\n\r\nSQL*Plus: Release 9.2.0.6.0 - Production on Mon Sep 24 12:46:52 2007\r\n\r\nCopyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.\r\n\r\n\r\nConnected to:\r\n\r\nOracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production\r\n\r\nWith the Partitioning option\r\n\r\nJServer Release 9.2.0.6.0 - Production\r\n\r\nSQL> grant  sysdba to system;  已经做好\r\n\r\n\r\n\r\n2、备份并移走C3700上配置文件\r\n\r\n[root@c3700:/etc/opt/omni/server/barlists/oracle8]#ls\r\n\r\n243_arch              phs_arch              rp8400_1onlinedb      zh_arch\r\n\r\n243_cncbill_onlinedb  phs_onlinedb          rp8400_2_arch         zh_onlinedb\r\n\r\niss_arch              rp7400_1_arch         rp8400_2onlinefull\r\n\r\niss_onlinefull        rp7400_1_dbfull       tss_arch\r\n\r\noracle_rp7400_1_test  rp8400_1_arch         tss_onlinefull\r\n\r\n[root@c3700:/etc/opt/omni/server/barlists/oracle8]#mv iss_arch iss_arch1\r\n\r\n3、在CLIENT上执行下面的命令，在C3700的dp配置目录下检查配置文件是否重新生成。\r\n\r\niss_SERV[</opt/omni/lbin>]＃\r\n\r\n./util_oracle8.pl -config -dbname tss -orahome  /o9i/product/9.2.0.1 -prmuser system -prmpasswd paxf_123 -prmservice tss -rcuser rmantss -rcpasswd rmantss -rcservice rman\r\n\r\n./util_oracle8.pl -chkconf tss\r\n\r\n\r\n\r\n./util_oracle8.pl -config -dbname iss -orahome  /o9i/product/9.2.0.1 -prmuser system -prmpasswd paxf_321 -prmservice iss -rcuser rmaniss -rcpasswd rmaniss -rcservice rman\r\n\r\n./util_oracle8.pl -chkconf iss\r\n\r\n进入数据库修改system的密码：\r\nSQL>alter user system identified by paxf_123;\r\n\r\n\r\n在数据库用户下\r\n\r\ndp备份时当client端的归档日志比dp中的历史记录归档日志新时备份就会失败，此时就要到登录client端数据库将dp的和数据库的\r\ncatalog同步一下即可，步骤如下：\r\n1、在数据库用户下执行：rman target system/paxf_321；格式是：rman target 数据库user/userpasswd；\r\n\r\n2、连接数据库的catalog：connect catalog rmaniss/rmaniss@rman；格式是connect catalog rmanuser/rmanuserpasswd@rmanserv;\r\n\r\n3、将其同步：crosscheck archivelog all;