Re: Backup Strategy?
Date: 27 Feb 2003 02:16:19 -0800
Message-ID: <a20d28ee.0302270216.17ec9576_at_posting.google.com>
"James" <james_at_nothing.com> wrote in message news:<1046267656.906345_at_ftp.adept.co.za>...
> Hi there
> I have the following backup strategy and I want to know if you all think it
> is aceptable.
>
> I'm using oracle 9 and running on windows 2k. I want it to run 24/7 so I'm
> using online hot backups and my database is in Archive mode.
>
> Method
> I perform a Backup of my tablespaces, control files and Archivelogs once a
> week and then on the rest of the days I just backup the Archive logs.
> Is this a suitable recovery strategy?
>
> Thanks in advance
> Cheers
> James
No.
The time needed to recover would get longer and longer, depending on
which moment the database crashes.
In this scenario, knowledge of Murphy's law predicts disaster will
always strike on Friday.
Regards
Sybrand Bakker
Senior Oracle DBA
Received on Thu Feb 27 2003 - 11:16:19 CET