Recovery From Loss Of Datafile For Which No Backup Is Available
- Posted by Gavin Soorma
- On July 2, 2009
- 3 Comments
SCENARIO – 10g Database Loss of datafile which has not been backed up. CREATE NEW TABLESPACE TEST SQL> create tablespace test datafile ‘/u02/oradata/testdb/test.dbf’ size 10m; Tablespace created. TAKE A BACKUP OF THE DATABASE AT THIS POINT >>>>>>>>> ADD DATAFILE TO TEST TABLESPACE SQL> alter tablespace test add datafile ‘/u02/oradata/testdb/test01.dbf’ size 10m; Tablespace altered. SIMULATE FAILURE […]
Read More