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)
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)