Forum Stats

  • 3,817,098 Users
  • 2,259,276 Discussions


DATAGUARD: Recover from service ORA-17627 invalid username and password

DMX Member Posts: 79 Red Ribbon
edited Nov 24, 2020 4:11PM in Replication

Good morning fellows

My standby has fallen behind and i need to roll it forward, but I'm having issues trying to use the Recover from Service feature. Whenever i connect to the standby and execute the command i get the following response from the database:

RMAN> recover database from service PRIM noredo using compressed backupset;

Starting recover at 24-NOV-20

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=2270 device type=DISK

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 11/24/2020 11:06:20

ORA-17629: Cannot connect to the remote database server

ORA-17627: ORA-01017: invalid username/password; logon denied

ORA-17629: Cannot connect to the remote database server

I have tried copying the password file from primary and bouncing the standby, but the issues still persist. Also i tried changing the SYS password and copying the password file again, but still i get the error message. Any help will be really appreciate. The following are the details:

DB Version: with ASM

PRIM: RAC 2-node

STANDBY: 1 node

O.S: Solaris 11