Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help with oracle restore options

Help with oracle restore options

From: Cristian S. <cs277_at_columbia.edu>
Date: 17 Sep 2001 11:25:26 -0700
Message-ID: <537e2d08.0109171025.8bf0b66@posting.google.com>


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. Received on Mon Sep 17 2001 - 13:25:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US