RE: PDB refresh

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_at_quest.com<mailto:clay.jackson_at_quest.com> office 949-754-1203 mobile 425-802-9603 [cid:image001.png_at_01D600F1.4654CFD0]

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Ghassan Salem Sent: Monday, March 23, 2020 8:45 AM
To: zahir.dba_at_gmail.com
Cc: oracle-l <Oracle-L_at_freelists.org> 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_at_gmail.com<mailto:zahir.dba_at_gmail.com>> 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

1. 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, ...
2. 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
3. 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_at_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_at_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>

--
http://www.freelists.org/webpage/oracle-l




image/png attachment: image001.png