Re: rman backups

To take Bob's comments one step farther...

If your data is worth the trouble of backing up, archivelog mode is (almost) mandatory.

Does your management understand that doing offline backups (without archivelogging -- after all, cold backups don't preclude archivelog mode) leaves you in a position where a serious system failure (maybe coupled with one bad tape cartridge) could cause you to lose several days' worth of data? Are they okay with that?

The incrementa cost of running in archivelog mode is (for most organizations) a nit compared to the risk of operating without it.

On 11/7/06, Bob <orcl_at_comcast.net> wrote:
>
> Hi Brian, Im surprised no one has mentioned that backing up with rman
> in no archive log mode will give you nothing more than an rman managed cold
> backup.
>
> ...
>
> Maybe you "cant" run in ALMode (management reasons) but if your goal is to
> "...become more intimate..." with rman- then archivelog mode is mandatory.
> The good thing about using rman is that it manages (deletes obsolete,
> applies recovery) of archive logs for you. Minimal manual intervention is
> needed to manage, or apply archive logs
>
> ...
>

-- 
Cheers,
-- Mark Brinsmead
   Senior DBA,
   The Pythian Group
   http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l