Database Reference
In-Depth Information
5. Generate the control file using the ora_br_copy.sh shell script, as explained earlier in
this chapter, or generate a control file using the Oracle trace method.
6. The Oracle method of generating the control file is as follows:
7. Shut down the database and take a full offline backup.
8. The control file generated in this way needs to be edited before it can be used in the
target system.
9. The control file generated using the ora_br_copy.sh shell script has target system in-
formation already in it, so it does not need to be edited.
Editing the Control File Generated by the Oracle Trace Method The following changes
have to be done to the control file generated by the Oracle method.
1. All occurrences of the source SID have to be replaced with the target SID.
2. Delete all the lines starting from the top of the file up to the second STARTUP
NOMOUNT. (Do not delete the second STARTUP NOMOUNT line.)
3. Change the CREATE CONTROLFILE REUSE DATABASE “SSID” statement to
CREATE CONTROLFILE SET REUSE DATABASE “TSID”.
Example: CREATE CONTROLFILE SET REUSE DATABASE KB1, where KB1 is the
target SID.
4. Delete the RECOVER DATABASE USING BACKUP CONTROLFILE line com-
pletely.
5.Addthefollowinglinestothecontrolfileandsavethefilesothatcertainpostdatabase
copy steps are taken care of at the start of the database in the target system where the
target SID = KB1:
Search WWH ::




Custom Search