From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: RMAN backups while automatic archiving is disabled Date: Mon, 9 Sep 2002 21:47:32 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: "Sybrand Bakker" References: <36e58e89.0209090953.4f986136@posting.google.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Complaints-To: abuse@supernews.com Lines: 40 "sree" wrote in message news:36e58e89.0209090953.4f986136@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