RAC Standby database creation using GRID is failing with ORA-01620 (Doc ID 1405973.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

Issue occurred during RAC standby database creation using grid control.


SQL> ORACLE instance started.

Total System Global Area 2622255104 bytes
Fixed Size 2162560 bytes
Variable Size 553648256 bytes
Database Buffers 2046820352 bytes
Redo Buffers 19623936 bytes


SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL*Plus: Release 11.1.0.7.0 - Production on Fri May 27 10:37:03 2011

Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated


alter database mount
*
ERROR at line 1:
ORA-01620: no public threads are available for mounting




SQL> ERROR:
ORA-06550: line 1, column 29:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated


BEGIN sys.dbms_backup_restore.resetCfileSection(dbms_backup_restore.RTYP_DFILE_COPY); END;

*
ERROR at line 1:
ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 6812
ORA-06512: at line 1






Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms