Friday, April 8, 2011

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/

No comments: