Database Software

Hello All,

I once posted this and its back. My current flash_recovery_area is set at: '/image0/flash_recovery_area/SXE,

/image4/flash_recovery_area/SXE is an old location, bit it seems to harp on this when I schedule a full RMAN backup using OEM. I'm on Oracle 10.2.0.1,
SUSe9 OS, 32 bit ARCHIVELOG mode. The logfile below will tell the story. Should I do a manual RMAN Level 0? What would be the syntax for
that?

Thanks,

RB


Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 15 13:40:06 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN>
connected to target database: SXE (DBID=1896902343)
using target database control file instead of recovery catalog

RMAN>
echo set on


RMAN> run {
2> allocate channel oem_disk_backup type disk format '/image0/flash_recovery_area/SXE/%U'
3> ;backup as BACKUPSET current controlfile tag '06152009053406';
4> restore controlfile validate from tag '06152009053406';
5> release channel oem_disk_backup;
6> }
allocated channel: oem_disk_backup
channel oem_disk_backup: sid=354 devtype=DISK

Starting backup at 15-JUN-09
channel oem_disk_backup: starting full datafile backupset
channel oem_disk_backup: specifying datafile(s) in backupset
released channel: oem_disk_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on oem_disk_backup channel at 06/15/2009 17:40:08
ORA-01580: error creating control backup file /image4/flash_recovery_area/SXE
ORA-27056: could not delete file
Linux Error: 21: Is a directory

RMAN> allocate channel for maintenance type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=354 devtype=DISK


RMAN> delete noprompt backuppiece tag '06152009053406';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 06/15/2009 13:40:08
RMAN-06168: no backup pieces with this tag found: 06152009053406


RMAN> exit;

Recovery Manager complete.

Edited by: ronthe11gdba on Jun 15, 2009 6:29 PM