Re: URGENT 8.1.7 recovery question
- From: "Peter Hitchman" <pjhoraclel@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 20 Jan 2008 13:57:18 +0000
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@xxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxxxx
>
>
>
--
Regards
Pete
Other related posts:
