Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: backup question
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