setup

source trc05crm@racnodc07
target mrc05crm@racnodc07

take full rman backup of source trc05crm

racnodc07 - /backup/TRC05_RMAN


set parallelism to 12 so no need to do chnnel allocation 
CONFIGURE DEVICE TYPE disk PARALLELISM 12;



[oracle@racnodc0701 TRC05_RMAN]$ cat TRC05CRM_rman_full.rcv
RUN
{
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/TRC05_RMAN/trc05crm_full_%u_%s_%p';
backup database plus archivelog ;
}

[oracle@racnodc0701 TRC05_RMAN]$ env|grep ORA
ORACLE_SID=TRC05CRM_2
ORACLE_HOME=/u01/oracle/product/19C/db_1

run script in background

[oracle@racnodc0701 TRC05_RMAN]$ cat TRC05CRM_rman_full.sh
rman target / cmdfile=TRC05CRM_rman_full.rcv log=TRC05CRM_rman_full.log


[oracle@racnodc0701 TRC05_RMAN]$ nohup ./TRC05CRM_rman_full.sh > TRC05CRM_rman_full.out &




[oracle@racnodc0701 TRC05_RMAN]$ tail -1000f TRC05CRM_rman_full.log

Recovery Manager: Release 19.0.0.0.0 - Production on Wed Apr 28 20:15:26 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TRC05CRM (DBID=1010854894)

RMAN> RUN
2> {
3> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/TRC05_RMAN/trc05crm_full_%u_%s_%p';
4> backup database plus archivelog ;
5> }
6>
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup/TRC05_RMAN/trc05crm_full_


..........
.............
channel ORA_DISK_12: finished piece 1 at 28-APR-21
piece handle=/backup/TRC05_RMAN/trc05crm_full_buvtf1r2_382_1 tag=TAG20210428T205143 comment=NONE
channel ORA_DISK_12: backup set complete, elapsed time: 00:00:03
Finished backup at 28-APR-21

Starting Control File and SPFILE Autobackup at 28-APR-21
piece handle=+FRA/TRC05CRM/AUTOBACKUP/2021_04_28/s_1071089511.7737.1071089513 comment=NONE
Finished Control File and SPFILE Autobackup at 28-APR-21

Recovery Manager complete.

check scn

[oracle@racnodc0701 TRC05_RMAN]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Apr 29 02:24:09 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TRC05CRM (DBID=1010854894)

RMAN> restore database preview summary;

..........
.............

recovery will be done up to SCN 17474995087811
Media recovery start SCN is 17474995087811
Recovery must be done beyond SCN 17474995164412 to clear datafile fuzziness ======================>
Finished restore at 29-APR-21

create pfile for target

cluster_database=FALSE
compatible='19.0.0'
CONTROL_FILES = '+REDO','+DATA_FC'
db_name='MRC05CRM'
db_unique_name='MRC05CRM'
db_block_size=8192
db_create_file_dest = '+DATA'
db_create_online_log_dest_1='+DATA_FC'
db_recovery_file_dest_size ='50G'
db_recovery_file_dest='+FRA'
db_domain=''
diagnostic_dest='/u01/orabase'
log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST'
log_archive_format='%t_%s_%r.dbf'
remote_login_passwordfile='EXCLUSIVE'
sga_max_size='10G'
sga_target='10G'
pga_aggregate_target='2G'
streams_pool_size='2G'

password file

orapwd file=/u01/oracle/product/19C/db_1/dbs/orapwMRC05CRM password=oracle123# entries=10

startup auxiliary database in no mount

startup nomount pfile='/u01/oracle/product/19C/db_1/dbs/initMRC05CRM.ora'

in db home listner.ora at static entry

[oracle@racnodc0701 admin]$ cat listener.ora
SID_LIST_MRC05CRM =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = MRC05CRM)
      (ORACLE_HOME = /u01/oracle/product/19C/db_1)
      (SID_NAME = MRC05CRM)
    )
  )
