Resetting Parameters during RMAN DUPLICATE FROM ACTIVE DATABASE SPFILE
Duplicating a database from RAC to a single instance using RMAN DUPLICATE FROM ACTIVE DATABASE with the SPFILE option works fine. Also setting and resetting parameters works but unfortunately not for all parameters.
For example:
(...)
set db_recovery_file_dest_size='59055800320'
set cluster_database='FALSE'
reset fal_client
reset fal_server
(...)
works. But I don’t know how to reset instance specific parameters like thread.
Kind Regard
Oliver.