Re: RMAN backups while automatic archiving is disabled

"sree" <net_mall_at_yahoo.com> wrote in message news:36e58e89.0209090953.4f986136_at_posting.google.com...
> Hi,
>
> Looks like it is possible to take RMAN backups while the archiveloging
> is disabled. We have an instance that starts with archiver ON. Then,
> we disable the archivelog using "alter system archive log stop".
>
> I was under the impression that I need to enable logging before I take
> RMAN Backups. But, RMAN didn't complain about Archive Logging is
> disabled. I don't get any error.
>
> Is this normal ?? I read from Rman manual that RMAN backups can't be
> taken unless archive log is enabled.
>
> Any comments??

You're confusing things.
You can't make a *hot* backup with RMAN if the database is in *noarchivelog* mode. Which is something completely different from running in *archivelog* and *automatic archival stopped*. The database will continue to function until all online redologs needs archiving. At this point also your RMAN procedure is going to fail.

Also: RMAN still can make a *cold* backup of a databaase in noarchivelog mode, in fact it only can make that cold backup. That is also documented in the RMAN manual.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address