[OCM 12C] Performing a full database backup

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)

Related posts

Leave a Comment