Re: PDB refresh

Answers inline:

On Mon, Mar 23, 2020, 15:45 Zahir Mohideen <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
>
> 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_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/
>
>

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