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 laterZero Data Loss Recovery Appliance Software - Version 12.1.1.1.1 and later
Oracle Database - Enterprise Edition - Version 12.1.0.1 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.
Goal
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
Solution
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
| Goal |
| Solution |
| References |