Re: rman backups

  • From: "Mark Brinsmead" <pythianbrinsmead@xxxxxxxxx>
  • To: orcl@xxxxxxxxxxx
  • Date: Tue, 7 Nov 2006 18:18:13 -0700

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@xxxxxxxxxxx> 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

Other related posts: