cannot create a huge pluggable database
Environment : Oracle RDBMS 19.16 on RHL 8.
My current steps of migration is as following
1) copying the old PDB using a databaselink
2) opening this PDB => Warning: PDB altered with errors.
3) datapatch -pdb => solve the issue
I'm experimenting a problem copying a huge (2.5 T) pdb. The parallelism has no real impact.
SQL> create pluggable database vstaxp from vstaxp@artemis parallel 8 ;
create pluggable database vstaxp from vstaxp@artemis parallel 8
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-65345: cannot refresh pluggable database
Elapsed: 01:50:02.82
My linked parameters are
db_recovery_file_dest_size = 2500G
db_recovery_file_dest=+FRA
log_archive_dest_1 ='LOCATION=USE_DB_RECOVERY_FILE_ DEST'