Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
RMAN Duplicate Command fails with ORA-02778

SIS
Member Posts: 615 Bronze Badge
Hi,
I am trying to configure physical standby database without data guard. Below are my environment details.
OS: Windows 2019 Server (Primary and Standby Machines)
Oracle Database: Oracle 19c
Primary Database Name: primary
Standby Database: standby1
After doing all the necessary steps on primary database and standby database, when I try to run RMAN DUPLICATE TARGET DATABASE command (ref: "command"), I am getting the following error (ref: "error").
command:
run { allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate channel prmy3 type disk; allocate channel prmy4 type disk; allocate auxiliary channel stby type disk; duplicate target database for standby from active database spfile parameter_value_convert 'primary','standby1' set db_name='primary' set db_unique_name='standby1' set db_file_name_convert='\primary\','\standby1\' set log_file_name_convert='\primary\','\standby1\' set control_files='C:\app\administrator\oradata\standby1\standby1.ctl' set log_archive_max_processes='5' set fal_client='standby1' set fal_server='primary' set standby_file_management='AUTO' set log_archive_config='dg_config=(primary,standby1)' set log_archive_dest_2='service=primary ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primary' ; }
error:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at dd/mm/yyyy hh24:mi:ss RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at dd/mm/yyyy hh24:mi:ss RMAN-11003: failure during parse/execution of SQL statement: alter system set core_dump_dest = 'C:\app\administrator\diag\rdbms\standby1\primary\cdump' comment= '' scope=spfile ORA-32017: failure in updating SPFILE ORA-02778: Name given for the log directory is invalid
Kindly suggest, if someone had faced the similar error or if you can suggest something.
Thanks
SIS
Tagged:
Comments
-
Hi All,
I managed to resolve it by adding the "set core_dump_dest" in the RMAN script itself.
Thanks
SIS
-
did you check, is the directory is created ??