Backup with RMAN - 19c Oracle Database
Hi Experts,
uatcdb is CDB
UATDB is pdb
We have a container database with single pdb
We are configuring the backup.
[orauat@erpuatdb2 ~]$ cd /u02 [orauat@erpuatdb2 u02]$ cat 19c.env export ORACLE_HOME=/u02/UAT19CBASE/19chome #export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH export ORACLE_BASE=/u02/UAT19CBASE export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/lib/site_perl/5.28.1 export ORA_NLS10=/u02/UAT19CBASE/19chome/nls/data export ORACLE_SID=uatcdb2 SQL> create user c##my_dba identified by Password1 container=all; User created. SQL> grant create session to c##my_dba container=all; Grant succeeded. SQL> grant sysbackup to c##my_dba container=all; Grant succeeded. [orauat@erpuatdb2 u02]$ sqlplus c##my_dba/Password1@uatcdb as sysbackup SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jan 30 19:30:17 2023 Version 19.17.0.0.0 Copyright (c) 1982, 2022, Oracle. All rights reserved. Last Successful login time: Mon Jan 30 2023 17:00:32 +05:30 Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.17.0.0.0 SQL> Unable to connect using rman CDB: === [orauat@erpuatdb2 u02]$ rman target c##my_dba/Password1@uatcdb Recovery Manager: Release 19.0.0.0.0 - Production on Mon Jan 30 19:37:48 2023 Version 19.17.0.0.0 Copyright (c) 1982, 2019,
0