Database Backup and Recovery User’s Guide -> 4 Starting and Interacting with the RMAN Client
Database Backup and Recovery User’s Guide -> 9 Backing Up the Database
– Backing Up the Root with Oracle Enterprise Manager Cloud Control
– Backing Up PDBs with Oracle Enterprise Manager Cloud Control
Database Backup and Recovery User’s Guide -> 10 Backing Up the Database: Advanced Topics
Database Backup and Recovery User’s Guide -> 11 Reporting on RMAN Operations
Database Backup and Recovery User’s Guide -> 15 Diagnosing and Repairing Failures with Data Recovery Advisor
Database Backup and Recovery User’s Guide -> 17 Performing Complete Database Recovery
Database Backup and Recovery User’s Guide -> 20 Performing RMAN Recovery: Advanced Scenarios
“In a CDB, archived redo logs can be backed up only when you connect to the root as a common user with the SYSDBA or SYSBACKUP privilege. When you connect to a PDB as a local user with SYSDBA or SYSBACKUP privilege, you cannot back up or delete archived redo logs.”
Backing Up the Root with RMAN
BACKUP DATABASE ROOT;
Backup Pluggables Databases:
1-Start RMAN and connect to the root as a common user with the SYSBACKUP or SYSDBA privilege.
2-
BACKUP PLUGGABLE DATABASE sales, hr;
It is important you have this in mind as well:
Connecting to the Root with a Net Service Name
This example assumes that there is a sales net service name that resolves to a database service for the root, and that there is a common user named c##bkuser that has the SYSBACKUP privilege.
rman target c##bkuser@sales
target database Password: password
connected to target database: CDB (DBID=659628168)
Example 4-19 Connecting As Target to a PDB
rman target hrbkup@hrpdb
target database Password: password
connected to target database: CDB (DBID=659628168)
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.