MRC05CRM =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = racnodc0701)(PORT = 1527))
    )
  )

reload listener

lsnrctl reload MRC05CRM
[oracle@racnodc0701 admin]$ lsnrctl status MRC05CRM

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-APR-2021 04:14:37

Copyright (c) 1991, 2020, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racnodc0701)(PORT=1527)))
STATUS of the LISTENER
------------------------
Alias                     MRC05CRM
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                29-APR-2021 04:14:04
Uptime                    0 days 0 hr. 0 min. 33 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/oracle/product/19C/db_1/network/admin/listener.ora
Listener Log File         /u01/orabase/diag/tnslsnr/racnodc0701/mrc05crm/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=racnodc0701.internal.net)(PORT=1527)))
Services Summary...
Service "MRC05CRM" has 1 instance(s).
  Instance "MRC05CRM", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

tnsnames in db_home

MRC05CRM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racnodc07)(PORT = 1527))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = MRC05CRM)
    )
  )


[oracle@racnodc0701 admin]$ tnsping MRC05CRM

TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 29-APR-2021 04:15:19

Copyright (c) 1997, 2020, Oracle.  All rights reserved.

Used parameter files:
/u01/oracle/product/19C/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = racnodc07)(PORT = 1527)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MRC05CRM)))
OK (40 msec)

test connection are subcessfull with tns entries

[oracle@racnodc0701 admin]$ rman target sys/c0lt2014Apr@TRC05CRM auxiliary sys/c0lt2014Apr#@MRC05CRM

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Apr 29 04:16:19 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TRC05CRM (DBID=1010854894)
connected to auxiliary database: MRC05CRM (not mounted)

parallelism is 12 so no need to do ay=nything eslse
CONFIGURE DEVICE TYPE disk PARALLELISM 12;

RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name TRC05CRM are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 12 BACKUP TYPE TO BACKUPSET;  ======================>>>
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup/TRC05_RMAN/trc05crm_full_%u_%s_%p';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/product/19C/db_1/dbs/snapcf_TRC05CRM_2.f'; # default


execute the script in the background

rman_dup_MRC05CRM.sh
----------------
rman target sys/c0lt2014Apr@TRC05CRM auxiliary sys/c0lt2014Apr#@MRC05CRM cmdfile=MRC05CRM.rcv log=MRC05CRM.log

MRC05CRM.rcv
------------
run
{
DUPLICATE TARGET DATABASE to 'MRC05CRM' until scn 17474995164412;
}


chmod +x rman_dup_MRC05CRM.sh
nohup ./rman_dup_MRC05CRM.sh > rman_dup_MRC05CRM.out &


[oracle@racnodc0701 TRC05_RMAN]$ tail -1000f MRC05CRM.log

Recovery Manager: Release 19.0.0.0.0 - Production on Thu Apr 29 04:25:56 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TRC05CRM (DBID=1010854894)
connected to auxiliary database: MRC05CRM (not mounted)

RMAN> run
2> {
3> DUPLICATE TARGET DATABASE to 'MRC05CRM' until scn 17474995164412;
4> }
5>
Starting Duplicate Db at 29-APR-21
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=3 device type=DISK

.............
...........
..........
Executing: alter database force logging

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Executing: alter database flashback on
Cannot remove created server parameter file
Finished Duplicate Db at 29-APR-21

verify the db

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
MRC05CRM  READ WRITE

SQL> sho parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/oracle/product/19C/db_1/d
                                                 bs/spfileMRC05CRM.ora
SQL> sho parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_optimizer_cluster_by_rowid_control  integer     129
_optimizer_control_shard_qry_process integer     65528
ing
_optimizer_extended_stats_usage_cont integer     192
rol
_optimizer_join_order_control        integer     3
control_file_record_keep_time        integer     7
control_files                        string      +REDO/MRC05CRM/CONTROLFILE/cur
                                                 rent.302.1071116801, +DATA_FC/
                                                 MRC05CRM/CONTROLFILE/current.3
                                                 02.1071116801

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_management_pack_access       string      DIAGNOSTIC+TUNING

