PDB refresh

From: Zahir Mohideen <zahir.dba_at_gmail.com>
Date: Mon, 23 Mar 2020 10:42:49 -0400
Message-ID: <CAM5KiKrmNse=HXSKAaovU3TxMKs+tTqoGQv3AojBhhkb7=oLRw_at_mail.gmail.com>



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 ?
  2. To utilize this feature , is there any additional licensing needed ?
  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. 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
Received on Mon Mar 23 2020 - 15:42:49 CET

Original text of this message