| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Production Issue: How to change the database name (sid)
Hannah,
If I remember correctly you have to "backup controlfile to trace",=20
shutdown the database,
edit the backed up controlfile to change the controlfile names and =
resetlog option,
edit the init.ora file to show the new dbname,
start svrmgr and run the new controlfile script with reset logs option.=20
Then do a complete backup of the database to capture the new name and log =
numbers.
I might have left been brief in some of the details but the concept is =
there.
I hope this guides you in the direction you need.
ROR m=AA=BF=AAm
>>> Hannah.M.Doran_at_sb.com 11/14/00 02:45PM >>>
Subject:
Production Issue: How to change the database name (sid) in a controlfile
Hi List.
I am having an issue. I just created a test and devl instance on my
development machine (NT SP4, Oracle 7.3.4). In the past I only had one =
instance
and it had the same SID (ORCL) as production. Since these are Development =
and
test environments, I used to be able to quickly replicate the prod data by =
just
copying over the database base files and bringing up the instance. Taaa =
daaaaa!
Very quick for a 3 GB db.....
Anyway, I needed to develop two instances, so rebuilt my nt box, =
created 2
instances: test, devl. I have copied over the db files from prod, but =
forgot OH
NO, the db name in the control file is now out of sync! I'm running 7.3.4 =
and
do NOT have the db schema set up (its a vendor app ~500-600 tables - no =
ddl
scripts).
Anyone know fo a way to change the db name in a control file? =
Otherwise my
life will be hell and will probably have to start from scratch for both =
new
instances!
Any suggestions? These are only test and development environments, so I'm
looking for QUICK in porting my prod data. In the past, this was the =
quickest
way to do it.
Thanks in advance.
Hannah
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author:=20
INET: Hannah.M.Doran_at_sb.com=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Nov 14 2000 - 14:40:17 CST
 |
 |