now we will convert this db to rac

select which server pool you want for rac db

[grid@racnodc0701 ~]$ srvctl config srvpool
Server pool name: Free
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: Generic
Importance: 0, Min: 0, Max: -1
Category:
Candidate server names:
Server pool name: ODSP01
Importance: 100, Min: 2, Max: 2
Category:
Candidate server names: racnodc0701,racnodc0702

rconfig

[oracle@racnodc0305 smudgal]$ cat ConvertToRAC_PolicyManaged.xml
<?xml version="1.0" encoding="UTF-8"?>
<n:RConfig xmlns:n="http://www.oracle.com/rconfig"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://www.oracle.com/rconfig">
    <n:ConvertToRAC>
<!-- Verify does a precheck to ensure all pre-requisites are met, before the conversion is attempted. Allowable values are: YES|NO|ONLY -->
        <n:Convert verify="ONLY">
<!--Specify current OracleHome of non-rac database for SourceDBHome -->
              <n:SourceDBHome>/u01/oracle/product/19C/db_1</n:SourceDBHome>
<!--Specify OracleHome where the rac database should be configured. It can be same as SourceDBHome -->
              <n:TargetDBHome>/u01/oracle/product/19C/db_1</n:TargetDBHome>
<!--Specify SID of non-rac database and credential. User with sysdba role is required to perform conversion -->
              <n:SourceDBInfo SID="MRC05CRM">
                <n:Credentials>
                  <n:User>sys</n:User>
                  <n:Password>c0lt2014Apr#</n:Password>
                  <n:Role>sysdba</n:Role>
                </n:Credentials>
              </n:SourceDBInfo>
<!--Specify the list of existing or new server pools which will be used by the Policy Managed Cluster Database. -->
              <n:ServerPoolList>
                <n:ExistingServerPool name="ODSP01"/>
              </n:ServerPoolList>
<!--Specify RacOneNode along with servicename to convert database to RACOne Node -->
              <!--n:RacOneNode  servicename="MRC05CRM"/-->
<!--InstancePrefix is not required for Policy Managed database. If specified, it will be ignored. Instance names are generated automatically based on db_unique_name for Policy Managed dababase.-->
<!-- Listener details are no longer needed starting 11.2. Database is registered with default listener and SCAN listener running from Oracle Grid Infrastructure home. -->
<!--Specify the type of storage to be used by rac database. Allowable values are CFS|ASM. The non-rac database should have same storage type. ASM credentials are no needed for conversion. -->
              <n:SharedStorage type="ASM">
<!--Specify Database Area Location to be configured for rac database.If this field is left empty, current storage will be used for rac database. For CFS, this field will have directory path. -->
                <n:TargetDatabaseArea></n:TargetDatabaseArea>
<!--Specify Fast Recovery Area to be configured for rac database. If this field is left empty, current recovery area of non-rac database will be configured for rac database. If current database is not using recovery Area, the resulting rac database will not have a recovery area. -->
                <n:TargetFlashRecoveryArea></n:TargetFlashRecoveryArea>
              </n:SharedStorage>
        </n:Convert>
    </n:ConvertToRAC>
</n:RConfig>
[oracle@racnodc0701 TRC05_RMAN]$ vi ConvertToRAC_PolicyManaged.xml
[oracle@racnodc0701 TRC05_RMAN]$ which rconfig
/u01/oracle/product/19C/db_1/bin/rconfig
[oracle@racnodc0701 TRC05_RMAN]$ vi ConvertToRAC_PolicyManaged.xml
[oracle@racnodc0701 TRC05_RMAN]$ rconfig ConvertToRAC_PolicyManaged.xml
Specify sys user password for the database

<?xml version="1.0" ?>
<RConfig version="1.1" >
<ConvertToRAC>
    <Convert>
      <Response>
        <Result code="0" >
          Operation Succeeded
        </Result>
      </Response>
      <ReturnValue type="object">
