Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup Suggestion.
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