My Oracle Support Banner

ZDLRA - Container Database - Redo_Transport_User - How to create common user on CDB and Recovery Catalog (Doc ID 2148774.1)

Last updated on FEBRUARY 11, 2022

Applies to:

Oracle Database Cloud Service - Version N/A and later
Zero Data Loss Recovery Appliance Software - Version and later
Oracle Database - Enterprise Edition - Version and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


While using ZDLRA as Backup solution, If the customer would like to use a dedicated user account for REDO TRANSPORTATION to implement "Real Time Redo Shipping", we need to create a user with same name on the PROTECTED DATABASE and the ZDLRA Recovery Catalog..

However, while creating user on 12c Protected Database with CDB Option, common user must have C## prepended. But on Recovery catalog which is NOT CREATED with CDB option ( by design ), doesn't allow us to create user with C## prepended..

IMPORTANT : If the protected database is not configured with physical standby, then we no need to create a REDO TRANSPORT USER for real time redo shipping. Only VPC( Virtual Private Catalog ) user has to be created on the Recovery catalog. 

SQL> create user c##rauser identified by ********;
create user c##rauser identified by ********
ERROR at line 1:
ORA-65094: invalid local user or role name


SQL> create user rauser identified by ********;
create user rauser identified by ********
ERROR at line 1:
ORA-65096: invalid common user or role name




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.