There is no return value for this step     </ReturnValue>
    </Convert>
  </ConvertToRAC></RConfig>
[oracle@racnodc0701 TRC05_RMAN]$

change value and run again

<n:Convert verify="YES">
[oracle@racnodc0701 TRC05_RMAN]$ rconfig ConvertToRAC_PolicyManaged.xml
Specify sys user password for the database

Converting Database "MRC05CRM" to Cluster Database. Target Oracle Home: /u01/oracle/product/19C/db_1. Database Role: PRIMARY.
Setting Data Files and Control Files
Adding Trace files
Adding Database Instances
Create temporary password file
Adding Redo Logs
Enabling threads for all Database Instances
Setting TEMP tablespace
Adding UNDO tablespaces
Setting Fast Recovery Area
Updating Oratab
Creating Password file(s)
Configuring related CRS resources
Starting Cluster Database
<?xml version="1.0" ?>
<RConfig version="1.1" >
<ConvertToRAC>
    <Convert>
      <Response>
        <Result code="0" >
          Operation Succeeded
        </Result>
      </Response>
      <ReturnValue type="object">
<Oracle_Home>
         /u01/oracle/product/19C/db_1
       </Oracle_Home>
       <Database type="POLICY_MANAGED"  >
         <ServerPoolList>
            <ServerPool>
                ODSP01
            </ServerPool>
         </ServerPoolList>
         <InstanceList>
           <Instance SID="MRC05CRM_1" Node="racnodc0702"  >
           </Instance>
           <Instance SID="MRC05CRM_2" Node="racnodc0701"  >
           </Instance>
         </InstanceList>
       </Database>     </ReturnValue>
    </Convert>
  </ConvertToRAC></RConfig>

check database status

[grid@racnodc0701 ~]$ srvctl status database -d MRC05CRM
Instance MRC05CRM_1 is running on node racnodc0702
Instance MRC05CRM_2 is running on node racnodc0701


[grid@racnodc0701 ~]$ srvctl config database -d MRC05CRM
Database unique name: MRC05CRM
Database name: MRC05CRM
Oracle home: /u01/oracle/product/19C/db_1
Oracle user: oracle
Spfile: +DATA/MRC05CRM/spfileMRC05CRM.ora
Password file: +DATA/MRC05CRM/orapwMRC05CRM
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ODSP01
Disk Groups: REDO,DATA_FC,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances:
Configured nodes:
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is policy managed

moving password file to asm

orapwd input_file='/u01/oracle/product/19C/db_1/dbs/orapwMRC05CRM' file='+DATA/MRC05CRM/orapwMRC05CRM' asm=y
[oracle@racnodc0701 ~]$ orapwd input_file='/u01/oracle/product/19C/db_1/dbs/orapwMRC05CRM' file='+DATA/MRC05CRM/orapwMRC05CRM' asm=y

OPW-00010: Could not create the password file. This resource has a Password File.
srvctl modify database -d MRC05CRM -pwfile
srvctl config database -d MRC05CRM
orapwd dbuniquename=MRC05CRM file='+DATA/MRC05CRM/orapwMRC05CRM' password=oracle123# entries=10
[oracle@racnodc0701 ~]$ srvctl config database -d MRC05CRM
Database unique name: MRC05CRM
Database name: MRC05CRM
Oracle home: /u01/oracle/product/19C/db_1
Oracle user: oracle
Spfile: +DATA/MRC05CRM/spfileMRC05CRM.ora
Password file: +DATA/MRC05CRM/orapwMRC05CRM
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ODSP01
Disk Groups: REDO,DATA_FC,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances:
Configured nodes:
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is policy managed
[oracle@racnodc0701 ~]$ srvctl modify database -d MRC05CRM -pwfile
[oracle@racnodc0701 ~]$ srvctl config database -d MRC05CRM
Database unique name: MRC05CRM
Database name: MRC05CRM
Oracle home: /u01/oracle/product/19C/db_1
Oracle user: oracle
Spfile: +DATA/MRC05CRM/spfileMRC05CRM.ora
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ODSP01
Disk Groups: REDO,DATA_FC,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances:
Configured nodes:
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is policy managed
[oracle@racnodc0701 ~]$ orapwd dbuniquename=MRC05CRM file='+DATA/MRC05CRM/orapwMRC05CRM' password=oracle123# entries=10
[oracle@racnodc0701 ~]$ srvctl config database -d MRC05CRM
Database unique name: MRC05CRM
Database name: MRC05CRM
Oracle home: /u01/oracle/product/19C/db_1
Oracle user: oracle
Spfile: +DATA/MRC05CRM/spfileMRC05CRM.ora
Password file: +DATA/MRC05CRM/orapwmrc05crm
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: ODSP01
Disk Groups: REDO,DATA_FC,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances:
Configured nodes:
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is policy managed
[oracle@racnodc0701 ~]$
ASMCMD> ls +DATA/MRC05CRM/orapwmrc05crm
orapwmrc05crm


SQL> select name,open_mode from gv$database;

NAME      OPEN_MODE
--------- --------------------
MRC05CRM  READ WRITE
MRC05CRM  READ WRITE

stop the listener created for duplicate

[oracle@racnodc0701 ~]$ ps -ef|grep tns
root        92     2  0 Apr06 ?        00:00:00 [netns]
grid      4830     1  0 Apr06 ?        00:00:44 /u01/grid/19C/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
grid      5359     1  0 Apr06 ?        00:07:43 /u01/grid/19C/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit
grid      5397     1  0 Apr06 ?        00:07:44 /u01/grid/19C/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit
grid     12310     1  0 Apr06 ?        00:12:51 /u01/grid/19C/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid     12398     1  0 Apr06 ?        00:07:23 /u01/grid/19C/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
oracle   17570     1  0 04:14 ?        00:00:00 /u01/oracle/product/19C/db_1/bin/tnslsnr MRC05CRM -inherit   ==>
oracle   18040 27451  0 06:04 pts/2    00:00:00 grep --color=auto tns



[oracle@racnodc0701 ~]$ lsnrctl stop MRC05CRM

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 29-APR-2021 06:06:20

Copyright (c) 1991, 2020, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racnodc0701)(PORT=1527)))
The command completed successfully

change audit location

SQL> sho parameter aud

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/oracle/product/19C/db_1/r
                                                 dbms/audit



SQL> alter  system set audit_file_dest='/u01/orabase/admin/MRC05CRM/adump' scope=spfile sid='*';

System altered.

make audit location in both instance
[oracle@racnodc0701 ~]$ mkdir -p /u01/oracle/admin/MRC05CRM/adump


[oracle@racnodc0702 ~]$ mkdir -p /u01/oracle/admin/MRC05CRM/adump

[oracle@racnodc0701 audit]$ srvctl stop database -d MRC05CRM
[oracle@racnodc0701 audit]$ srvctl start database -d MRC05CRM
[oracle@racnodc0701 audit]$ srvctl status database -d MRC05CRM
Instance MRC05CRM_1 is running on node racnodc0702
Instance MRC05CRM_2 is running on node racnodc0701
SQL>  sho parameter aud

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/orabase/admin/MRC05CRM/ad
                                                 ump

golden gate setup

[ggadmin@racnodc0701 ogg]$ cat gg_env_MRC05CRM
export ORACLE_HOME=/u01/oracle/product/19C/db_1
export OGG_HOME=/u01/acfs/ogg/product/19.1.0.0.4/MRC05CRM   
export ORACLE_SID=MRC05CRM_2
export PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:$ORACLE_HOME/bin:$OGG_HOME
export LD_LIBRARY_PATH=$OGG_HOME:$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
cd $OGG_HOME

start replicat

START REPLICAT R1_ICG05, AFTERCSN 17474995164412

START REPLICAT R_ICG05, AFTERCSN 17474995164412