Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup Suggestion.
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.
>
> --------------------------------------------------------------------------
--Received on Mon May 27 2002 - 19:08:38 CDT
> --------
>
> 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.
>
> --------------------------------------------------------------------------
--
> --------
>
>