This is an old revision of the document!
Clone_E-Business_Suite_(EBS)_database
This will be a living document for a while as I change it with each successful clone I do!<br />
Not all of these steps will be necessary in all cases. Some are specific to this particular installation.<br />
Topology
Preparation
Assuming there is already a target (clone) that will be destroyed in the process.
Backup the source db tier database(s)
The clone will be taken using RMAN as it is quicker than copying the datafiles if the database(s) are big.<br />
Check if the last successful backup was not too long ago (to avoid rolling forward too much).
Check disk space for clone is sufficient
If we are refreshing an existing clone, the chances are that there is already enough space.<br />
1@@
2@@
Space remaining after clone on destination is : (B+C)-A<br />
If this is positive, there will be enough space.
Export dba_directories
Do this on the destination to preserve any directories. They can be imported back in after the clone has overwritten them.
3@@
Export dba_db_links
Verify the db links still work on the target (may need pointing somewhere else afterwards)
Save user passwords
Modify file location spfile parameters
Save SQL baselines
Save SQL profiles
Save context file on apps tier
Create a pfile from spfile
Add source database to target tnsnames.ora
Preclone the source db tier
Preclone the source apps tier
Stop all apps tier process on target
Shutdown target database
Remove the target database files
Start copy of apps tier files in background
Duplicate the source database(s)
Restart target listener(s)
Post clone
Check datafile status
Restart database cleanly
Put back context file on apps tier
Register target database(s) with RMAN catalog
Stop target listener
link gcc
Check unzip version
Postclone the target db tier
Start target listener
Check spfile parameters
Clean up some directories on apps tier
Postclone the target apps tier
Change sysadmin password
Run Autoconfig on target database(s)
Check database is up
Restore dba_directories to target database(s)
Restore db links to target database(s)
Check utl_file_dir and APPLPTMP
Run Autoconfig on apps tier
Start apps tier services
Check Concurrent Manager status
Check Applications Dashboard
Execute Diagnostics tests
Run Concurrent Report "Activity Based Management (Obsolete)"
Change Site Name profile option value
Clear apps tier cache
Restart web server
Update other profile option values
Test concurrent program with known values to check consistency
Relink any .prog files to fndcpesr
Restore user passwords on target database(s)
Test db links
Set AWR parameters
Recreate nologging indexes
Fake stats on some tables
