Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

DMXNov 24 2020 — edited Nov 24 2020

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: 12.2.0.1.0 with ASM
PRIM: RAC 2-node
STANDBY: 1 node
O.S: Solaris 11

Regards.

DMX.

Comments
Post Details
Added on Nov 24 2020
0 comments
1,203 views