Database Networking (MOSC)

MOSC Banner

Remote connection as sysdba to shutdown database

edited Nov 18, 2022 4:35PM in Database Networking (MOSC) 6 comments

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>  

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