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 -> Re: backup question

Re: backup question

From: Brian E Dick <bdick_at_cox.net>
Date: Fri, 04 Oct 2002 10:42:36 GMT
Message-ID: <wgen9.75583$IL6.3874459@news2.east.cox.net>


Read up on point-in-time based recovery. But you will need some starting point for applying the archivelogs. If you truly have all the archivelogs since all the database objects were created, then also read the section about creating data files and adding them to the database. Once the database has a physical file, it can apply all transactions since time 0 to recreate the data.

"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:anjm1f$tqv$1_at_mawar.singnet.com.sg...
> Senario:
>
> 1. today is 3rd of OCT, now i want to discard all the changes for today on
a
> database(archivelog mode), that means i need to use incomplete recovery to
> recover the DB until time '2002-10-02:23:59:59'.
> 2. I don't have any backups of this db.
> 3. I have all the archive log files.
>
> Question
>
> Is it possibe to recover the db to that particular time using incomplete
> recovery?
>
> TIA.
>
>
Received on Fri Oct 04 2002 - 05:42:36 CDT

Original text of this message

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