Chuck <chuckh_nospam_at_softhome.net> wrote in
news:Xns953D6E66DA775chuckhnospamsofthome_at_130.133.1.4:
> anand_radhakrishnan_at_syntelinc.com (Anand R) wrote in
> news:c89bc19b.0408060416.296084ab_at_posting.google.com:
>
>> Hello all,
>>
>> I have a production database running on Windows NT Server. I have been
>> asked to replicate the database for the development server running on
>> Windows 2000 Professional. I have no hands on experience on moving a
>> database completely. I have taken the copies of the datafiles, redo
>> logs, control files and password file from the production.
>>
>> I have a very vague idea to go ahead with the next step. I have
>> installed oracle on the new machine and have opted for not creating a
>> database during the installation. So there are no instances running
>> and no database mounted. I thought that this was a good occassion for
>> me to learn setting up a database from scratch.
>>
>> If anyone could please guide me step by step on the procedures to be
>> followed, I'll be extremely thankful for the help. I was recommended
>> to this group by many experts in my company. Please help me to find a
>> solution to the problem as soon as possible.
>>
>> Thanks and Regards,
>>
>> Anand PR.
>>
>
> Create the same directories that the prod db is using on the dev server
> and put all the datafiles there.
>
> Copy the init/spfiles to the same location on the dev server.
>
> Create the same instance service name with oradim.
>
> Start the service.
>
> At this point you may want to rename the dbname and generate a new dbid
> especially if you plan to include this db's information in an rman
> repository as part of your backup strategy. Rman doesn't like multiple
> databases with the same dbid if you're using a repository.
Just noticed this is an *8i* database. You'll have to search metalink for
the procedure on generating a new dbid. 9i has a procedure to do this. 8i
does not but there is a workaround. I just don't remember off the top of
my head what it is.
--
Chuck
Remove "_nospam" to reply by email
Received on Fri Aug 06 2004 - 09:53:40 CDT
