Oracle Database Express Edition (XE)

Hi everybody.

One of my client experienced a problem. Following there is the text in oxe_backup_current.log file. Backup is invoked by the proper command in Start menu. Database is in archivelog mode.

Do you have any suggestion for them?

Thanks
Filippo


Recovery Manager: Release 10.2.0.1.0 - Production on Wed Apr 1 13:45:01 2009

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

Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1056M/2046M, Ph+PgF:2638M/3945M, VA:2001M/2047M
Starting with debugging turned off

connected to target database: XE (DBID=2538149524)

RMAN> set echo on;
2> configure controlfile autobackup format for device type disk clear;
3> configure retention policy to redundancy 2;
4> configure controlfile autobackup on;
5> sql "create pfile=''C:\ORACLE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile";
6> backup as backupset device type disk database;
7> configure controlfile autobackup off;
8> sql 'alter system archive log current';
9> delete noprompt obsolete;
10>
echo set on

using target database control file instead of recovery catalog
RMAN configuration parameters are successfully reset to default value

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

sql statement: create pfile=''C:\ORACLE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SPFILE2INIT.ORA'' from spfile

Starting backup at 01-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=18 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\ORADATA\XE\SYSTEM.DBF
input datafile fno=00003 name=C:\ORACLE\ORADATA\XE\SYSAUX.DBF
input datafile fno=00002 name=C:\ORACLE\ORADATA\XE\UNDO.DBF
input datafile fno=00004 name=C:\ORACLE\ORADATA\XE\USERS.DBF
channel ORA_DISK_1: starting piece 1 at 01-APR-09
channel ORA_DISK_1: finished piece 1 at 01-APR-09
piece handle=C:\ORACLE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\BACKUPSET\2009_04_01\O1_MF_NNNDF_TAG20090401T134505_4X6NY18T_.BKP tag=TAG20090401T134505 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 01-APR-09

Starting Control File and SPFILE Autobackup at 01-APR-09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 04/01/2009 13:45:31
RMAN-10035: exception raised in RPC:
ORA-19624: operation failed, retry possible
ORA-19599: block number 350 is corrupt in control file C:\ORACLE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 4882
RMAN-10031: RPC Error: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DOAUTOBACKUP

Recovery Manager complete.