Since you said you are not a DBA and you would like to move a database from
1 server to another, I would highly recommend 1 thing... hire a DBA :)
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3e281d54$0$230$ed9e5944_at_reading.news.pipex.net...
> As far as the cold backup goes what operating system are you using?
> As far as the Hot backup goes I believe that the Veritas backup exec
manuals
> have a guide on doing exactly this.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "Jigar Parsana" <jigarparsana_at_yahoo.com> wrote in message
> news:a079a49c.0301170618.7284a2d9_at_posting.google.com...
> > Hi,
> >
> > I have two questions in particular. I have a cold backup and a hot
> > backup of a database. My Cold back up is basically a full backup of
> > the entire oracle directory structure. and my hotbackup is done using
> > Veritas backup exec. the thing is that we need to have this database
> > on a new server so that we can test our backup and recovery
> > procedures.My questions are:
> >
> > 1.What are the steps that i should do so create the database on the
> > new server...should i just overwrite the entire directory structure or
> > oracle using my cold back up ...or are there just some other files
> > that i should copy and rebuild the database from that....if that is
> > the case..what are the commands/steps to do so.
> >
> > 2. Once i build the database ...how do i apply the hotbackup to the
> > new database so that we have data which is upto to the last hotbackup.
> >
> >
> > Please understand that i am not a DBA and it just happens that
> > there is no one at this point in time to do this job except me. I
> > would highly appreciate any information on this problem...thanx in
> > advance.
> >
> > Jigar
>
>
Received on Sat Jan 18 2003 - 01:08:24 CST
