Re: Moving a complete oracle 8i database to a new location

From: Anand R <anand_radhakrishnan_at_syntelinc.com>
Date: 9 Aug 2004 03:57:55 -0700
Message-ID: <c89bc19b.0408090257.199a8046@posting.google.com>

Chuck <chuckh_nospam_at_softhome.net> wrote in message news:<Xns953D6ED301217chuckhnospamsofthome_at_130.133.1.4>...
> 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.

---

Thanks a lot Chuck !
That was really helpful, but I have no idea regarding a RMAN repository. Can anything be done with a trace file of the control files ? Also what are the spfiles ?

Once again thanks for the response.

Regards,
Anand PR Received on Mon Aug 09 2004 - 05:57:55 CDT