Are you 100% sure that the database was DOWN when you copied over the
database files ?
--
Karl
Oracle Certified DBA
David Shi wrote in message <67jscb$dqr$0_at_204.179.92.112>...
>I tried to duplicate a database following this post, but didn't
>succeed, I remember the error message is something like "sys.dbf" need
>to be recovered, what did I miss?
>
>Also, is this topic covered somewhere in Oracle's manuals or other
>places?
>
>Thanks a lot!
>
>David
>
>On Thu, 11 Dec 1997 11:08:22 -0600, Sheilah Scheurich
><scheuric_at_wantnospamsprynetatall.com> wrote:
>
>>You are actually on the right track, what you need to do is take the
>>existing database and create a control file. The first thing you do is
>>BACKUP YOUR PRODUCTION DATABASE!!!. Now create new create controlfile
>>script. You do this from your existing database with the command: "alter
>>database backup control file to trace". Next, shutdown the database and
>>copy the redo logs and database files to a new location (it is good to
>>also rename them as well - just document - so that you can easily perform
>>the next step). The trace file is going to be dumped into your user trace
>>directory, with the same cryptic format that it usually takes, so just
>>look for the trace file with the time that you performed the command. Now,
>>edit the file, remove all the junk from the top and change the create
>>controlfile command to read
>> create controlfile set database "newdbname" resetlogs
>>
>>Next, create a new init.ora file with new names for the control files.
>>Now shutdown the existing database, or this won't work. Now go into the
>>new SID. In unix it is ORACLE_SID=newdbname;export ORACLE_SID
>>
>>connect internal and run this new create script. Voila, you have a new
>>database!
>>
>>
>>Declan O'Reilly wrote:
>>
>>> I would like to create a second instance of my database on the same
>>> Unix Server.
>>> I was wondering is it possible to copy of all the tablespace, rollback
>>> and redo files
>>> to a new destination and then update the copied system tablespace with
>>> the new locations
>>> of the tablespaces etc, aswell as creating a new init???.ora file. Is
>>> this all there is to it or am I way off base.
>>>
>>> Thanks
>>> Declan O'Reilly
>
>
>
>=====================================================
>If this is a posting to newsgroup, I appreciate if you can
>also forward your reply to "dshi_at_magpage.com", since I find
>it is very easy to miss postings on the newsgroup. Thanks a
>lot!
begin 666 Karl E. Jørgensen.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DKX<F=E;G-E;CM+87)L.T4N
M#0I&3CI+87)L($4N($KX<F=E;G-E;@T*3U)'.E-E<75E;"!);6%G90T*3D]4
M13I396YI;W(@4WES=&5M<R!%;F=I;F5E<@T*55),.@T*55),.FAT=' Z+R]S
M97%U96PM:6UA9V4N8V]M#0I%34%)3#M04D5&.TE.5$523D54.FMJ;W)G0&US
H;BYC;VT-"E)%5CHQ.3DW,3(S,%0Q.34X,C!:#0I%3D0Z5D-!4D0-"@``
`
end
end
Received on Tue Dec 30 1997 - 00:00:00 CST
