ZDLRA - Container Database - Redo_Transport_User - How to create common user on CDB and Recovery Catalog
(Doc ID 2148774.1)
Last updated on DECEMBER 22, 2019
Applies to:Oracle Database Cloud Service - Version N/A and later
Zero Data Loss Recovery Appliance Software - Version 184.108.40.206.1 to 220.127.116.11.1
Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 12.1]
Oracle Database Exadata 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.
ON ZDLRA 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
ON PROTECTED DATABASE
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