Database Backup and Recovery (MOSC)

MOSC Banner

ORA-17628 ORA-19505 during RMAN duplicate from active (non-OMF to OMF)

edited Apr 4, 2022 10:24AM in Database Backup and Recovery (MOSC) 1 commentAnswered

I'm trying to RMAN duplicate a database with non-OMF files to one with OMF (ie. with a db_create_file_dest parameter, so I don't have to think about filenames anymore).

However, my rman command below, results in a ORA-17628: Oracle error 19505 returned by remote Oracle server. MOS note 1331986.1 indicates I should add a translation parameter, but my command still fails. Is there a 'debug' log where we can drill down to find exactly which datafile was the offending one?

My RMAN duplicate command:

=======

run {
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate auxiliary channel a1 type disk;


duplicate target database for standby from active database
spfile
  parameter_value_convert 'PRIM','STBY','PRIM','STBY'
  set db_unique_name='STBY'
  set db_create_file_dest='/stby_data/oradata'
  set db_create_online_log_dest_1='/stby_recon/oradata'
  set db_create_online_log_dest_2='/stby_recovery/oradata'
  set db_file_name_convert='/prim_data','/stby_data'
  set log_file_name_convert='/prim_recovery','/stby_recovery','/prim_recon','/stby_recon'
  set cluster_database='false'
  set control_files='/stby_recon/oradata/control01.ctl,/stby_data/oradata/control02.ctl,/stby_recovery/oradata/control03.ctl'
  set log_archive_max_processes='5'
  set fal_client='STBY'
  set fal_server='PRIM'
  set standby_file_management='MANUAL'
  set log_archive_config='dg_config=(PRIM,STBY)'
  set log_archive_dest_2='service=PRIM ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=PRIM'
;
}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center