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 laterOracle 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.
Symptoms
For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Primary Database:
DB_NAME: ORCL
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;
SQL> /
THREAD# STATUS ENABLED INSTANCE
---------- ------ -------- ----------
1 OPEN PUBLIC ORCL
Changes
NA
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |