how to recover lost datafile without backup of that datafile

article by Steve


http://www.databasejournal.com/features/oracle/article.php/3757371/Hands-on-Oracle-Backup-and-Recovery-Games---Creating-Datafiles.htm

sql>alter database create datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEMO\USERS02.DBF';

sql>recover datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEMO\USERS02.DBF';

http://arjudba.blogspot.com/2008/05/recover-lost-datafile-without-backup.html


http://www.orafaq.com/node/2402

http://boomslaang.wordpress.com/2008/10/14/recovery-of-non-system-datafile-without-backup/

http://gavinsoorma.com/oracle-goldengate-veridata-web/

oracle Table Fragmentation

http://oracle-online-help.blogspot.com/2007/02/identify-and-fix-table-fragmentation-in.html

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1295801859138

wait events

http://umardba.blogspot.com/2009/11/true-session-wait-activity-in-oracle.html