Database Backup and Recovery (MOSC)

MOSC Banner

Backup with RMAN - 19c Oracle Database

edited Jan 30, 2023 2:15PM in Database Backup and Recovery (MOSC) 7 commentsAnswered

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,

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