Difference between revisions of "Clone E-Business Suite (EBS) database"
From dbawiki
(Created page with "This will be a living document for a while as I change it with each successful clone I do!<br /> ==Preparation== Assuming there is already a target (clone) that will be destro...") |
(No difference)
|
Revision as of 10:11, 21 April 2017
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.
