Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx02.iad01.newshosting.com!newshosting.com!198.186.194.249.MISMATCH!transit3.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!73g2000hsx.googlegroups.com!not-for-mail From: artmerar@yahoo.com Newsgroups: comp.databases.oracle.server Subject: Re: RMAN Archivelog question Date: Tue, 9 Sep 2008 07:41:40 -0700 (PDT) Organization: http://groups.google.com Lines: 30 Message-ID: <269d3c58-a202-49f9-85d8-7d1fbb6898a1@73g2000hsx.googlegroups.com> References: <6c5339dd-56aa-4f7d-9033-e78141fb2557@y38g2000hsy.googlegroups.com> NNTP-Posting-Host: 208.65.116.5 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1220971301 22828 127.0.0.1 (9 Sep 2008 14:41:41 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Tue, 9 Sep 2008 14:41:41 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: 73g2000hsx.googlegroups.com; posting-host=208.65.116.5; posting-account=Te8R5QoAAAD0OcZ51Bsj60HqyktlOVZb User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1,gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:447865 X-Received-Date: Tue, 09 Sep 2008 10:41:41 EDT (text.usenetserver.com) On Sep 8, 4:47=A0pm, sybra...@hccnet.nl wrote: > On Mon, 8 Sep 2008 11:01:47 -0700 (PDT), artme...@yahoo.com wrote: > >If you use the DELETE INPUT in your backup command (PLUS ARCHIVELOG), > >would you even need to do a crosscheck? > > A crosscheck is necessary when someone decides to delete backups or > archivelogs without using RMAN, ie directly from the OS. > > It is appreciated > a) you answer doc questions yourself by reading the docs > b) don't ask questions two times within a few minutes. > > -- > Sybrand Bakker > Senior Oracle DBA Sybrand, Sometimes the documentation is not really clear. For example, if I use a recovery window, say 2 weeks, and my archive logs are included in my level 0 backup and I use a DELETE INPUT to remove the archive logs. Why would I need a crosscheck for archive logs? They are included in the backup, and they have been removed once backed up. Additionally, I'm assuming that I would not need a 'DELETE ARCHIVELOG' statement either. The docs are not very clear on this........ Regards.