Introduction Migrating Oracle databases from AWS RDS to Oracle Cloud Infrastructure (OCI) is a common requirement for organizations adopting OCI-native services, improving performance, or reducing licensing and operational constraints. Unlike on-premise databases, AWS RDS restricts OS-level…
Read MoreIf a point-in-time recovery is not an option, follow the steps below: Backup the Database as sys user. We will have to patch fed$apps and obj$. startup restrict; Create backup…
Read MoreWe got a request to do a schema refresh, We prepared the parfile as below $cat DEV_SCHEMA.par directory=MY_DIR dumpfile=DEV_SCHEMA_%u.dmp logfile=DEV_SCHEMA.log SCHEMAS=DEV_SCHEMA1,DECSCHEMA01 estimate=statistics parallel=8 filesize=2G and ran in background as $ nohup…
Read MoreSCHEMA REFRESH In this Post , Let us discuss the steps involved during schema refresh using datapump. Prerequisite to check on Before Export on SOURCE SIDE 1. Check the Schema…
Read More