Clone E-Business Suite (EBS) database - Revision history

Stuart: /* Export dba_directories */

2017-05-22T10:36:27Z

‎Export dba_directories

Stuart: /* Check disk space for clone is sufficient */

2017-05-22T10:32:05Z

‎Check disk space for clone is sufficient

Stuart: /* Backup the source db tier database(s) */

2017-05-22T10:14:55Z

‎Backup the source db tier database(s)

Stuart: /* Backup db tier database(s) */

2017-05-22T10:12:00Z

‎Backup db tier database(s)

Stuart at 15:33, 21 April 2017

2017-04-21T15:33:42Z

Stuart at 12:55, 21 April 2017

2017-04-21T12:55:59Z

Stuart at 12:52, 21 April 2017

2017-04-21T12:52:58Z

Stuart at 12:51, 21 April 2017

2017-04-21T12:51:02Z

Stuart: Created page with "This will be a living document for a while as I change it with each successful clone I do!
==Preparation== Assuming there is already a target (clone) that will be destro..."

2017-04-21T10:11:20Z

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..."

New page

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 destroyed in the process.
===Backup db tier databases===
===Check disk space for clone is sufficient===
===Save important data on target database(s) before destroying===
====Export dba_directories====
====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====
==Perform clone==
===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===

@@ Line 1: / Line 1: @@
 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.
+Not all of these steps will be necessary in all cases. Some are specific to this particular installation.<br />
 ==Preparation==
 Assuming there is already a target (clone) that will be destroyed in the process.
@@ Line 35: / Line 57: @@
 ===Start target listener===
 ===Check spfile parameters===
 ===Clean up some directories on apps tier===
 ===Postclone the target apps tier===

@@ Line 42: / Line 42: @@
 ===Export dba_directories===
 ===Export dba_db_links===
 ===Verify the db links still work on the target (may need pointing somewhere else afterwards)===

@@ Line 26: / Line 26: @@
 Assuming there is already a target (clone) that will be destroyed in the process.
 ===Backup the source db tier database(s)===
 ===Check disk space for clone is sufficient===

@@ Line 5: / Line 5: @@
 ===Backup db tier database(s)===
 ===Check disk space for clone is sufficient===
-===Save important data on target database(s) before destroying===
+===Export dba_directories===
-====Export dba_directories====
+===Export dba_db_links===
-====Export dba_db_links====
+===Verify the db links still work on the target (may need pointing somewhere else afterwards)===
-====Verify the db links still work on the target (may need pointing somewhere else afterwards)====
+===Save user passwords===
-====Save user passwords====
+===Modify file location spfile parameters===
-====Modify file location spfile parameters====
+===Save SQL baselines===
-====Save SQL baselines====
+===Save SQL profiles===
-====Save SQL profiles====
+===Save context file on apps tier===
-====Save context file on apps tier====
+===Create a pfile from spfile===
-====Create a pfile from spfile====
+===Add source database to target tnsnames.ora===
-====Add source database to target tnsnames.ora====
+===Preclone the source db tier===
-====Preclone the source db tier====
+===Preclone the source apps tier===
 ==Perform clone==
 ===Stop all apps tier process on target===