Clone E-Business Suite (EBS) database
From dbawiki
This will be a living document for a while as I change it with each successful clone I do!
Contents
- 1 Preparation
- 1.1 Backup db tier databases
- 1.2 Check disk space for clone is sufficient
- 1.3 Save important data on target database(s) before destroying
- 1.3.1 Export dba_directories
- 1.3.2 Export dba_db_links
- 1.3.3 Verify the db links still work on the target (may need pointing somewhere else afterwards)
- 1.3.4 Save user passwords
- 1.3.5 Modify file location spfile parameters
- 1.3.6 Save SQL baselines
- 1.3.7 Save SQL profiles
- 1.3.8 Save context file on apps tier
- 1.3.9 Create a pfile from spfile
- 1.3.10 Add source database to target tnsnames.ora
- 1.3.11 Preclone the source db tier
- 1.3.12 Preclone the source apps tier
- 2 Perform clone
- 3 Post clone
Preparation
Assuming there is already a target (clone) that will be destroyed in the process.
