I have with rman backup:rman-06056: Could not access datafile
When I try to do a backup, I get error mensage:
RMAN> RUN {
2> ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
3> 4> set limit channel c1 kbytes=1000000;
5> set limit channel c2 kbytes=1000000;
6> BACKUP
7> DATABASE TAG 'DB_LEVEL0_WHOLE'
8> FORMAT '/backup/full/%d/%d%Y%M%D_full%t_%s_%p_%u.bkp'
9> PLUS ARCHIVELOG TAG 'ARCHIVEDLOGS'
FORMAT '/backup/arch/%d/%d%Y%M%D_arch%s_%p_%u.bkp'
10> skip inaccessible delete input;11>
12> RELEASE CHANNEL c1;
13> RELEASE CHANNEL c2;
14> }
allocated channel: c1
channel c1: sid=94 devtype=DISK
allocated channel: c2
channel c2: sid=59 devtype=DISK
Starting backup at 27-JAN-09
current log archived
archived log /kftprod/u01/app/oracle/oradata/kfcur/archive/kfcur_57617.arc not found or out
of sync with catalog
skipping inaccessible file /kftprod/u01/app/oracle/oradata/kfcur/archive/kfcur_57617.arc
archived log /kftprod/u01/app/oracle/oradata/kfcur/archive/kfcur_57618.arc not found or out
of sync with catalog
skipping inaccessible file /kftprod/u01/app/oracle/oradata/kfcur/archive/kfcur_57618.arc
Finished backup at 27-JAN-09
Starting backup at 27-JAN-09
released channel: c2
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/27/2009 10:26:45
RMAN-06056: could not access datafile 11
=========
Please, see below:
SQL> select FILE_ID,FILE_NAME
2 from dba_data_files
3 /
FILE_ID FILE_NAME
---------- --------------------------------------------------
1 /kftprod/u02/app/oradata/kfcur/system01.dbf
2 /kftprod/u02/app/oradata/kfcur/undotbs01.dbf
3 /kftprod/u02/app/oradata/kfcur/data_kfcur04.dbf
4 /kftprod/u02/app/oradata/kfcur/data_kfcur05.dbf
5 /kftprod/u02/app/oradata/kfcur/undotbs02.dbf
6 /kftprod/u02/app/oradata/kfcur/indx_kfcur01_03.dbf
7 /kftprod/u02/app/oradata/kfcur/indx_kfcur01_01.dbf
8 /kftprod/u02/app/oradata/kfcur/indx_kfcur01_02.dbf
9 /kftprod/u02/app/oradata/kfcur/indx_kfcur01_04.dbf
10 /kftprod/u02/app/oradata/kfcur/undotbs03.dbf
22 /kftprod/u02/app/oradata/kfcur/data_statspack01.db
f
25 /kftprod/u02/app/oradata/kfcur/data_kfcur01.dbf
27 /kftprod/u02/app/oradata/kfcur/data_kfcur02.dbf
28 /kftprod/u02/app/oradata/kfcur/data_kfcur03.dbf
14 rows selected.
I have a diference between dba_data_files and report schema
RMAN> report schema;
Report of database schema
File K-bytes Tablespace RB segs Datafile Name
---- ---------- -------------------- ------- -------------------
1 921600 SYSTEM YES /kftprod/u02/app/oradata/kfcur/system01.dbf
2 2048000 UNDOTBS1 YES /kftprod/u02/app/oradata/kfcur/undotbs01.dbf
3 1638400 DATA_KFCUR NO /kftprod/u02/app/oradata/kfcur/data_kfcur04.dbf
4 1638400 DATA_KFCUR NO
/kftprod/u02/app/oradata/kfcur/data_kfcur05.dbf
5 2048000 UNDOTBS1 YES /kftprod/u02/app/oradata/kfcur/undotbs02.dbf
6 512000 INDX_KFCUR01 NO
/kftprod/u02/app/oradata/kfcur/indx_kfcur01_03.dbf
7 2048000 INDX_KFCUR01 NO /kftprod/u02/app/oradata/kfcur/indx_kfcur01_01.dbf
8 2048000 INDX_KFCUR01 NO
/kftprod/u02/app/oradata/kfcur/indx_kfcur01_02.dbf
9 256000 INDX_KFCUR01 NO /kftprod/u02/app/oradata/kfcur/indx_kfcur01_04.dbf
10 512000 UNDOTBS1 YES
/kftprod/u02/app/oradata/kfcur/undotbs03.dbf
11 2048000 DATA_KFCUR01 NO /kftprod/u02/app/oradata/kfcur/data_kfcur01_01.dbf
12 2048000 DATA_KFCUR01 NO
/kftprod/u02/app/oradata/kfcur/data_kfcur01_02.dbf
22 512000 DATA_STATSPACK NO
/kftprod/u02/app/oradata/kfcur/data_statspack01.dbf
25 2048000 DATA_KFCUR NO /kftprod/u02/app/oradata/kfcur/data_kfcur01.dbf
27 1638400 DATA_KFCUR NO
/kftprod/u02/app/oradata/kfcur/data_kfcur02.dbf
28 1638400 DATA_KFCUR NO /kftprod/u02/app/oradata/kfcur/data_kfcur03.dbf
How can I solve it?
Thanks in advance.
Leonardo.
