Oracle Database Discussions

hi experts,

i was practicing some backup and recovery scenario, and wonder how can we recover deleted rows (records) in following situation:-

1.*without* archive log and without flashback database
2. with archive log mode and without flashback database.
3. without archive log and with flashback database enable (default value for db_flashback_retention_target)
4. both archive log and flashback enable.

assuming we are using oracle 10.2 on windows server 2003....*and one more thing database is OLTP system and can't be taken down..*(looks very critical)

this might look silly question to all you experts, but it holds a great meaning to me..say i have deleted 20 records (rows) from table T1 and and we deleted records at 1:00 PM and came to know at about 3:30 PM....

i know this is very basic scenario for most of you, but i would like to know exact steps that should be followed...


any suggestion will be appreciable...

Thanks and Regards
VD

Edited by: vikrant dixit on Apr 2, 2009 9:58 PM

Edited by: vikrant dixit on Apr 2, 2009 9:58 PM