Re: rman backups

  • From: Bob <orcl@xxxxxxxxxxx>
  • Date: Tue, 07 Nov 2006 07:13:39 -0500

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.


At first glance it looks sexy but you soon realize that you have nothing more than a cold backup.
Drawbacks to this (cold method) are:
database needs to be shutdown
any changes between backups  would be lost.

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

Sexy (for me), is incremental merged backups with block change tracking
;-)
My 2cts
Bob

Zelli, Brian wrote:

Hello all,
I've decided to become more intimate with using rman as opposed to cron scripting. So, my first attempt at a test database bombs because of the database not being in ARCHIVELOG mode. I did a google to see if I can actually backup a db in NOARCHIVELOG mode and on Ask Tom, it says yes. I looked at the solution and it doesn't make any sense. Has anybody done this, a backup in NOARCHIVELOG mode using rman? ciao,
Brian
*Brian J. Zelli*
Sr. Database Administrator
Enterprise Application/Systems Integration
Information Technology - Roswell Park Cancer Institute
phone: (716) 845-4460 email: brian.zelli@xxxxxxxxxxxxxxx <mailto:brian.zelli@xxxxxxxxxxxxxxx> This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.


--
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."

Other related posts: