Re: Help with oracle restore options

Given that he would need a standby controlfile, a standby database will only work in his case if he has access to the original Instance ( 'cause I suspect the backup script didn't get that ).

If he does have access.

ALTER DATABASE CREATE STANDBY CONTROLFILE AS '<filename>';

.will allow creation of a standby database on the new server.

-Kevin

"Cristian S." <cs277_at_columbia.edu> wrote in message news:537e2d08.0109171025.8bf0b66_at_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 - 17:10:56 CDT