RMAN-06136 ORA-01620: No Public Threads Are Available For Mount
(Doc ID 2325012.1)
Last updated on JANUARY 17, 2023
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Diskgroup :- ORCL_REDO
RMAN can fail when running duplicate database with error below
RMAN-03002: failure of Duplicate Db command at 11/04/2017
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01620: no public threads are available for mounting
All threads in source database are PUBLIC and OPEN. Source database is not RAC.
SQL> select thread#, status, enabled, instance from v$thread;
THREAD# STATUS ENABLED INSTANCE
---------- ------ -------- ----------
1 OPEN PUBLIC ORCL
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