Recovery From Loss Of Datafile For Which No Backup Is Available

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 […]