will there be data loss?
Date: Wed, 27 Feb 2008 11:33:43 -0800 (PST)
Message-ID: <4c941a20-1420-4718-b6b9-50b39645e056@d62g2000hsf.googlegroups.com>
10.2.0.2 EE, AIX 5.2 64bit. RMAN 10.2.0.2
I have run the scenario and know the outcome, but was surprised kind of.
database is in archivelog mode. I start up rman and connect to target
and catalog then take a hot tablespace backup of the users tablespace
which is made up of one datafile.
I then proceed to log in via sqlplus and create a new table
balvey.testing( txt varchar2(200), numb1 number) tablespace users;
and insert 4 records and commit
alter system switch logfile
select count(*) from balvey.testing and see the 4 records.
exit sqlplus and using os commands I delete the one and only datafile that makes up the tablespace
If I log into the database again and insert records into the newly created balvey.testing and commit. Will the data that was inserted after deleting the datafile be lost? Received on Wed Feb 27 2008 - 13:33:43 CST