RE: Nagging RMAN error

From: Fred Smith <fred_fred_1_at_hotmail.com>
Date: Thu, 15 Sep 2005 12:07:14 -0400
Message-ID: <BAY107-F18D91CD041D20A933FE5EDFE9E0@phx.gbl>

Yes, strangely enough I can touch a file there without error.

And the directory exists with fully open permissions:

bell1{oracle}:/xfer/rman_backups/bell1_nic=> pwd
/xfer/rman_backups/bell1_nic
bell1{oracle}:/xfer/rman_backups/bell1_nic=> ls -la
total 155350384
drwxrwxrwx   3 oracle   dba         2048 Sep 15 12:00 .
drwxr-xr-x   3 oracle   other       1024 Sep  2 21:20 ..
-rw-r-----   1 oracle   dba      2891296768 Sep 14 16:28 
bell1_nic_archivelogs_20050914_NIC_1igukio3_1_1.arc
-rw-r-----   1 oracle   dba      2790060544 Sep 14 16:36 
bell1_nic_archivelogs_20050914_NIC_1jgukj7v_1_1.arc
drwxrwxrwx   2 oracle   dba         1024 Sep 15 12:06 control_files
-rw-r-----   1 oracle   dba      12286288384 Sep  2 15:58 
full_backup_20050902_NIC_12gtkqjg_1_1.bus
-rw-r-----   1 oracle   dba      12286288384 Sep  6 16:32 
full_backup_20050906_NIC_18gtvdh3_1_1.bus
-rw-r-----   1 oracle   dba      12301451776 Sep  7 16:52 
full_backup_20050907_NIC_1agu23ll_1_1.bus
-rw-r-----   1 oracle   dba      12301451776 Sep  8 15:59 
full_backup_20050908_NIC_1cgu4k8f_1_1.bus
-rw-r-----   1 oracle   dba      12308103680 Sep  9 11:29 
full_backup_20050909_NIC_1egu6p4k_1_1.bus
-rw-r-----   1 oracle   dba      12335448576 Sep 14 14:42 

full_backup_20050914_NIC_1ggukaod_1_1.bus bell1{oracle}:/xfer/rman_backups/bell1_nic=>

>From: "Hallas, John, Tech Dev" <John.Hallas_at_gb.vodafone.co.uk>
>To: <fred_fred_1_at_hotmail.com>, <oracle-l_at_freelists.org>
>Subject: RE: Nagging RMAN error
>Date: Thu, 15 Sep 2005 16:32:17 +0100
>
>Can you touch a file of that name to create one?
>It seems to suggest a problem creating the file
>
>Sorry to be so obvious
>
>oerr ora 19504
>19504, 00000, "failed to create file \"%s\""
>// *Cause: call to create file returned an error
>// *Action: check additional messages, check access permissions
>
>John
>
>-----Original Message-----
>From: oracle-l-bounce_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith
>Sent: 15 September 2005 16:25
>To: oracle-l_at_freelists.org
>Subject: Nagging RMAN error
>
>Hello,
> I setup a simple RMAN solution to backup a local database. It writes
>to a
>disk channel, not tape. So I am easily able to verify that something is
>written each time. It backs up the database files without error, but
>I'm
>constantly getting an error when it attempts to backup the controlfile.
>
>Oddly enough, after it tries to backup the controlfile, the date/time
>stamp
>changes in the disk channel for the controlfile, but at the RMAN console
>I
>ALWAYS get the same error message group:
>
>Starting Control File Autobackup at 14-SEP-05
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03009: failure of Control File Autobackup command on ORA_DISK_1
>channel at 09/14/2005 16:33:56
>ORA-19504: failed to create file
>"/xfer/rman_backups/bell1_nic/control_files/controlfile_NICxxxxx_c-53732
>8752-20050914-01_20050914.ctl"
>ORA-27037: unable to obtain file status
>SVR4 Error: 20: Not a directory
>Additional information: 4
>
>
>Does anyone know why I keep getting this? As I said "something" is
>happening
>in the disk channel, the timestamp on the file is changing.
>
>Thank you!
>
>

---

Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 15 2005 - 11:09:28 CDT