Re: Help with oracle restore options

Cristian S. wrote:
>
> Hi all,
>
> I have this script in oracle 8i on unix that somebody else wrote at my
> company. It basically does a hot backup in oracle. Now, I would like
> to take the files it creates and move them to a brand new server.
> Here are the details.
>
> The script first places tablespaces in backup mode and then it creates
> a tar file with all the data files for each table space. The database
> is also running in archivelog mode so the script also adds to the tar
> file all the archive logs. At the end, the script backs up the
> control file and adds that to the tar file also.
>
> So I have the datafiles, archive logs and the control file.
>
> I would like now to take all that and move it to a brand new server
> where I just intalled oracle from scratch. (I know that it would be
> possible to just perform a quick export/import procedure but I don't
> have access to the original server anymore so I must work with the
> files created by the hotbackup script).
>
> Can somebody help me figure out just how I can do this? At a minimum,
> I would like to just get the actual data from the datafiles working
> and after that if I can roll forward the archive logs it would be
> great.
>
> Please be as detailed as possible if you respond and thank you very
> much in advance.

Probably a good place to start would be the doco on standby database (either from metalink or technet.oracle.com).

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."