Re: URGENT 8.1.7 recovery question

Oracle 8.1.7.4? Oddly enough I had to do the same thing on the same day last week, with an Oracle 7.3.4.5 database. Except I had no control files or online redo logs left, as a SA re-initialized the Veritas file system the database was using .....

Regards

Pete

On Jan 14, 2008 7:21 PM, Taylor, Chris David <Chris.Taylor_at_ingrambarge.com> wrote:

> Ok, guys and gals. I just lost an 8.1.7.4 db that doesn't use RMAN.
>
>
>
> I have totally forgotten how to recover {until time} a db that doesn't use
> RMAN.
>
>
>
> I'm restoring the DB files and the archivelog files and want to recover
> until 12:30 PM CST.
>
>
>
> Help me remember the recovery process if you will.
>
>
>
> I think its:
>
>
>
> SQL> Startup mount;
>
>
>
> SQL> recover database until time to_date('01/14/2008 12:31:00','MM/DD/YYYY
> HH24:MI:SS');
>
>
>
> SQL> alter database open resetlogs;
>
>
>
> Is that right??
>
>
>
> *Chris Taylor*
>
> *Sr. Oracle DBA*
>
> Ingram Barge Company
>
> Nashville, TN 37205
>
> Office: 615-517-3355
>
> Cell: 615-354-4799
>
> Email: chris.taylor_at_ingrambarge.com
>
>
>

-- 
Regards

Pete

--
http://www.freelists.org/webpage/oracle-l