Friday, August 4, 2017

ORA-17628: Oracle error 19505 returned by remote Oracle server

I am trying to rebuild dataguard for a recently refreshed database in our development environment.

While creating the duplicate database from active database using RMAN I am getting the error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/03/2017 09:58:18
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/03/2017 09:58:18
ORA-17628: Oracle error 19505 returned by remote Oracle server

As the error says that there are some issues with the remote database and that in my case is the new DR database.

While looking at the alert logs of the DR database what I have found that I was getting the error as below:

NOTE: failed to open SPFILE +DATA/dev1tstd/parameterfile/spfiledev1tstd.ora

Reason was that $ORACLE_HOME/dbs already had an initdev1tstd1.ora file which stores spfile location and that was going to +DATA/dev1tstd/parameterfile/spfiledev1tstd.ora . After the refresh of primary database what I did was rm -rf +DATA/dev1tstd and rm -rf +FRA/dev1tstd which wiped the spfile.

To fix it I just had to rename the initdev1tstd1.ora to initdev1tstd1.ora.old and try the duplicate command again and it fixed the issue.


No comments: