Visit Counter

Wednesday, February 19, 2014

RMAN-06023: no backup or copy of datafile 1 found to restore



RMAN> restore database;

RMAN-06023: no backup or copy of datafile 1 found to restore






RMAN> catalog recovery area;

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_nnndf_TAG20140219T133441_9j9yb1sq_.bkp
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_annnn_TAG20140219T133522_9j9ycbjd_.bkp
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_ncsnf_TAG20140219T133441_9j9yc92d_.bkp
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_annnn_TAG20140219T133433_9j9y9t69_.bkp

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_nnndf_TAG20140219T133441_9j9yb1sq_.bkp
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_annnn_TAG20140219T133522_9j9ycbjd_.bkp
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_ncsnf_TAG20140219T133441_9j9yc92d_.bkp
File Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_annnn_TAG20140219T133433_9j9y9t69_.bkp






RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    963.23M    DISK        00:00:00     20-FEB-12    
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140219T133441
        Piece Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_nnndf_TAG20140219T133441_9j9yb1sq_.bkp
  List of Datafiles in backup set 5
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1098780    19-FEB-14 /ora/oracle/base/oradata/afiprim/system01.dbf
  2       Full 1098780    19-FEB-14 /ora/oracle/base/oradata/afiprim/sysaux01.dbf
  3       Full 1098780    19-FEB-14 /ora/oracle/base/oradata/afiprim/undotbs01.dbf
  4       Full 1098780    19-FEB-14 /ora/oracle/base/oradata/afiprim/users01.dbf

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
6       32.00K     DISK        00:00:00     20-FEB-12  
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140219T133522
        Piece Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_annnn_TAG20140219T133522_9j9ycbjd_.bkp

  List of Archived Logs in backup set 6
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    11      1098761    20-FEB-12 1098832    20-FEB-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    9.36M      DISK        00:00:00   20-FEB-12      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140219T133441
        Piece Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_ncsnf_TAG20140219T133441_9j9yc92d_.bkp
  SPFILE Included: Modification time: 20-FEB-12
  SPFILE db_unique_name: AFIPRIM
  Control File Included: Ckp SCN: 1098820      Ckp time:20-FEB-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
8       215.23M    DISK        00:00:00     20-FEB-12      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20140219T133433
        Piece Name: /ora/oracle/base/flash_recovery_area/AFISTND/backupset/2014_02_19/o1_mf_annnn_TAG20140219T133433_9j9y9t69_.bkp

  List of Archived Logs in backup set 8
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       949180     20-FEB-12 959894     20-FEB-12
  1    3       959894     20-FEB-12 970908     20-FEB-12
  1    4       970908     20-FEB-12 970945     20-FEB-12
  1    5       970945     20-FEB-12 973569     20-FEB-12
  1    6       973569     20-FEB-12 973650     20-FEB-12
  1    7       973650     20-FEB-12 998626     20-FEB-12
  1    8       998626    20-FEB-12 1038882    20-FEB-12
  1    9       1038882    20-FEB-12 1079885    20-FEB-12
  1    10      1079885    20-FEB-12 1098761    20-FEB-12

1 comment:

  1. Dear Muhammad Asif
    Please look into this issue.
    My database is 11gR2 running on WindowsXp
    I am unable to open the database
    I have no backups, too.
    following is the error messages.

    SQL> alter database open;
    alter database open
    *
    ERROR at line 1:
    ORA-01115: IO error reading block from file 3 (block # 200)
    ORA-01110: data file 3: 'E:\APP\USER\ORADATA\AISM\UNDOTBS01.DBF'
    ORA-27070: async read/write failed
    OSD-04016: Error queuing an asynchronous I/O request.
    O/S-Error: (OS 23) Data error (cyclic redundancy check).

    ReplyDelete