Path: text.usenetserver.com!out02b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.k-dsl.de!feeder.erje.net!lightspeed.eweka.nl!81.171.88.16.MISMATCH!eweka.nl!hq-usenetpeers.eweka.nl!69.16.177.246.MISMATCH!cyclone03.ams.highwinds-media.com!news.highwinds-media.com!npeersf02.ams.highwinds-media.com!newsfe17.ams2.POSTED!7564ea0f!not-for-mail From: Palooka User-Agent: Thunderbird 2.0.0.16 (X11/20080724) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: RMAN Moving Archivelogs References: <7c5355ee-fb96-4190-8e42-1d2860e19d85@d45g2000hsc.googlegroups.com> In-Reply-To: <7c5355ee-fb96-4190-8e42-1d2860e19d85@d45g2000hsc.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 29 Message-ID: NNTP-Posting-Host: 82.2.162.90 X-Complaints-To: http://netreport.virginmedia.com X-Trace: newsfe17.ams2 1221005207 82.2.162.90 (Wed, 10 Sep 2008 00:06:47 UTC) NNTP-Posting-Date: Wed, 10 Sep 2008 00:06:47 UTC Organization: virginmedia.com Date: Wed, 10 Sep 2008 01:07:17 +0100 Xref: usenetserver.com comp.databases.oracle.server:447885 X-Received-Date: Tue, 09 Sep 2008 20:06:48 EDT (text.usenetserver.com) artmerar@yahoo.com wrote: > We are about to implement our RMAN backups, thanks to everyone here > and their advice. One question, say our archive destination fills > up. We currently have a script which moves all but the latest 3 > files. > > How would I tell RMAN where the archivelogs have been copied to? We > are not using a recovery catalog...... > > Regards. My advice is don't move the archivelogs about. Archive to the FRA, and have RMAN backup database plus archivelog (having set a recovery window according to your business requirements). Set control_file_record_keep_time to your recovery window plus a day. Delete noprompt obsolete by all means, but don't go removing files from the FRA at the OS level, or Oracle will lose track, and you will waste time unnecessarily doing all the crosschecking. While you are about it, I'd recommend configuring controlfile autobackup on; then your controlfile and spfile get an extra backup at negligible cost. As long as you have made a note of the DBID you can recover the current state from pretty well anything, except loss of all online redo logs (but you mirror them at the Oracle level, don't you?). HTH, Palooka