ORA-17628 RMAN-03009 duplicate target database for standby from active database

While run RMAN “duplicate target database for standby from active database nofilenamecheck” in 11g database, then got below errors:

set newname for datafile 3 to "/u02/oradata/TESTDBSTY/undotbs01.dbf";
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u02/oradata/TESTDB/undotbs01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/15/2019 15:53:17
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run

The workaround is to setup below two parameters with full path:

db_file_name_convert='/u02/oradata/TESTDB/', '/u02/oradata/TESTDBSTY/'
log_file_name_convert='/u03/oradata/TESTSB/', '/u03/oradata/TESTDBSTY'

The short name like this is not enough in 11g, but in 12c it is fine:

db_file_name_convert='TESTDB', 'TESTDBSTY'

So it seems a bug for 11g.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.