Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: backup & recovery options

Re: backup & recovery options

From: Vitalis Jerome <vitalisman_at_gmail.com>
Date: Mon, 24 Oct 2005 17:12:21 +0200
Message-ID: <68b128550510240812q2bbb3d47h6284c59b45c59dcb@mail.gmail.com>


Hi,

With 9i, the solution is to perform an incomplete recovery of tablespaces system+undo+the tablespace containing your table (+the tablespaces needed because of schema dependencies) on a new instance (on another server to limit the risks).
Then exp/imp your table between both instances.

Jerome

On 10/24/05, Zabair Ahmed <roon987_at_yahoo.co.uk> wrote:
> 9.2.0.5 on AIX 5L (IBM p670 Servers)
>
> Currently we are doing the following type of backup - incremental RMAN level
> 0, 1 & 2 backups on our 2TB datawarehouse database.
>
> Recently one of the critical tables was dropped accidently. We have been
> able to recover the dropped table by doing a point-in-time recovery.
>
> We cannot do full database exports as this would take to long in our backup
> window.
>
> I know flashback table exists but only in 10g!
>
>
> My question is how can we improve our backup method so that we are in a
> better position to handle such a scenerio.
>
> What am looking for is how other people handle tables being accidently
> dropped in their database
>
> TIA
>
>
>
>
> ________________________________
> Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with
> voicemail
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 24 2005 - 10:14:27 CDT

Original text of this message

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