how long redo logs keep the transactions?
841763Feb 22 2011 — edited Feb 24 2011I learn Oracle and decide to do an experiment. There was a table in the test database. I deleted the file that contained this table via OS. And then I added transactions to this table.
I did 'insert' several times, then 'commit', then 'alter system switch logfile' several times, 'alter system flush buffer_cache', 'alter system flush shared_pool' and nothing happened. I could add and take data from this table successfully. Alert log showed the error only when I shutdown the database.
SQL> shutdown immediate
ORA-01116: error in opening database file 13
ORA-01110: data file 13: '/oracle/oradata/test5/POSTEMPTEST2.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
I understand that transactions are put in the redo logs at first, and then are transferred to the datafile on disk. I thought that command 'ALTER SYSTEM CHECKPOINT' writes transactions from redo logs to datafile on disk, but I was wrong. How long redo logs keep transactions? Is there the way to push data from redo logs to datafile?
I use Oracle 10.2.0.1.0.