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: Dino Ming <dinoming_at_hotmail.com>
Date: Tue, 28 May 2002 17:49:37 +0800
Message-ID: <acvjrf$bbk$1@tenorhorn.hk.dyxnet.com>


But, One things I need to clarify first ... Do I need to backup the oracle db programs and 9ias programs also (eg. backing up the Instance mount point totally) ?

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:lWzI8.21$xn.143_at_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 Tue May 28 2002 - 04:49:37 CDT

Original text of this message

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