My Oracle Support Banner

[OCI] Remote Clone Of PDB From OCI-C Is Taking Long Time And Unusable After That (Doc ID 2726419.1)

Last updated on NOVEMBER 23, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

The PDB is in OCI-C environment.

PDB was cloned using:

SQL>  create pluggable database xxxxx from xxxxx@xxxxx keystore identified by "xxxxxxxxxxxxxx";

SQL> alter pluggable database xxxxx open;
alter pluggable database xxxxx open
*
ERROR at line 1:
ORA-65106: Pluggable database #6 (xxxxxx) is in an invalid state.

Media recovery is in progress for a long time.
And from alert log following type of message is seen:

****************************************************************
Pluggable Database xxxxx with pdb id - 6 is created as UNUSABLE.
If any errors are encountered before the pdb is marked as NEW,
then the pdb must be dropped
local undo-1, localundoscn-0x00000000000000e1
**************************************************************

...

Applying media recovery for pdb-4099 from SCN 15523429848442 to SCN 15523458298856
Remote log information: count-3
thr-1, seq-21735, logfile-/u03/app/oracle/fast_recovery_area/xxxx/archivelog/2020_10_27/o1_mf_1_21735_hskmgdyy_.arc, los-15523457786840, nxs-15523458226940
thr-1, seq-21734, logfile-/u03/app/oracle/fast_recovery_area/xxxxxx/archivelog/2020_10_27/o1_mf_1_21734_hskkt2dp_.arc, los-15523457364743, nxs-15523457786840
thr-1, seq-21736, logfile-/u03/app/oracle/fast_recovery_area/xxxxx/foreign_archivelog/xxxxx/2020_10_27/o1_mf_1_21736_3883612694_.arc, los-15523458226940, nxs-18446744073709551615

.....

 

Changes

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.