I have ORA-01033 and ORA-01113: file 1 needs media recovery errors, i tried using recovery manager to no avail all I got after a long wait cataloging files... is ORA-19870: ERROR READING BACKUP PIECE, ORA-19501: READ ERROR ON FILE, ORA-27070: ASYNC READ/WRITE FAILED, OSD-04016: ERROR QUEUING AN ASYNCHRONOUS I/O REQUEST...then...failover to previous backup...then RMAN-00571; 00569; 03002; 06026; 9 06023:::I have exhausted all the tips I know...PLS HELP
Thanks for your reply Yoonus. I am running Oracle Database XE on Windows XP. I have ARCHIEVELOG ON and I think thats the backup.. These are the commands I used in recovery manager:
rman target /
restore controlfile from autobackup;
alter database mount;
alter database open resetlogs;
After restoring the controlfile from autobackup, "list backup" is listing the backup you want to restore?, If not Catalog the previous backup and run restore
I was meaning to post rman output as well while you are running all these commands .
I lost the database. I reinstalled Oracle Database xe but the backup from my former flash recovery area didn't work. Fortunately I have a backup of the schema objects ddl and table data backup using the export utility. that was how I recovered the database losing only recent data.