Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to recover a dropped table ?
As they say, disk is cheap. That is until you try to buy 1TB or more.
Unfortunately, this doesn't work well with multi-terabyte databases.
Cheers,
Brian
Burton Peltier wrote:
>
> For future reference ... just my paranoid opinion...
>
> Nightly full exports to disk in compressed mode take up very little room -
> you would be amazed how small a 50Gig database full export compressed really
> is (depending on data could be less than 2 or 3 Gig - easily).
>
> Highly recommened you do at least a full export backup (given your
> noarchivelog mode). I personally do 4 types of backups on dev(actually
> acceptance testing DBs) and prod databases:
> - nightly hot (requires archivelog mode)
> - daily archive log backups (if in archivelog mode - 2 copies of each log )
> - nightly full exports (start out with consistent=y, but might need to
> change to consistent=n if lots of activity during export time - which cannot
> be change)
> - weekly cold backups (ok in our env , but probably not in others)
>
> Note: I would also have 2 copies of everything at all times and archive to
> tape, especially if easy to have an existing backup process pick up your
> backup files.
>
> --
> "MJ Wood" <maryjanewood_at_hotmail.com> wrote in message
> news:73q7gvsqbfeb4amjb6pt8304kc65h5npdt_at_4ax.com...
> > Hi,
> >
> > It happened a few day ago that one of our developer "accidentally"
> > dropped a table in our development database(no archive log). The data
> > in this table (about 100 lines) is not very important so the data was
> > re-created manually.
> > Anyway, I just wondering how can I recover the data in the dropped
> > table. This table was dropped around 4pm and at 6pm this database was
> > idle. I think the data was still in the redo log.
> > How can I rollback the tablespace to a specific time (e.g. 4pm) and
> > the transactions between 4am to 6pm can be preserved? Or it is just
> > impossible to do so?
> > Thanks in advance for any input.
> >
> > MJW
-- =================================================================== Brian Peasland oracle_dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Jul 07 2003 - 09:40:52 CDT