Re: RMAN backups while Automatic Archiving is Disabled

sree <member_at_dbforums.com> wrote in message news:<1793638.1031593603_at_dbforums.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??

"alter system archive log stop" does not take the database out of archivelog mode. It stops the automatic archiving of the redo logs. If all your redo logs filled up, your database would stop allowing transactions until you manually issued the command to archive the logs. To take the database out of archivelog mode you need to issue an alter database command (not alter system). Received on Tue Sep 10 2002 - 15:42:11 CEST