This isn’t exactly the issue; but, take a look at this
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2049965.1&displayIndex=1
And try setting parallel_max_servers to 0
Clay Jackson
Database Solutions Sales Engineer
clay.jackson@xxxxxxxxx<mailto:clay.jackson@xxxxxxxxx>
office 949-754-1203 mobile 425-802-9603
[cid:image001.png@01D600F1.4654CFD0]
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Ghassan Salem
Sent: Monday, March 23, 2020 8:45 AM
To: zahir.dba@xxxxxxxxx
Cc: oracle-l <Oracle-L@xxxxxxxxxxxxx>
Subject: Re: PDB refresh
CAUTION: This email originated from outside of the organization. Do not follow
guidance, click links, or open attachments unless you recognize the sender and
know the content is safe.
Answers inline:
On Mon, Mar 23, 2020, 15:45 Zahir Mohideen
<zahir.dba@xxxxxxxxx<mailto:zahir.dba@xxxxxxxxx>> wrote:
Hello All -
I am in the process of ( testing of ) upgrade from 12.1 to 19.3 on Windows.
We are licensed for Enterprise Edition.
Want to make use of auto refresh PDB ( every 30 minutes or so ) .
Few questions
a) How is it different from Data Guard ?
Well, it uses very much the same underlying structures, but you don't have to
have a full featured DG, for all the DB, if you have different PDBs, you can
have different refresh rates, ...
b) To utilize this feature , is there any additional licensing needed ?
No, as long as you're using 19c, and no more than 3 pdbs in a CDB
c) I got an ORA-600 error while creating pdb from the remote link. Looked into
the metalink . So far , no clear information . I will be filing a SR shortly.
Upgrade to the latest 19c. And you're sure you put in all pre-reqs? (archivelog
mode, proper grants to the dblink user, ....)
Wondering , if you come across this issue before.
SQL> CREATE PLUGGABLE DATABASE PDB_SOCR_RO FROM PDB_SOC@socprd_link
file_name_convert =
('F:\ORADATA\DBPRD\PDB_SOC','C:\APP\ORACLE\ORADATA\DB193\PDB_SOCR') REFRESH
MODE MANUAL;
CREATE PLUGGABLE DATABASE PDB_SOCR_RO FROM PDB_SOC@socprd_link
file_name_convert =
('F:\ORADATA\DBPRD\PDB_SOC','C:\APP\ORACLE\ORADATA\DB193\PDB_SOCR') REFRESH
MODE MANUAL
*
ERROR at line 1:
ORA-65169: error encountered while attempting to copy file
F:\ORADATA\DBPRD\PDB_SOC\TBSCRS01.DBF
ORA-17627: ORA-00600: internal error code, arguments: [ksfqsrfn_rfn], [], [],
[], [], [], [], [], [], [], [], []
Thanks in advance.
Stay safe .
Zahir Mohideen
http://mfzahirdba.blogspot.com/<https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmfzahirdba.blogspot.com%2F&data=02%7C01%7Cclay.jackson%40quest.com%7C7768544428c84a1f155108d7cf41522f%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637205751786114139&sdata=j9NueKDIFMxJjeiiLtKXobpfqnBz0FdfKRwwWD38iCg%3D&reserved=0>