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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)