RMAN> duplicate target database for standby from active database 2> spfile 3> parameter_value_convert 'masterdb','masterdr','MASTERDB','MASTERDR' set db_name='masterdb' 4> 5> set db_unique_name='masterdr' 6> set fal_server='masterdbtns' 7> set log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=masterdr NOREOPEN ALTERNATE=log_archive_dest_2' 8> set log_archive_dest_3='service=masterdbtns LGWR ASYNC NOAFFIRM max_failure=10 reopen=60 valid_for=(online_logfiles,primary_role) db_unique_name=masterdb' 9> set local_listener='LISTENER_MASTERDR'; Starting Duplicate Db at 28-JUN-19 using target database control file instead of recovery catalog allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=268 device type=DISK contents of Memory Script: { backup as copy reuse passwordfile auxiliary format '/opt/app/oracle/product/19.x.0/dbhome_1/dbs/orapwmasterdr' targetfile '+DATA/masterdb/parameterfile/spfile.293.1012128045' auxiliary format '/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora' ; sql clone "alter system set spfile= ''/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora''"; } executing Memory Script Starting backup at 28-JUN-19 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=575 device type=DISK Finished backup at 28-JUN-19 sql statement: alter system set spfile= ''/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora'' Reread resulted in same corrupt block on file '/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora' blockno=1 Reread resulted in same corrupt block on file '/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora' blockno=1 Reread resulted in same corrupt block on file '/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora' blockno=1 Reread resulted in same corrupt block on file '/opt/app/oracle/product/19.x.0/dbhome_1/dbs/spfilemasterdr.ora' blockno=1
The error keeps repeating and no going forward from this point.
The solution was to move the DB spfile out of ASM into local disk ($ORACLE_HOME/dbs) and re-run the duplicate command. There were no issue in the subsequent execution.
Related Post
4K Sector, compatible.rdbms and Redo Log File Block Size