-
Hi
Following steps I have received from Jeff Hunter and I tried it (8.0.5). It worked fine for me.
1. alter system backup controlfile to trace
2. shutdown database (normal or immediate)
3. backup database
4. create new $ORACLE_BASE/admin/$ORACLE_SID directory
5. copy files from $ORACLE_BASE/admin/old_oracle_sid to
$ORACLE_BASE/admin/new_oracle_sid
6. edit init.ora and change any references from old SID to new SID
7. create orapw file (orapw file=orapwNEW_SID)
8. edit trace file
8.1 Get rid of garbage before STARTUP NOMOUNT
8.2 Change CREATE CONTROLFILE REUSE to CREATE CONTROLFILE
REUSE SET
8.3 Comment out RECOVER DATABASE
8.4 Change ALTER DATABASE OPEN to ALTER DATABASE OPEN
RESETLOGS
8.5 Change any references of the old SID to the new SID
9. svrmgrl
10. connect internal
11. @your_trace_file_name_created_in_step_8
12. shutdown (immediate or normal)
13. backup database (don't overwrite step #2)
14. startup database
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|