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 about OPS ??

Re: Backup question about OPS ??

From: <markp7832_at_my-deja.com>
Date: Wed, 18 Aug 1999 16:16:17 GMT
Message-ID: <7pem84$542$1@nnrp1.deja.com>


In article <7ovqes$n6$1_at_nnrp1.deja.com>,   Agi <agichen_at_my-deja.com> wrote:
> Hello, Alex
> Could you explain the difference between RMAN and exp/imp backup
> policy ?
> on time consuming,restore some table only, recover entire db, ??
>
> Thanks !!
> Rgds,
> Agi
>
> In article <7ou7tn$ihd$1_at_taliesin.netcom.net.uk>,
> "Alex Hudghton" <alex_at_alenda.freeserve.co.uk> wrote:
> >
> > Agi wrote in message <7ou6a8$qto$1_at_nnrp1.deja.com>...
> > >Hello,
> > > Our DB is 8.0.5(OPS on IBM SP2 2 nodes),70GB data.
> > > Now, we use Recovery Manager to backup our db,but it takes too
> long.
> > > Are there any backup policy to speed the backup process, and easy
> to
> > > restore any tables from backup ?? and how ??
> > >
> >
> > Use RMAN to backup to disk (if you have enough) then backup to tape
at
> your
> > leisure ?
> >
> > Alex
> >

RMAN does OS file backups so like other hot or cold backups it protects you from media, disk, failures.

Exports on the other hand are snapshots at a particular point of a logical grouping of data, i.e., a table its indexes and triggers or all the objects for a user. They are useful to recover individual items where a process or user has corrupted table data, but there is no way in Oracle to apply updates that happened after the time of the export to a recovered table.

Media recovery however can reapply logged activity against the recovered file(s) to bring its contents to a point in time ususally the point in time where the media failure occurred.

There is an entire manual on backup and recovery for versions 7.3 and 8+.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 18 1999 - 11:16:17 CDT

Original text of this message

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