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 Suggestion.

Re: Backup Suggestion.

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 28 May 2002 10:08:38 +1000
Message-ID: <lWzI8.21$xn.143@news.oracle.com>


Yes. You have archives. You have a backup. Ergo, you can restore a component from the backup and roll it forward using the archives.

Archive Logs are not online, by the way. The moment ARCH finishes writing to them, they are closed and very definitely offline.

Regards
HJR "Dino Ming" <dinoming_at_hotmail.com> wrote in message news:acs6n8$3ba$1_at_tenorhorn.hk.dyxnet.com...
> Dear All,
>
> Here is the backup planning for Oracle db & 9iAS...., Can this backup
> provide us the "Recovery to the time of failure", please
> advice me if I have any missing step.
>
> --------------------------------------------------------------------------

--

> --------
>
> Monday : Backup Archived Log Only (Online)
> Tuesday : Backup Archived Log Only (Online)
> Wednesday : Backup Archived Log Only (Online)
> Thursday : Backup Archived Log Only (Online)
> Friday : Backup Archived Log Only (Online)
> Saturday : Full Backup (Offline) : All Control,Database,Password
and
> initXXX.ora files,
> Sunday : -N/A-
>
> Every last day of the month, take a Full offline backup Oracle DB & Oracle
> 9iAS.
>
> --------------------------------------------------------------------------
--
> --------
>
>
Received on Mon May 27 2002 - 19:08:38 CDT

Original text of this message

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