Database Administration (MOSC)

MOSC Banner

cannot create a huge pluggable database

edited Dec 19, 2022 10:34AM in Database Administration (MOSC) 4 commentsAnswered

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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center