DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: I have with rman backup:rman-06056: Could not access datafile

  1. #1
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22

    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.

  2. #2
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    why is are the tablespaces inaccessible...have the datafiles been deleted from OS?


    try the below command

    backup datafile 11 preview;

    Post the error which you are getting.

  3. #3
    Join Date
    Feb 2002
    Posts
    5

    Vgm

    Check status of the data files by following statement.

    Select status from dba_data_files;

    The datafiles with AVAILABLE should be okay for RMAN backup.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width