Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h3B0VFA04987 for ; Thu, 10 Apr 2003 19:31:15 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h3B0VFA04982 for ; Thu, 10 Apr 2003 19:31:15 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id PAA82950; Thu, 10 Apr 2003 15:12:00 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0057F49E; Thu, 10 Apr 2003 14:33:50 -0800 Message-ID: Date: Thu, 10 Apr 2003 14:33:50 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: DENNIS WILLIAMS Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: DENNIS WILLIAMS Subject: RMAN Backup control file Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit In setting up RMAN on Oracle 8.1.6, I found it very convenient to have a backup controlfile. This is a good idea anyway. I added the following line to the backup script: sql "alter database backup controlfile to ''$BACKUP_DIR/control_`date +%y%m%d`.ctl''"; This produces the following error: RMAN-06162: sql statement: alter database backup controlfile to ''/rman3/fin7/control_030410.ctl'' RMAN-03023: executing command: sql RMAN-03026: error recovery releasing channel resources RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03006: non-retryable error occurred during execution of command: sql RMAN-07004: unhandled exception during command execution on channel default RMAN-20000: abnormal termination of job step RMAN-11003: failure during parse/execution of SQL statement: alter database backup controlfile to '/rman3/fin7/control_030410.ctl' RMAN-11001: Oracle Error: ORA-01585: error identifying backup file /rman3/fin7/control_030410.ctl ORA-27086: skgfglk: unable to lock file - already in use Compaq Tru64 UNIX Error: 77: No locks available Additional information: 8 RMAN> Recovery Manager complete. It actually produces the requested control file, but in the one time I've been able to test it, the file was corrupted. Any suggestions? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. dwilliams@lifetouch.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS@LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).