I have experienced something which I wanted to share with you all. In order to recover data after losing it and without having archivelog backup did below.
Please note my DB is in archivelog mode.
1. I created table with 4 rows.
2. Took backup database.
didnot take backup database with archivelog. but my database is in archivelogmode.
3. inserted 4 more rows after the backup.
4. I deleted that datafile carrying that table.
5. startup mount
restore datafile 9
recover datafile 9
6. open the database ;
7. could see all 8 rows:-
My question is "recover datafile id " will apply archives on its own from archive log destination?
Why I didnot see this below :
-ORA-00279: change 92069000 generated at 06/09/2011 14:03:59 needed for thread 1
ORA-00289: suggestion :
ORA-00280: change 92069000 for thread 1 is in sequence #72
Please advise what you think!