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.
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks