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
Dear Muhammad Asif
ReplyDeletePlease 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).