Quote:
Originally posted by ashley75
I am in the process of practice to recover the rollback datafiles, I followed these steps from the backup and recovery book but it's wrong. The name of the book is Oracle 8i backup & recovery by RAMA VELPURI.
any way , here are the summary:
1. I created a table
2. set transaction use rollback segment rb1
3. insert one record into this table
4. shutdown abort
5. del rbs1orcl.ora datafile
6. copy the rbs1orcl.ora from the backup
7. uncomment out the ROLLBACK_SEGMENTS in the init.ora
8. startup mount;
9. alter database datafile 'c:\oradata\rbs1.dbf' offline;
10. alter database open
and I got the errors:
*
ORA-00604: error occured at recursive SQL level 2
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'c:\ORADATA\RBS1.DBF'
please advise b/c the book is not right. According to the book, I should be able to open the database.
Please help
The file has the name rbs1.dbf, and when you say you have copied from backup you mention the name rbs1orcl.ora which is not the same. Rename it and try again.