Remote connection as sysdba to shutdown database
I'm trying to create a physical standby using the RMAN Duplicate from Active Database following Doc ID 1075908.1. It errors out with:
[/fcalprd/u01/app/oracle/product/19/network/admin]$ rman target sys/xxx@fccoiprd auxiliary sys/xxx@fccoidr
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Nov 18 09:45:27 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: FCCOIPRD (DBID=312868385)
connected to auxiliary database: FCCOIPRD (not mounted)
RMAN> run {
allocate channel prmy1 type disk;
2> 3> allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
4> duplicate target database for standby from active database
5> spfile
6> parameter_value_convert 'fccoiprd','fccoidr'
7> 8> set db_unique_name='fccoidr'
set db_file_name_convert='/fccoiprd/','/fccoidr/'
set log_file_name_convert='/fccoiprd/','/fccoidr/'
9> 10> set control_files='/fcalprd/u02a/oradata/FCCOIPRD/control01.ctl'
11> set log_archive_max_processes='5'
12> 13> 14> 15> set fal_client='fccoidr'
set fal_server='fccoiprd'
16> 17> 18> set standby_file_management='MANUAL'
19> set log_archive_config='dg_config=(fccoiprd,fccoidr)'
20> 0